Oracle Backup, Recovery single-table or multi-table data steps for Oracle 8, 9, 10.
* Backup single or multi-table data :
[Java]View PlainCopy
- Exp User/password@server file=filefullpathname log=logfullpathname tables= (Tablespacename.table1, Tablespacename.table2,...)
For example, the author wants to export the user name SYBJ, the password is sybj,sid to Lyzz, the table space sybj the following table table1, table2 data, win the following CMD command:
[Java]View PlainCopy
- F:/oralce/ora92/bin>exp sybj/sybj@lyzz file=g:/tmps/test009.tmp log=g:/tmps/test009.log tables= (sybj.table1 , Sybj.table2)
The backup file test009.tmp will be generated under directory g:/tmps/.
* single-table or multi-table data recovery :
If the restored table already exists, it should be deleted first, or the "IMP-0015" error is reported, and the import fails. Single-table or multi-table data recovery commands are as follows:
[Java]View PlainCopy
- Imp user/password@server file=filefullpathname log=logfullpathname full=y
Still in the above example, the Table1, table2 data recovery, win the following CMD command:
[Java]View PlainCopy
- F:/oralce/ora92/bin>imp sybj/sybj@lyzz file=g:/tmps/test009.tmp log=g:/tmps/test009imp.log full=y
Oracle Backup, restore single-table or multi-table data steps