实验一 用exp导出scott用户所有表，导入scott用户所有表

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> show user;
USER 为 "SCOTT"

SQL> select table_name from user_tables;

TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE

SQL> show user;
USER 为 "SCOTT"
SQL> select * from v$version;

 (1)SCOTT用户导出四表数据

C:\Users\Administrator>exp scott/tiger tables=(DEPT,EMP,bonus,SALGRADE) file="xy
.dmp" log="xy.