Re: exp/imp and extents

> Here's another educational trick:
>
> use the unix strings command on the export file and grep the result
> for the table name, or maybe the string CREATE TABLE.
>
> strings expdat.dmp |grep "CREATE TABLE"|more

Or use the INDEXFILE option of the imp utility to create a DDL script. Then using this information, precreate the table with an appropriate INITIAL and NEXT. Then import with IGNORE=Y.

Personally, I like to upgrade to LMTs and start living!!!

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"