Global oracle database backup DMP file, is to export the backup files in a table, and change in export database instance name, change the name of the table, should be how to deal with,

CodePudding user response:

You this question, itself is a little unclear, is your DMP exp or expdp

If it is exp, you can't import the new library in the name of the table
If is expdp, if you can pain remap_table in table name

Import tables specified keyword

CodePudding user response:

refer to the original poster weixin_45512568 response:

global oracle database backup DMP file, is to export the backup files in a table, and change in export database instance name, change the name of the table, should be how to deal with,

1, the DMP file to import, need not the instance name is the same as the original;
2, the first clear DMP file is exp or expdp generated, expdp generated, import can directly modify the table name (remap options, specific to check), otherwise, the import libraries with the alter table... Rename... to ... ; Command to change,