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!

How to import tables, indexes, tablespace, etc from a DMP.

user10182692Mar 25 2011 — edited Mar 25 2011

Hello,

I like to know how to import tables, indexes, tablespace, etc from an DMP export of a Oracle 10.2.0.1 to be apply on a Oracle 11.2.0. When I import the DMP file all the data is going to one single Tablespace, for example, Users tablespace.

On the original database we have various tablespace's each separated with different content (tables, indexes) and I like to know if it posible to import the same schema,tables, indexes, tablespace all made with one single DMP Export. I can't use DBUA because the software of the database on the 10.2 is missing, I have only a DMP file (24GB) of DMP!.

Thanks for the reply,

Sorry for my english :).

Regards.

This post has been answered by unknown-698157 on Mar 25 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2011

Added on Mar 25 2011

#database, #general-database-discussions, #import

5 comments

195 views