Re: storage in import

From: Asaf Shoval <shovala_at_netvision.net.il>
Date: Mon, 24 Sep 2001 22:54:24 +0200
Message-ID: <9oo6cq$eda$1@news.netvision.net.il>

Andy,
You will have to create a script for this purpose. issue a command of import this way:
"imp userid=x/y file=myexp.dmp indexfile=xxx.sql" then edit the xxx.sql and change the initial value of the tables and the indexes to somthing like 10k.
now, on the target machine run the xxx.sql and then run the import with "ignore=y" switch to import the rest of the objects (like grants, procedures etc)

Hope that helped

Asaf

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 Mon Sep 24 2001 - 15:54:24 CDT