Oracle：EXPDP基础（1）
EXPDP是Oracle提供的一个数据导出工具。
下面的呈现仅为最基本的导出方式：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
[oracle@ora11g ~]$ expdp userid=\"/ as sysdba\" schema=scott LRM-00101: unknown parameter name 'schema' [oracle@ora11g ~]$ expdp userid=\"/ as sysdba\" schemas=scott flashback_time=\"to_timestamp(to_char(sysdate,'yyyy-mon-dd hh24:mi:ss'),'yyyy-mon-dd hh24:mi:ss')\" -bash: syntax error near unexpected token `(' [oracle@ora11g ~]$ expdp userid=\"/ as sysdba\" schemas=scott Export: Release 11.2.0.3.0 - Production on Thu Oct 9 22:22:21 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Starting "SYS"."SYS_EXPORT_SCHEMA_01": userid="/******** AS SYSDBA" schemas=scott Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 192 KB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS . . exported "SCOTT"."DEPT" 5.937 KB 4 rows . . exported "SCOTT"."EMP" 8.570 KB 14 rows . . exported "SCOTT"."SALGRADE" 5.867 KB 5 rows . . exported "SCOTT"."BONUS" 0 KB 0 rows Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 22:23:03 [oracle@ora11g ~]$ [oracle@ora11g ~]$ du -sh /u01/app/oracle/admin/orcl/dpdump/expdat.dmp 244K /u01/app/oracle/admin/orcl/dpdump/expdat.dmp [oracle@ora11g ~]$ |
————————————————————————————————————
Ending。
