在Oracle 11.2.0.4 版本的数据库中,使用数据泵导出数据时,有可能会遇到这样的提示:
示例1
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_TABLE_01": "/******** AS SYSDBA" directory=DATA_PUMP_DIR dumpfile=usersinfo.dmp logfile=190424.log compression=all tables=ue.UE_CU,cs.cs_a,cs.cs_s,cs.cs_c,cs.cs_ac,cs.cs_sc
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1.729 GB
>>> DBMS_AW_EXP: BIN$V1thyQEUFJzgUwsGBQr/eA==$0 not AW$
>>> DBMS_AW_EXP: BIN$V1thyQEWFJzgUwsGBQr/eA==$0 not AW$
>>> DBMS_AW_EXP: BIN$V1thyQEYFJzgUwsGBQr/eA==$0 not AW$
>>> DBMS_AW_EXP: BIN$V1thyQEaFJzgUwsGBQr/eA==$0 not AW$
>>> DBMS_AW_EXP: BIN$V1thyQEcFJzgUwsGBQr/eA==$0 not AW$
>>> DBMS_AW_EXP: BIN$V1thyQEeFJzgUwsGBQr/eA==$0 not AW$
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
>>> DBMS_AW_EXP: BIN$V1thyQEUFJzgUwsGBQr/eA==$0 not AW$
>>> DBMS_AW_EXP: BIN$V1thyQEWFJzgUwsGBQr/eA==$0 not AW$
>>> DBMS_AW_EXP: BIN$V1thyQEYFJzgUwsGBQr/eA==$0 not AW$
>>> DBMS_AW_EXP: BIN$V1thyQEaFJzgUwsGBQr/eA==$0 not AW$
>>> DBMS_AW_EXP: BIN$V1thyQEcFJzgUwsGBQr/eA==$0 not AW$
>>> DBMS_AW_EXP: BIN$V1thyQEeFJzgUwsGBQr/eA==$0 not AW$
. . exported "CS"."CS_C" 100.6 MB 3924383 rows
. . exported "CS"."CS_S" 78.56 MB 1603800 rows
. . exported "UE"."UE_CU" 55.89 MB 1240270 rows
. . exported "CS"."CS_A" 23.67 MB 2659884 rows
. . exported "CS"."CS_SC" 50.16 MB 1603794 rows
. . exported "CS"."CS_AC" 36.42 MB 1240124 rows
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/oracle/app/oracle/admin/aiboss/dpdump/usersinfo.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at Wed Apr 24 15:14:23 2019 elapsed 0 00:00:57
解决方法:
purge dba_recyclebin;
<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=8664011652677229180&zx=bbcc58ab-868b-48b4-8823-c4a02c868295' rel='stylesheet'/>