CODEWITHSUNDEEP
oracle-databaseoracle11gtablespaceimpdp
ramziy
ramziy

Reputation: 3

How to export oracle 11g user to 10g and on a different default tablespace

I have an 11g database and I want to export a dump to import it later on a 10g database. I can use expdp with option VERSION=10.2 but my problem is that I have to import this dump on a different tablespace.

thank you

Upvotes: 0

Views: 189

Answers (1)

Alex Poole
Alex Poole

Reputation: 191275

You can use the REMAP_TABLESPACE parameter during the import:

Remaps all objects selected for import with persistent data in the source tablespace to be created in the target tablespace.

You can specify multiple mappings if necessary.

Upvotes: 2

Related Questions