Oracle table Structure table data import and Export

--------------------------------------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