C:\Users\student01>exp ceshi/seentao tablespaces=(system,ceshi) file=d:\ceshi4.dmpC:\Users\student01>exp system/seentao owner=ceshi file=d:\ceshi5.dmpC:\Users\student01>exp ceshi/seentao tablespaces=(system,ceshi) transport_tables pace=y file=d:\ceshi6.dmpExport: Release 10.2.0.1.0 - Production on 星期二8月5 14:33:53 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsEXP-00044: 必须以'SYSDBA' 身份连接, 才能进行时间点恢复或可传输的表空间导入EXP-00000: 导出终止失败C:\Users\student01>imp ceshi/seentao file=d:\ceshi.dmp fromuser=ceshiC:\Users\student01>imp ceshi/seentao file=d:\ceshi.dmp full=yC:\Users\student01>imp ceshi/seentao file=d:\ceshi00.dmp fromuser=ceshi数据泵导入导出C:\Users\student01>sqlplus/nologSQL*Plus: Release 10.2.0.1.0 - Production on 星期二8月5 15:27:06 2014 Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn/as sysdba 连接数据库已连接。

SQL> select * from dba_directories where directory_name='DATA_PUMP_DIR'; OWNER DIRECTORY_NAME------------------------------ ------------------------------DIRECTORY_PATH--------------------------------------------------------------------------------SYS DATA_PUMP_DIRC:\oracle\product\10.2.0\db_1\admin\orcl\dpdump\SQL> exit从Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options 断开C:\Users\student01>expdp ceshi/seentao dumpfile=ceshi.dmp 数据泵导出数据库C:\Users\student01>md d:\pumpC:\Users\student01>sqlplus/nologSQL*Plus: Release 10.2.0.1.0 - Production on 星期二8月5 15:39:07 2014 Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn/as sysdba已连接。

SQL> grant create any directory to ceshi;授权成功。

SQL> conn ceshi/seentao已连接。

SQL> create directory ceshidb as 'd:\pump';目录已创建。

SQL> exit从Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options 断开C:\Users\student01>expdp ceshi/seentao directory=ceshidb dumpfile=ceshi.dmpExport: Release 10.2.0.1.0 - Production on 星期二, 05 8月, 2014 15:43:13Copyright (c) 2003, 2005, Oracle. All rights reserved.连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options启动"CESHI"."SYS_EXPORT_SCHEMA_01": ceshi/******** directory=ceshidb dumpfile= ceshi.dmp正在使用BLOCKS 方法进行估计...处理对象类型SCHEMA_EXPORT/TABLE/TABLE_DATA使用BLOCKS 方法的总估计: 192 KB处理对象类型SCHEMA_EXPORT/USER处理对象类型SCHEMA_EXPORT/SYSTEM_GRANT处理对象类型SCHEMA_EXPORT/ROLE_GRANT处理对象类型SCHEMA_EXPORT/DEFAULT_ROLE处理对象类型SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA处理对象类型SCHEMA_EXPORT/TABLE/TABLE处理对象类型SCHEMA_EXPORT/TABLE/INDEX/INDEX处理对象类型SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT处理对象类型SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS处理对象类型SCHEMA_EXPORT/TABLE/COMMENT处理对象类型SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT处理对象类型SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS. . 导出了"CESHI"."CARD" 5.593 KB 5 行. . 导出了"CESHI"."EMPLOYEE" 6.578 KB 4 行. . 导出了"CESHI"."USERS" 5.281 KB 4 行. . 导出了"CESHI"."BASICINFO" 0 KB 0 行已成功加载/卸载了主表"CESHI"."SYS_EXPORT_SCHEMA_01"****************************************************************************** CESHI.SYS_EXPORT_SCHEMA_01 的转储文件集为:D:\PUMP\CESHI.DMP作业"CESHI"."SYS_EXPORT_SCHEMA_01" 已于15:43:23 成功完成C:\Users\student01>expdp ceshi/seentao directory=ceshidb dumpfile=ceshi1.dmp nologfile=y nologfile=y是不导出日志文件C:\Users\student01>expdp ceshi/seentao directory=ceshidb dumpfile=ceshi3.dmp logfile=ce1.log parallel=4C:\Users\student01>expdp ceshi/seentao directory=ceshidb dumpfile=ceshio%u.dmp filesize=200k logfile=ce3.log parallel=4Export: Release 10.2.0.1.0 - Production on 星期二, 05 8月, 2014 16:11:18Copyright (c) 2003, 2005, Oracle. All rights reserved.连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options启动"CESHI"."SYS_EXPORT_SCHEMA_01": ceshi/******** directory=ceshidb dumpfile= ceshio%u.dmp filesize=200k logfile=ce3.log parallel=4正在使用BLOCKS 方法进行估计...处理对象类型SCHEMA_EXPORT/TABLE/TABLE_DATA使用BLOCKS 方法的总估计: 192 KB. . 导出了"CESHI"."CARD" 5.593 KB 5 行处理对象类型SCHEMA_EXPORT/USER. . 导出了"CESHI"."EMPLOYEE" 6.578 KB 4 行. . 导出了"CESHI"."USERS" 5.281 KB 4 行. . 导出了"CESHI"."BASICINFO" 0 KB 0 行处理对象类型SCHEMA_EXPORT/SYSTEM_GRANT处理对象类型SCHEMA_EXPORT/ROLE_GRANT处理对象类型SCHEMA_EXPORT/DEFAULT_ROLE处理对象类型SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA处理对象类型SCHEMA_EXPORT/TABLE/TABLE处理对象类型SCHEMA_EXPORT/TABLE/INDEX/INDEX处理对象类型SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT处理对象类型SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS处理对象类型SCHEMA_EXPORT/TABLE/COMMENT处理对象类型SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT处理对象类型SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS已成功加载/卸载了主表"CESHI"."SYS_EXPORT_SCHEMA_01"****************************************************************************** CESHI.SYS_EXPORT_SCHEMA_01 的转储文件集为:D:\PUMP\CESHIO01.DMPD:\PUMP\CESHIO02.DMP作业"CESHI"."SYS_EXPORT_SCHEMA_01" 已于16:11:27 成功完成C:\Users\student01>expdp ceshi/seentao directory=ceshidb dumpfile=ceshio9.dmp logfile=ce4.log tables=card,users parallel=4Export: Release 10.2.0.1.0 - Production on 星期二, 05 8月, 2014 16:14:50Copyright (c) 2003, 2005, Oracle. All rights reserved.连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options启动"CESHI"."SYS_EXPORT_TABLE_01": ceshi/******** directory=ceshidb dumpfile=c eshio9.dmp logfile=ce4.log tables=card,users parallel=4正在使用BLOCKS 方法进行估计...处理对象类型TABLE_EXPORT/TABLE/TABLE_DATA使用BLOCKS 方法的总估计: 128 KB. . 导出了"CESHI"."CARD" 5.593 KB 5 行. . 导出了"CESHI"."USERS" 5.281 KB 4 行处理对象类型TABLE_EXPORT/TABLE/TABLE处理对象类型TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT处理对象类型TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS已成功加载/卸载了主表"CESHI"."SYS_EXPORT_TABLE_01"****************************************************************************** CESHI.SYS_EXPORT_TABLE_01 的转储文件集为:D:\PUMP\CESHIO9.DMP作业"CESHI"."SYS_EXPORT_TABLE_01" 已于16:14:56 成功完成C:\Users\student01>expdp ceshi/seentao directory=ceshidb dumpfile=ceshio95.dmp logfile=ce31.log tablespaces=ceshidb,system parallel=4C:\Users\student01>expdp ceshi/seentao directory=ceshidb dumpfile=ceshio55.dmp filesize=100m full=y content=data_only logfile=ce55.logC:\Users\student01>impdp ceshi/seentao directory=ceshidb dumpfile=ceshi3.dmp logfile=ce1.log parallel=4Import: Release 10.2.0.1.0 - Production on 星期二, 05 8月, 2014 16:32:47Copyright (c) 2003, 2005, Oracle. All rights reserved.连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options已成功加载/卸载了主表"CESHI"."SYS_IMPORT_FULL_01"启动"CESHI"."SYS_IMPORT_FULL_01": ceshi/******** directory=ceshidb dumpfile=ceshi3.dmp logfile=ce1.log parallel=4处理对象类型SCHEMA_EXPORT/USERORA-31684: 对象类型USER:"CESHI" 已存在处理对象类型SCHEMA_EXPORT/SYSTEM_GRANT处理对象类型SCHEMA_EXPORT/ROLE_GRANT处理对象类型SCHEMA_EXPORT/DEFAULT_ROLE处理对象类型SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA处理对象类型SCHEMA_EXPORT/TABLE/TABLEORA-39151: 表"CESHI"."BASICINFO" 已存在。