Database Utilities (MOSC)

MOSC Banner

Data Pump impdp problem understanding how to use remap_table and remap_schema properly.

Hello Guru's

I feel bad asking this. I literally feel so dumb I cannot solve this.

Using EXPDP and IMPDP want to export 1 table from a specific database server. Then, import using impdp that same table into a different server, different database, different schema and different table. So I need to remap the schema and the table name.

Summary: Export the "table_bob" from the "bob_schema" and import the table into the "bill_schema" table: "table bill" (essentially renaming the table and placing it in a different schema)

The EXPORT command exporting "table_bob" from the "bobdb" database on server1:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center