Heterogeneous Environment Oracle Database migration--export and import

Exp/imp can be used in the following cases

Transfer data between two databases

1. Between versions of the same Oracle database

2. Between versions of different Oracle databases

3. Oracle database between the same or a different operating system

Backup and recovery for the database

Transfer from one database user to another user

Transfer from one table space to another table space

Create a table space

Create Tablespace Bank_tbs (database tablespace) datafile '/oracle/test (data path) bank_data02.dbf (data file name) ' Size 5M autoextend on maxsize 10G ;

Specify tablespace when creating user

Create user Bankuser identified by bankpwd default Tablespace Bank_tbs;

Exporting data using Export

Exp Bankuser/[email protected] file= '/backup/bankuser.dmp ' log= '/backup/bankuserexp.log '

　　

Heterogeneous Environment Oracle Database migration--export and import