Oracle的导入/导出技术,推荐使用expdp/impdp来代替之前的exp/imp。
expdp数据泵导出:
1. 创建导出实验环境
[oracle@station10 ~]$ mkdir -p /u01/oracle/backup/
[oracle@station10 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Mar 20 16:23:14 2012
Copyright (c) 1982, 2007, Oracle.
All Rights Reserved.
SQL> conn /as sysdba
Connected.
SQL> create directory backupdir as '/u01/oracle/backup';
Directory created.
SQL> create user test identified by test;
User created.
SQL> create tablespace test datafile '/u01/oracle/oradata/ORCL/test01.dbf' size 100M;
Tablespace created.
SQL> alter user test default tablespace test;
User altered.
SQL> grant connect,resource to test;
Grant succeeded.
SQL> grant select on dba_objects to test;
Grant succeeded.
SQL> grant select on dba_tables to test;
Grant succeeded.
SQL> conn test/test
Connected.
SQL> create table v_objects as select * from dba_objects;
Table created.
SQL> create table v_tables as select * from dba_tables;
Table
expdp数据泵导出:
1. 创建导出实验环境
[oracle@station10 ~]$ mkdir -p /u01/oracle/backup/
[oracle@station10 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Mar 20 16:23:14 2012
Copyright (c) 1982, 2007, Oracle.
SQL> conn /as sysdba
Connected.
SQL> create directory backupdir as '/u01/oracle/backup';
Directory created.
SQL> create user test identified by test;
User created.
SQL> create tablespace test datafile '/u01/oracle/oradata/ORCL/test01.dbf' size 100M;
Tablespace created.
SQL> alter user test default tablespace test;
User altered.
SQL> grant connect,resource to test;
Grant succeeded.
SQL> grant select on dba_objects to test;
Grant succeeded.
SQL> grant select on dba_tables to test;
Grant succeeded.
SQL> conn test/test
Connected.
SQL> create table v_objects as select * from dba_objects;
Table created.
SQL> create table v_tables as select * from dba_tables;
Table