Oracle Import and Export instances

The following describes the Import and Export instances.
Data export:
1. Export the database TEST completely, and use the User Name system Password manager to D: daochu. exp system/manager @ TEST file = d: daochu in dmp. dmp full = y 2 export the tables of system users and sys users in the database exp system/manager @ TEST file = d: daochu. dmp owner = (system, sys) 3 export the database tables inner_policy and policy_staff_relat to exp aichannel/aichannel @ TESTDB2 file = d: datanewsmgnt. dmp tables = (inner_policy, policy_staff_relat) 4. Export the filed1 field in table 1 in the database with the data Header "00" exp system/manager @ TEST file = d: dao Chu. dmp tables = (table1) query = "where filed1 like '000000'" is commonly used for export. For compression, you can use winzip to compress the dmp file. You can also add compress = y to the command above. Www.2cto.com
Data Import
1. import data from D: daochu. dmp to the TEST database. Imp system/manager @ TEST file = d: daochu. dmp imp aichannel/aichannel @ HUST full = y file = d: datanewsmgnt. dmp ignore = y may be faulty because some tables already exist and an error is reported. Add ignore = y to the end. 2. Importing table 1 in d: daochu. dmp to imp system/manager @ TEST file = d: daochu. dmp tables = (table1) is sufficient. In many cases, you must first completely delete the table and then import it. Note: If the operator has sufficient permissions, a prompt is displayed.
Author 409304740