expdp導(dǎo)出數(shù)據(jù)時(shí)候出現(xiàn)報(bào)錯(cuò)怎么辦-創(chuàng)新互聯(lián)

這篇文章將為大家詳細(xì)講解有關(guān)expdp導(dǎo)出數(shù)據(jù)時(shí)候出現(xiàn)報(bào)錯(cuò)怎么辦，小編覺得挺實(shí)用的，因此分享給大家做個(gè)參考，希望大家閱讀完這篇文章后可以有所收獲。

我們提供的服務(wù)有：成都網(wǎng)站建設(shè)、網(wǎng)站設(shè)計(jì)、微信公眾號(hào)開發(fā)、網(wǎng)站優(yōu)化、網(wǎng)站認(rèn)證、禮縣ssl等。為成百上千企事業(yè)單位解決了網(wǎng)站和推廣的問題。提供周到的售前咨詢和貼心的售后服務(wù)，是有科學(xué)管理、有技術(shù)的禮縣網(wǎng)站制作公司

   expdp導(dǎo)出數(shù)據(jù)時(shí)候出現(xiàn)報(bào)錯(cuò)如下：
[oracle@jxrac1 exp_dir]$ expdp system/Ora_123654abc directory=cis_dir schemas=jxcmsuer  dumpfile=jxcmsuer.dmp logfile=jxcmsuer.log flashback_scn=21750361864 parallel=4
Export: Release 12.1.0.2.0 - Production on Fri Apr 13 16:17:08 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_03":  system/******** directory=cis_dir schemas=jxcmsuer dumpfile=jxcmsuer.dmp logfile=jxcmsuer.log flashback_scn=21750361864 parallel=4 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 132 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/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
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
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/JOB
. . exported "JXCMSUER"."JXC_PLAN_REPAYMENT"             48.08 MB  664579 rows
ORA-31693: Table data object "JXCMSUER"."JXC_PLAN_REPAYMENT_180307" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/data/back/exp_dir/jxcmsuer.dmp" for write
ORA-19505: failed to identify file "/data/back/exp_dir/jxcmsuer.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "JXCMSUER"."JXC_PLAN_REPAYMENT_0301" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/data/back/exp_dir/jxcmsuer.dmp" for write
ORA-19505: failed to identify file "/data/back/exp_dir/jxcmsuer.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
. . exported "JXCMSUER"."JXC_INVESTMENT_MATCHING"        5.604 MB   34343 rows
. . exported "JXCMSUER"."JXC_U_CREDITORS_RIGHTS_180307"  3.104 MB    3619 rows
. . exported "JXCMSUER"."JXC_HS_AUTO_DEBT_ASSIGNMENT"    1.579 MB   20690 rows
. . exported "JXCMSUER"."JXC_BID_INFO"                   1.198 MB    7414 rows
ORA-31693: Table data object "JXCMSUER"."JXC_U_CREDITORS_RIGHTS" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-31617: unable to open dump file "/data/back/exp_dir/jxcmsuer.dmp" for write
ORA-19505: failed to identify file "/data/back/exp_dir/jxcmsuer.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

修改數(shù)據(jù)庫(kù)參數(shù)aq_tm_processes
[oracle@jxrac1 exp_dir]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 13 16:22:00 2018
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> show parameter aq_tm_processes;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     2
SQL> alter system set aq_tm_processes=1 scope=memory;
System altered.
SQL> show parameter aq_tm_processes;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     1

重新導(dǎo)出數(shù)據(jù)，報(bào)錯(cuò)消失，導(dǎo)出正常。

關(guān)于“expdp導(dǎo)出數(shù)據(jù)時(shí)候出現(xiàn)報(bào)錯(cuò)怎么辦”這篇文章就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，使各位可以學(xué)到更多知識(shí)，如果覺得文章不錯(cuò)，請(qǐng)把它分享出去讓更多的人看到。

名稱欄目：expdp導(dǎo)出數(shù)據(jù)時(shí)候出現(xiàn)報(bào)錯(cuò)怎么辦-創(chuàng)新互聯(lián)
當(dāng)前路徑：http://bm7419.com/article10/didido.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供定制開發(fā)、搜索引擎優(yōu)化、小程序開發(fā)、網(wǎng)站導(dǎo)航、商城網(wǎng)站、定制網(wǎng)站

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)