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!

Importing a dump of two Tablespaces

MikailJun 10 2011 — edited Jun 10 2011

Hi,
I've got two tablespaces with a lot of tables in both. I have to import all those tables to another Oracle database. I would like to know what I have to do given the following information:
The source database has a user named HQ and two tablespaces named HQBase and HQPartitions. When I browse through the tables of the user HQ I can see tables from both tablespaces. (Does this mean the user HQ owns these tablespaces?). Do I have to have a user and tablespaces in the destination database named exactly the same as the ones in the source? Could someone please tell me what exactly I have to do in order to have everything the same in the destination database. What do I have to do prior to, during and after the import process. The IDEs I use are TOAD and PL/SQL developer.

Edited by: Mikail on 09.06.2011 22:03

Edited by: Mikail on 09.06.2011 22:03

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2011

Added on Jun 10 2011

#general-database-discussions, #import

7 comments

214 views