一次奇怪的导出问题,导出的时候忘了加DIRECTORY参数了,但是发现数据竟然可以正常导出,检查发现数据导出到了DATA_PUMP_DIR目录对应的位置
expdp system/oracle DUMPFILE=zc.dmp LOGFILE=zc.log SCHEMAS=zc
[ora112@test ~]$ expdp system/oracle DUMPFILE=zc.dmp LOGFILE=zc.log SCHEMAS=zc
Export: Release 11.2.0.1.0 - Production on Sun May 26 10:12:36 2024
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** DUMPFILE=zc.dmp LOGFILE=zc.log SCHEMAS=zc
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 18 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
. . exported "ZC"."T1" 6.951 MB 71896 rows
. . exported "ZC"."TT" 6.951 MB 71895 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/u03/app/oracle/admin/test/dpdump/zc.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 10:12:55
发现数据库能正常导出,导出到了/u03/app/oracle/admin/test/dpdump目录。
SQL> set pagesize 0
SQL> select * from dba_directories;
SYS ORACLE_OCM_CONFIG_DIR
/u03/app/oracle/product/11.2.0/dbhome_1/ccr/state
SYS DATA_PUMP_DIR
/u03/app/oracle/admin/test/dpdump/
SYS XMLDIR
/ade/b/2125410156/oracle/rdbms/xml
检查发现/u03/app/oracle/admin/test/dpdump对应的是DATA_PUMP_DIR 目录