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!

Data Pump - Tablespace MetaData

Jim ThompsonApr 17 2012 — edited Apr 17 2012

Does anyone know how to get the metadata to create only the tablespaces from a full export dump - I am trying to create the necessary SQL to pre-create my tablespaces before a full import

Q1. Do I have to do this from the expdp instead of the impdp side
I am guessing I need to use CONTENT=METADATA_ONLY on the export side.

Q2. How do I restrictr the MetaData to only tablespaces. Is it simply a question of using
INCLUDE=TABLESPACE

Jim

This post has been answered by Lubiez Jean-Valentin on Apr 17 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 15 2012

Added on Apr 17 2012

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

2 comments

2,321 views