ORACLE 11.2.0.4版本EXPDP不会导出回收站中数据
发布时间：2020-12-12 15:42:17 所属栏目：百科 来源：网络整理
导读：结论： 在ORACLE 11.2.0.4版本数据库中，清理回收站与否，不影响EXPDP导出文件的大小-即EXPDP不会导出回收站中数据。 1.正常导出 SQL select segment_name,bytes/1024/1024 mb from user_segments; SEGMENT_NAME MB ------------------------------ ---------
|
结论： 在ORACLE 11.2.0.4版本数据库中，清理回收站与否，不影响EXPDP导出文件的大小-即EXPDP不会导出回收站中数据。 1.正常导出 SQL> select segment_name,bytes/1024/1024 mb from user_segments; SEGMENT_NAME MB ------------------------------ ---------- T1 .0625 T2 38 PK_T .0625 SQL> show user USER is "BYS" SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production CORE 11.2.0.4.0 Production TNS for Linux: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production SQL> show recyclebin; SQL> SQL> select sysdate from dual; SYSDATE ------------------- 2016/10/11 10:52:52 [oracle@bys1 ~]$ expdp system/oracle DUMPFILE=test.dmp DIRECTORY=MY_DIR SCHEMAS=bys Export: Release 11.2.0.4.0 - Production on Tue Oct 11 10:53:03 2016 Copyright (c) 1982,2011,Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning,Oracle Label Security,OLAP,Data Mining,Oracle Database Vault and Real Application Testing options FLASHBACK automatically enabled to preserve database integrity. Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** DUMPFILE=test.dmp DIRECTORY=MY_DIR SCHEMAS=bys Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 38.06 MB 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/STATISTICS/TABLE_STATISTICS . . exported "BYS"."T2" 32.02 MB 152180 rows . . exported "BYS"."T1" 5.437 KB 5 rows Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is: /home/oracle/test.dmp Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Oct 11 10:53:17 2016 elapsed 0 00:00:12 ########################## 2.删除表至回收站，继续导出 SQL> drop table t2; Table dropped. SQL> show recyclebin; ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME ---------------- ------------------------------ ------------ ------------------- T2 BIN$Po7wBVOlB17gU9M5qMDlPg==$0 TABLE 2016-10-11:10:53:43 SQL> SQL> select segment_name,bytes/1024/1024 mb from user_segments; SEGMENT_NAME MB ------------------------------ ---------- T1 .0625 BIN$Po7wBVOlB17gU9M5qMDlPg==$0 38 PK_T .0625 [oracle@bys1 ~]$ expdp system/oracle DUMPFILE=test1.dmp DIRECTORY=MY_DIR SCHEMAS=bys Export: Release 11.2.0.4.0 - Production on Tue Oct 11 10:54:10 2016 Copyright (c) 1982,Oracle Database Vault and Real Application Testing options FLASHBACK automatically enabled to preserve database integrity. Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** DUMPFILE=test1.dmp DIRECTORY=MY_DIR SCHEMAS=bys Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 64 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/STATISTICS/TABLE_STATISTICS . . exported "BYS"."T1" 5.437 KB 5 rows Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is: /home/oracle/test1.dmp Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Oct 11 10:54:23 2016 elapsed 0 00:00:11 [oracle@bys1 ~]$ du -sh tes* 208K test1.dmp 4.0K test1.log 33M test.dmp （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |