Procedure for Oracleexpimp to back up and restore table space data

Oracle backup is divided into logical backup and physical backup. Logical backup is expimp; physical backup includes cold backup, hot backup, and RMAN backup. Expimp has three modes: Table mode,

Oracle backup is divided into logical backup and physical backup. Logical backup is exp/imp; physical backup includes cold backup, hot backup, and RMAN backup. Exp/imp has three modes: Table mode,

Oracle backup is divided into logical backup and physical backup. Logical backup is exp/imp; physical backup includes cold backup, hot backup, and RMAN backup. Exp/imp has three modes: Table mode, user mode, and full database mode.

Oracle Import and Export expdp IMPDP details

Solution to Oracle 10g expdp export error ORA-4031

Oracle 10gr2 rac expdp error UDE-00008 ORA-31626

Use of expdp/impdp to back up databases in Oracle

1. Use exp/imp to back up the tablespace

Exp user/password @ server file = filefullpathname log = logfullpathname

For example, to export a table space with the username "bsm", password "forebsm", and sid "bsm", run the following command on Linux:

Exp bsm/forebsm @ bsm owner = bsm file =/home/bsm. ump log =/home/bsmexp. log

(Bsm/forebsm @ bsm

Username/password @ Instance name, the same below)

The backup file bsm. mmp will be generated in the directory/home.

2. Use exp/imp to restore the tablespace

Imp user/password @ server ignore = y rows = y full = y commit = y buffer = 4096000 file = filefullpathname

In the preceding example, the Linux platform command is as follows:

Imp bsm/forebsm @ bsm fromuser = bsm touser = bsm file =/home/bsm. ump log =/home/bsmimp. log

When porting tablespaces in two databases, you must note which database to create a tablespace must be greater than or equal to the tablespace in the original database. Otherwise, an error is returned.

Note: When exp/imp is used to recover data, you must first create a database in the three modes, then create a tablespace, create a user, and then use the statements described above to restore the database.