expdp / as sysdba

原文地址：http://jotey.blog.163.com/blog/static/14926370201262315327525/

Export as SYS or not?

but this mean that I can't use expdp to exporting from 10.1 to 10.2 using SYS?

It seems so, it generates ORA-39135 error :


$   expdp \"/ as sysdba\" directory=dpump_dir dumpfile=test10.dmp full=y

Export: Release 10.1.0.3.0 - Production on Monday, 30 January, 2006 16:28

Copyright (c) 2003, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39135: SYS schema cannot read data using specific SCNs

$ oerr ora 39135
39135, 00000, "SYS schema cannot read data using specific SCNs"
// *Cause:  The user was operating under the SYS schema and either explicitly
//          specified an SCN via the FLASHBACK_SCN or FLASHBACK_TIME or
//          TABLE_CONSISTENCY parameters or the job required that a
//          specific SCN be used because of streams or
//          logical replication activity.
// *Action: Do not perform Data Pump jobs using the SYS schema or 'AS SYSDBA'.


$   expdp 'userid="/ as sysdba"' full=y

Export: Release 10.1.0.4.0 - 64bit Production on Monday, 30 January, 2006 17:22

Copyright (c) 2003, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security and Data Mining options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."SYS_EXPORT_FULL_02":  userid="/******** AS SYSDBA" full=y
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 20.56 MB
Processing object type DATABASE_EXPORT/TABLESPACE