Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

exp/imp no data just structure uses a ton of disk space

141436Nov 8 2007 — edited Nov 10 2007

I am attempting to migrate a schema from one db instance to another and have run into a problem with disk space. All I want to migrate is the structure. So I am exporting with out the data. Yet the tablespace datafiles grow to a size as if they actually held data. I don't have the disk space for this and would like to know if there is a way around this problem. Also, can anyone provide some insight into why the space would be taken up even though no data is being imported.

I am not a DBA but our DBA suggested I include a compress=n parameter. However, this doesn't appear to solve the issue.

Thanks,
Jason

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2007

Added on Nov 8 2007

#general-database-discussions

9 comments

2,888 views