expdp 使用超级用户导出数据库

jiawang

[oracle@strong33 ~]$ expdp userid=\'/ as sysdba\' DIRECTORY=dpdata1 DUMPFILE=backup1.dmp

Export: Release 11.2.0.4.0 - Production onWed Jun 21 13:27:56 2017

Copyright (c) 1982, 2011, Oracle and/or itsaffiliates.  All rights reserved.

Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.4.0 - Production

With the Partitioning, OLAP, Data Miningand Real Application Testing options

Starting"SYS"."SYS_EXPORT_SCHEMA_01":  userid="/******** AS SYSDBA"DIRECTORY=dpdata1 DUMPFILE=backup1.dmp

Estimate in progress using BLOCKS method...

Total estimation using BLOCKS method: 0 KB

Processing object typeSCHEMA_EXPORT/ROLE_GRANT

Master table"SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYS.SYS_EXPORT_SCHEMA_01is:

/u01/backup/backup1.dmp

Job"SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at WedJun 21 13:28:14 2017 elapsed 0 00:00:17

zhouwei1990

可以使用创建一个parfile，在parfile中指定相应的用户以及其他参数
vi expdp.par
userid='/ as sysdba'
DIRECTORY=dpdata1
DUMPFILE=backup1.dmp

导出时指定相应的parfile就可以了，而且在parfile里面不需要对单引号进行转义。既单引号前不用加\。

zhouwei1990

指定expdp parfile=expdp.par即可