暂无图片
数据泵导出报错,请教大师帮助
我来答
分享
手机用户0523
2023-11-13
数据泵导出报错,请教大师帮助

ORA-31693: Table data object "NCDARE"."ERP_SALE_WORKPIECE_DTL" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLECLOSE callout
ORA-31643: unable to close dump file "/ncformal/nc_2023111122.dmp"
ORA-19510: failed to set size of 53541802 blocks for file "/ncformal/nc_2023111122.dmp" (block size=4096)
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9
ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
Job "NCDARE"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at Sun Nov 12 07:22:03 2023 elapsed 0 09:21:57
to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."IA_MONTHNAB" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."PO_PURCHASEINFI_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."SO_SQUAREINV_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."SO_SALEINVOICE_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."IC_PURCHASEIN_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."AP_PAYABLEITEM" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."SO_SQUAREOUT_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."BD_MATERIALPLAN" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."PO_ORDER_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."TB_CUBE_JTBUDGET" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."AR_RECITEM" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CM_STUFF_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."IA_MONTHOUT" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."SO_DELIVERY_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."SO_SALEORDER_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CM_ALCRECORD_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."PO_INVOICE_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1679790" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."BD_MARORG" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."SO_SQUAREINV_D" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."ARAP_TALLY_ALL" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."BD_MATERIALFI" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."BD_MATERIALSTOCK" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."IC_MONTH_RECORD" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."IC_FINPRODIN_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."PO_SETTLEBILL_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1644937" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."MM_PICKM_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."IA_I3BILL_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."IA_GOODSMONTHNAB" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."BD_MATERIALCOST" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."BD_MATERIALPROD" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."IA_MONTHIN" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."MM_WR_PRODUCT" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1668353" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."BD_MATERIALCOSTMOD" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."IC_FLOWDETAIL" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1670261" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1664118" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."MM_REQPICKM_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."BI_SCHD_TASKQUEUE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$822945" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."SM_LOG_OPERATELOG" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1682151" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1681521" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."ARAP_TERMITEM" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."IA_I2BILL" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1655131" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."IC_MONTH_HAND" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1663537" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1477297" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."BD_MATERIALPU" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1647762" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."ME_SALEOUTPRO" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1655205" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."BD_MATERIALSALE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$830541" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1646782" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CM_PRODCOST_B" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$812371" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1656688" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."PUB_ASYNC_RESULT" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1672180" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$1684042" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$804857" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."IC_MATERIAL_H" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."SO_SQUAREOUT_D" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$805269" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CMP3$831573" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.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 "NCDARE"."CLIENT_RETMNG" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/ncformal/nc_2023111122.dmp" for write
ORA-19505: failed to identify file "/ncformal/nc_2023111122.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

我来答
添加附件
收藏
分享
问题补充
8条回答
默认
最新
伟鹏

你这个是集群环境导出的,还是单机?

暂无图片 评论
暂无图片 有用 3
打赏 0
手机用户0523
题主
2023-11-13
集群导出,没有设置parallel
手机用户0523
题主
2023-11-13
参数: schemas=ncdare directory=ncdare dumpfile=nc_$backuptime.dmp logfile=ncexpdp_$backuptime.log buffer=512000000
如果

你这个是集群环境导出的,还是单机?

暂无图片 评论
暂无图片 有用 0
打赏 0
手机用户0523
题主
2023-11-13
集群导出,没有设置parallel
酷逼小六子

看着像是磁盘空间不够了

暂无图片 评论
暂无图片 有用 0
打赏 0
伟鹏

集群导出的话,在导出语句加入个cluster=no

暂无图片 评论
暂无图片 有用 1
打赏 0
伟鹏

schemas=ncdare directory=ncdare dumpfile=nc_$backuptime.dmp logfile=ncexpdp_$backuptime.log buffer=512000000 cluster=no 这样,看你的数据量了,数据量打的话开,小的话就不开,这个无所谓。

暂无图片 评论
暂无图片 有用 3
打赏 0
手机用户0523
题主
2023-11-13
数据库目前大小是400G左右
手机用户0523
题主
2023-11-13
400G左右,数据泵导出要14个小时左右,这个正常吗?
伟鹏

14小时确实比较长了。这个怎么说呢,看你磁盘IO能力了,如果是老磁盘那个就搞得慢了;另外看看有没有大表(大表做分区表的话会很快)。

正常情况下400GB导出的话,开个4的并发,半个小时到一个小时是可以导出来的。还是上面说的磁盘能力差的话,那就另说了。

暂无图片 评论
暂无图片 有用 4
打赏 0
学习Oracle

是不是没有这个目录  /ncformal

暂无图片 评论
暂无图片 有用 1
打赏 0
手机用户0523
题主
2023-11-14
有这个目录,之前一直备份正常
始于脚下

备份磁盘目录空间满了,如果df -h有空间,就看一下df -i是不是iNode满了。

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
Oracle性能检测的工具有什么?
回答 2
性能测试工具吧,我一般用benchmarksql,模拟tpcc的基准测试。
Oracle中能不能用sql语句查到用户对哪些表空间有读写权限?
回答 1
已采纳
可以。首先,从dbausers表中可以查到用户的默认表空间,这个一般都是有读写权限的。然后,通过 selectfromdbatsquotas; 查出显式授权的用户和表空间对应关系。
sql server management 导出数据到oracle出错
回答 2
先保证ODBC的配置可以正常访问到Oracle实例。另外检查path等环境变量设置是否包含了Oracle的相关路径
oracle 生产环境都用ASM来管理数据文件吗?
回答 1
已采纳
一般RAC是用ASM来管理得,单机一般还是本地文件系统
alterlog报错
回答 4
ifconfiglomtu16384我这个lo的值是65536了还需要修改吗
oracle的数据文件可以放在不同的磁盘分区上,mysql能像oracle一样,将一些表放在不同的磁盘分区上吗?
回答 1
已采纳
这个就看你datadir的目录,是不是能做到多个磁盘分区都映射到一个目录下,linux还能做到。windows不行。
undo、temp
回答 1
提供一个关于UNDO的,来自于MOS文档:CommonDiagnosticScriptsforAUMproblems(DocID746173.1)
通过数据库执行sql执行不慢,但是对应前端报表加载慢
回答 1
看看返回行数多少,比如plsql只显示几十行,但是页面可能显示所有。这些都是网络传输。当然如果排除了这个,也可能是前端渲染的问题。
oracle12c procedure不能调试
回答 2
已采纳
当前用户没有调试新建存储过程的权限,用高权限用户给该用户赋权,执行以下命令试试GRANTDEBUGCONNECTSESSIONTO<user>;GRANTDEBUGANYPROCEDURE
Oracle数据库使用哪二个视图查询糟糕的SQL语句?
回答 1
已采纳
V$SQLAREA和V$SQL是很用的视图,可以使用它们来查找性能糟糕的需要优化的SQL语句。diskreads列的值显示了系统中执行的磁盘读的次数。将这个值除以执行次数(diskreads/exec