Import the structure inOracle7.3

[ligang]

I export all the objects without data from User1 and import to another database same username User1

the tablespace what they owners are different name , But all the blank tables are allocated so many spaces as if they are full of data after imported . I just want the structure stored actually .

how to solve this problem ?

[Orca777]

Hi,
There are two ways ...

First : try to extract the DDL from the export-file. with unix you can use grap or string-command. and replace the storage-clause ( Unix sed or with a good editor.)

Second : have the right tool : www.allroundautomations.nl: Pl/Sql-Developer
you can export all objects from a user in a SQL*PLUS command-file and change there manuallay the storage.

Third :
If you know Micrososft-Access you can import the tables from an Oracle-Schema and export it to another without storage!

Bye

Orca