Use of the Oracle Export tool Exp: 1. Fully export the database test (remote database must be a connection identifier), username system, password Manager, export to D:\DAOCHU.DMP: Exp system/[email Protected] File=d:\daochu.dmp full=y 2, export the database of system users and SYS user tables: exp system/[email protected] file=d:\daochu.dmp owner = (System,sys) 3, export the tables in the database table1, table2: Exp system/[email protected] file=d:\daochu.dmp tables= (table1,table2) 4, the number According to the fields in the table table1 in the library filed1 the data that begins with "00": Exp system/[email protected] file=d:\daochu.dmp tables= (table1) query=\ "where fi Led1 like ' 0% ' \ ' 5, write to log file: Exp system/[email protected] file=d:\daochu.dmp full=y log=d:\daochu.log You can enter Exp-hel at the command line P View the Help options. Use of the Oracle Lead tool IMP: 1. Import the data from the D:\DAOCHU.DMP into the test database:
Imp System/[email protected] File=d:\daochu.dmp
The above may be a problem, because some tables already exist, and then it will be an error, the table will not be imported, add Ignore=y on the back.
2. Import the table table1 in d:\daochu.dmp:
Imp system/[email protected] file=d:\daochu.dmp tables= (table1) 3, import between different users: Imp system/[email protected] Fromuser=s NPW1 touser=snpw2 File=d:\daochu.dmp
Use of the Oracle Import and Export tool