ASA unload/reload question
- From: ever90321@xxxxxxxxxxx
- Date: Wed, 12 Mar 2008 11:14:19 -0700 (PDT)
Hello,
Newbie question coming... I'd like to reclaim wasted space in a
Sybase ASA 9 database using the unload/reload technique. I have the
unload part down fine, but am a little sketchy about reloading. This
database came bundled with a commercial application. Since I didn't
create it, making a new database manually asks questions about case
sensitivity, trailing spaces, etc. that I can't answer, as I can't
find these settings on the existing database. What I'd prefer to do
is purge its "guts" and reload the structure and data right back
inside. I can probably figure this out with trial and error, but
would like to learn the proper technique. Is there an area in Sybase
Central where I can find all the setup options for the existing
database, or is there a simple command I can run from dbisqlg.exe to
to remove all the structures and data without erasing the database
itself?
Thanks in advance for your feedback,
Todd
.
- Follow-Ups:
- Re: ASA unload/reload question
- From: David Kerber
- Re: ASA unload/reload question
- Prev by Date: Re: bcp out fails with CTLIB Message: - L5/O1/S5/N18/5/0 when using -A
- Next by Date: Re: ASA unload/reload question
- Previous by thread: Re: Repeat command isql without typing
- Next by thread: Re: ASA unload/reload question
- Index(es):
Relevant Pages
|
Loading