Don't edit the dmp file! Use the indexfile method and precreate the tables.
If you have 8i or 9i then use locally managed tablespaces and use uniform
extents.
Jim
"Otto Norse" <ottonorse_at_yahoo.com> wrote in message
news:5330c896.0111291030.5b2154b8_at_posting.google.com...
> I've deleted a very large percentage of the data from a database.
> I now want to create a new user that is sized on the current amount
> of data and not the existing sizing.
>
> One idea was to exp the user, then alter the dmp file with SED to
> search and replace large initial / next extent statements. Looking at
> other posts at google, I see there is some discrepancy whether this is
> safe or not (as the dmp is a binary file).
>
> I've also looked at doing an IMP SHOW=Y INDEXFILE=foo.sql, then editing
> foo.sql.
>
> Any comments on either approach or even a different method of making a
> big, mostly empty database into a small one?
>
> Thanks,
> ON
Received on Thu Nov 29 2001 - 13:24:34 CST
