--------------------------------------imp/ Exp---------------------------------------------------------------------------
Import table data and table Structure IMP username/password @ database name Fromuser (the specified user of the file, that is, import data from that user) = user name Touser (the target user, that is, the user who is currently logged in) = user name file= DMP file location to import ignore=y (ignore error creation)//example: imp aml/[email protected]:1521/orcl fromuser=urspmonitor Touser=aml FILE=/DATA/AML.DMP full=y ignore=y;//Export table data and table Structure exp username/password @ database name owner= User name file=dmp file storage location (that is, the export file is a. dmp file)
example, the production data is imported into the local test library:
CREATE TABLE aml_rule_autoslay_0705 as SELECT * from Aml.aml_rule_autoslay;exp urspmonitor/[email protected]:1521/ DWURSP file=aml_rule_autoslay.dump tables=aml_rule_autoslay_0705drop Table Aml_rule_autoslay_0705;imp aml/[email Protected]:1521/pisa fromuser=urdpmonitor touser=aml file=/jgtest/aml_rule_autoslay.dump Imp aml/[email Protected]:1521/pisa
1, shipping to the problem?
When importing data, it is impossible to find the target user to make assignment error, need to use Fromuser=urspmonitor Touser=aml, that is, ignore user authorization error;
2, or use the tool in the Import data panel uncheck, number of lines, authorization. If there is a unique constraint error, cancel the "constraint" tick;
Oracle table Structure table data import and Export