ORA-27046: file size is not a multiple of logical block size

dawn009發表於2014-11-03
BloC
 
今天用資料泵搭建的同步環境同步失敗了，報錯資訊如下：
ORA-39002: invalid operation
ORA-31694: master table "" failed to load/unload
ORA-31640: unable to open dump file "" for read
ORA-19505: failed to identify file ""
ORA-27046: file size is not a multiple of logical block size
    由於目標庫和源庫的db_block_size不一樣，我還擔心是不是這個原因呢，後來查了一下metalink，不是這個原因。後來我仔細想了想，也不會跟db_block_size有關係，不然怎麼會還支援跨平臺的資料匯入匯出呢。
解決辦法是把dmp重新ftp一下，發現大小果真和之前有問題的dmp大小不一樣，所以看來還是網路上造成傳輸時的資料丟失了。
 
 
IMPDP Fails With ORA-39002, ORA-31694, ORA-31640, ORA-19505, ORA-27046 [ID 785473.1]
--------------------------------------------------------------------------------
 
  修改時間 10-DEC-2010     型別 PROBLEM     狀態 PUBLISHED  
In this Document
  Symptoms
  Cause
  Solution
  References
 
--------------------------------------------------------------------------------
 
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 and later   [Release: 10.1 and later ]
Information in this document applies to any platform.
Symptoms
IMPDP fails with the following errors:

ORA-39002: invalid operation
ORA-31694: master table "" failed to load/unload
ORA-31640: unable to open dump file "" for read
ORA-19505: failed to identify file ""
ORA-27046: file size is not a multiple of logical block size
 

Cause
The exported dump file is corrupt.
 
Solution
If the dump file came from a different system, then check if a binary transfer has taken place to transfer it to the current system. Also check the file size and if possible the checksum of the dump file.
If the problem persists:
•recreate the dump file by restarting the EXPDP process and make sure EXPDP completes without errors
•verify that the directory pointed to by the DIRECTORY parameter can be read from and written to without any problems. This can e.g. be done by performing an EXPDP and IMPDP operation or by using the UTL_FILE PL/SQL routine to read from and write to a file in this directory
 
References
NOTE:206272.1 - New Method of Using UTL_FILE in Oracle9i 9.2
NOTE:266875.1 - Export/Import DataPump Parameter DIRECTORY - How to Specify a Directory
 
 
 
 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29119536/viewspace-1318520/，如需轉載，請註明出處，否則將追究法律責任。

相關文章