Database Software

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!

editing a datapump .dmp file question

User_SDMR4Mar 29 2013 — edited Mar 29 2013

I am running 10.2.0.4 rdbms on hpux platfrom and I am taking a data pump export with content=metadata_only. I want to then import this metadata into a new database install which will be running an 11.2.0.3 database.
I want to be able to change the default tablespaces for where the objects live in the export file and also change the initial extent size so that the empty objects will only take up a small amouth of space in the new database and also have all of the objects created in one tablespace in the new database.
Is is possible to edit the .dmp file and make these kind of global changes so that all objects can be created in the users tablespace and set the initial extent size as 10mb?
Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2013

Added on Mar 29 2013

#database-key-features, #export-import-sql-loader-external-tables

11 comments

2,720 views