expdp默认目录

一次奇怪的导出问题，导出的时候忘了加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 目录