Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: storage in import

Re: storage in import

From: Niall Litchfield <Niall.Litchfield_at_btinternet.com>
Date: Sat, 22 Sep 2001 17:56:45 +0100
Message-ID: <9oifg1$ntq$1@neptunium.btinternet.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US