ORA-1659 ERROR

[mkey]

HI All,
I am tring to import a dump file but without the data. The strange thing is the stucture is taking up alot of space even though I am not importing the data. can someone tell me what's going on here? I have allocated about 20GB in the tablespace. But actually there is only 5 tables in this import file.

Thank you!

 

[karluk]

Most likely you are importing tables that have most or all of their space allocated in just a single extent. Importing the structures will create the initial extent and, since that's where all the space is allocated, you end up with as large a table as if you had imported the data as well.

The only way I know of to avoid this problem is to manually create the tables with smaller extent sizes. If you don't have a script handy to create the tables you can generate it from the export file by doing an import with the "show=y" and "log={file name}" parameters. That will put the table create statements in your log file and you can edit them from there.