Just export with compress=y and rows=n.
That will give you a nice skeleton for re-creating
a database that will have enough compacted space
for all your data in your export with compress=n.
Takes no time at all.
--
Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
Is there a nospam domain?
http://www.users.bigpond.net.au/the_Den
Igor P. Merku <igor.merku_at_acegas.ts.it> wrote in message
news:37B7C237.686FCC1F_at_acegas.ts.it...
>
>
> Ed Stevens wrote:
>
> > I don't have any direct, first hand experience with this particular
> > scenario, but I notice that with your different combinations, you never
> > tried compression=N. Compression will always consume more time.
> >
>
> This is true, Ed, and thank you for your reply.
> We found compress=Y a good way to have Oracle calculate the first extent to
> cope with a table's data for reimport. How should I handle this in your
> opinion (export with compression=Y once in a while and extract initial
> extent data) ?
>
> Thank you very much.
> Regards, Igor
>
Received on Mon Aug 16 1999 - 08:38:32 CDT
