Oracle backup and recovery of single or multi-table data

Oracle backup, recovery of single or multi-table data steps, applicable to Oracle8, 9, 10.

Oracle backup, recovery of single or multi-table data steps, applicable to Oracle 8, 9, 10.

Oracle backup, recovery of single or multi-table data steps, applicable to Oracle 8, 9, 10.

* Back up single or multi-table data:

Exp user/password @ server file = filefullpathname log = logfullpathname tables = (tablespacename. table1, tablespacename. table2 ,...)

For example, the author wants to export data from table 1 and table 2 in table 1 in table 1 in table 1 in table 1 in table 1 in table 1 in table 1 in table 1 in table 1 in table 1 in table 1 in table 2 in user name sybj, and the command in CMD in win is as follows:

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 the directory G:/tmps.

* Single-table or multi-table data recovery:

If the recovered table already exists, delete it first. Otherwise, the "IMP-0015" error is reported. The Import fails. The single-table or multi-table data recovery command is as follows:

Imp user/password @ server file = filefullpathname log = logfullpathname full = y

In the preceding example, recover data from table1 and table2. The CMD command in win is as follows:

F:/oralce/ora92/bin> imp sybj/sybj @ lyzz file = G:/tmps/test009.tmp log = G:/tmps/test009imp. log full = y