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