The existing environment:
1. The warehouse 1 (wmwhse1),
2. Warehouse 2 (wmwhse2)
Now demand is this:
1. The warehouse 1 table structure (including tables, triggers, indexes, sequence, etc., but exclude) on the surface of the table data into the warehouse 2.
2. If the warehouse where the structure of 1 and 2 warehouse the same cover, if the warehouse 2 and 1 does not exist the retained structure of 2 in the warehouse. If the warehouse 1 exists but 2 there is no import in.
Question:
Warehouse 1 and 2 is not the same as the username, warehouse 1 is it spelled "wmwhse1. Sku," is the name of the table or trigger, etc., have wmwhse1 prefix. 2 will be imported into the warehouse is there a problem?
I hope you and give the import and export of statements, specific meaning I study in baidu. Thanks

CodePudding user response:

Expdp/impdp comparison scenario for you now,

CodePudding user response:

There will be no problem you add a remap_schema table structure of this manual alignment

CodePudding user response:

In the warehouse 1, EXP is used to derive the wmwhse1 data, (whether choose according to the users to export, export data)

In 2, the warehouse used IMP import fromuser=wmwhse1, touser=wmwhse2, applied after heading with wmwhse2,

* * * * * * * * * * * * * * * * * * * * * * * *
If you want to use wmwhse1 heading, it needs to build user wmwhse1 in warehouse 2,

In the warehouse 1, EXP is used to derive the wmwhse1 data, (whether choose according to the users to export, export data)

In 2, the warehouse used IMP import fromuser=wmwhse1, touser=wmwhse1

CodePudding user response:

Practice more EXP, IMP, take a look at the parameters

CodePudding user response:

RMAN backup and restore

http://www.verejava.com/? Id=17173804029058