Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: storage in import
exp compress=n. This will *not* allocate an initial extent the size of the
table.
Niall
"andy" <bettati_at_infinito.it> wrote in message
news:3bac7e32.65220187_at_news.infinito.it...
> I have an Oracle database with some big tables. I need to have an
> empty dump of tables (using exp ... rows=n).
> In this way when i import dump on new database, i have a large amount
> of space allocated without data.
> I would like to have a minimal space occupation.
> I work with 7.3.4 and 8i databases.
>
> Thanks in advance.
>
> Andy.
Received on Sat Sep 22 2001 - 11:56:45 CDT