sys下expdp遇bug5402988

Bug 5402988: DATAPUMP EXPORT FAILS ORA-31655[@more@]

SQL> select count(*) from database_block_corruption_bak2;

COUNT(*)
----------
396540
create directory dmpdir as '/home/oracle/kyte';

expdp "sys/xxx@dwdbetl as sysdba" DUMPFILE=database_block_corruption_bak2.dmp DIRECTORY=dmpdir TABLES=(sys.database_block_corruption_bak2)

日志如下:

Export: Release 11.1.0.7.0 - 64bit Production on Thursday, 19 November, 2009 15:17:23

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Real Application Testing options
Starting "SYS"."SYS_EXPORT_TABLE_01": "sys/********@dwdbetl AS SYSDBA"DUMPFILE=database_block_corruption_bak2.dmp DIRECTORY=dmpdir TABLES=(sys.database_block_corruption_bak2)
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
ORA-39165: Schema SYS was not found.
ORA-39166: Object DATABASE_BLOCK_CORRUPTION_BAK2 was not found.
ORA-31655: no data or metadata objects selected for job
Job "SYS"."SYS_EXPORT_TABLE_01" completed with 3 error(s) at 15:21:52

bug指出要用普通的exp导出.

注意：在命令行指定sys ... as sysdba的方法有两种
"'sys/oracle AS SYSDBA'"
" / as sysdba "

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/94384/viewspace-1028864/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/94384/viewspace-1028864/