Re: export no row size

Hi Steve,

the default behaviour of "exp" is to compress all table data into one extent (option COMPRESS=Y). I.e. if table BLA consists out of 10 extents á 20Mbyte in your source database, the initial extent of table BLA in target will be 200MByte --> the same size as in source. Try to use COMPRESS=N If in your source database tables consist out of one big initial extent (may be they have been reorganized recently ...), the new tables in the target will have the same size (respectively the same value for initial). If you want to use only the structure, you can manually edit the sql statements by using imp with option INDEXFILE=<filename>. This will create the file <filename> which contains the whole database structure (in sql statements). The file can be edited to meet your requirements.

regards
Hartmut

"Steve" <schen_at_prodigy.net> schrieb im Newsbeitrag news:PZbk8.3926$At2.689374389_at_newssvr17.news.prodigy.com...
> Hello,
>
> I found that import to other database using "export no row" would get the
> same size of original database.
>
> Is there anyway to make the importing (the structure only) size smaller?
>
> Thanks,
>
> Steve
>
>
Received on Fri Mar 15 2002 - 02:55:19 CST