Re: dbexport
Posted in 1997
Steve Romankiw <sromankiw@execrisk.com> wrote in article
<5fhonp$s2p@cssun.mathcs.emory.edu>...
> I am using dbexport to get unload data from one database and loading
> into another. I noticed that in the *.sql that the dbspace locations
> have been omitted. Since we have tables spread across various dbspaces
> (non-fragmented tables), it is important to maintain this information in
> the *.sql file. To run dbexport, I used the following commands:
> dbexport -d <db> -c <dir> -ss -q. I was hoping the -ss would be give me> database specific information.
>
> Any ideas on how I can get the table locations included in the *.sql
> file?
The -ss option works for me with On-Line 7.20 (SCO OpenServer). It keeps
first & next extent sizes, lock level on dbspace.
>
> Thanks.
>
> Steve Romankiw
> Executive Risk Inc.
>