CODEWITHSUNDEEP
databaseoracle-databaseoracle11g
Sopan Shinde
Sopan Shinde

Reputation: 23

Import and export database in 11g

I want to create new database in oracle. But In that database i want to export and import database table from other database.

For example: I have database name like: ABC

In this database (ABC) I have some tables like table1, table2.

I want to copy these table as it in to other database name XYZ.

Can I do that? If yes then how?

I am Using Oracle 11g

Upvotes: 0

Views: 328

Answers (1)

Rob van Laarhoven
Rob van Laarhoven

Reputation: 8905

Use datapump to move data from one database to another. See : http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php

Upvotes: 2

Related Questions