一次奇怪的导出问题,导出的时候忘了加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 目录
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




