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: