EXP-00062: invalid source statements for an object type
剛剛處理完一件小事，一個系統，今天凌晨的EXP匯出是正常的，但現在匯出的時候報錯
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user WDRMS
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user WDRMS
EXP-00062: invalid source statements for an object type
EXP-00000: Export terminated unsuccessfully
Cause: TYPE was not found in the statements in SOURCE$ for an Object Type.
Action: Contact Oracle Support Services.
難道非要找Oracle技術支援麼？
先分析一下吧，不行再尋求技術支援
首先看看我們有什麼，1份今天早上的備份，還有就是雖然匯出不成功，但仍然生成的匯出檔案。
開啟剛剛生成的匯出檔案，看看最後的部分在做什麼
CREATE TYPE "T_RET_TABLE" TIMESTAMP '2012-09-15:15:35:15' OID 'C28FF015DFFF316DE040007F01006317'
建立一個TYPE，注意這個TYPE的建立時間，是今天下午，是否就是這個TYPE導致匯出不成功？
再看看凌晨的備份，沒有類似的TYPE，應該是可以定位問題了。
刪除這個TYPE，成功匯出
[@more@]來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/19423/viewspace-1059443/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- How to compile Invalid Object?CompileObject
- React報錯之Element type is invalidReact
- v$sql.object_status=INVALID_UNAUTHSQLObject
- error: invalid type argument of unary ‘*‘ (have ‘int‘) *__first = __tmp；Error
- TypeError: Object of type ‘datetime‘ is not JSON serializableErrorObjectJSON
- Oracle EBS 重新編譯無效物件 invalid objectOracle編譯物件Object
- Cannot decode object of class Employee for key (NS.object.0); the class may be defined in source cod...Object
- npm報錯 TypeError [ERR_INVALID_ARG_TYPE]: The “path“ argument must be of type string.Received undefineNPMError
- ES6 的Object.assign(target, source_1, ···)Object
- 記一次PHP的Invalid binding type問題PHP
- Oracle中查詢依賴的無效物件(invalid object)Oracle物件Object
- Invalid configuration object webpack dev server has been initialisedObjectWebdevServer
- err Invalid input of type: 'dict'. Convert to a byte, string or number first
- 異常解決java.io.IOException: invalid constant type: 15JavaException
- Parallel Execution of SQL StatementsParallelSQL
- iOS：“Invalid top-level type in JSON write”引起程式閃退iOSJSON
- 20171229V$DB_OBJECT_CACHE type='INDEX'ObjectIndex
- Oracle Text SQL Statements and OperatorsOracleSQL
- Syntax Error: ValidationError: Invalid options object. Stylus Loader has been initialized using anErrorObjectZed
- ORA-07445:oracle_[type: SIGSEGV, Address not mapped to object]OracleGseAPPObject
- vue報錯：[Vue warn]: Invalid prop: type check failed for prop "value". Expected Number, got String....VueAIGo
- R語言ggsurvplot繪製生存曲線報錯 : object of type ‘symbol‘ is not subsettableR語言ObjectSymbol
- Rasa init報錯：AttributeError: type object 'Callable' has no attribute '_abc_registry'ErrorObject
- oracle 資料泵 ORA-39112: Dependent object type COMMENT skippedOracleObject
- labelme2coco問題：TypeError: Object of type 'int64' is not JSON serializableErrorObjectJSON
- eclipse中：The type java.lang.object cannot be resolved錯誤（jdk配置錯誤）EclipseJavaObjectJDK
- PostgreSQL DBA(63) - Extension(pg_stat_statements)SQL
- DML Locks Automatically Acquired for DML Statements (349)UI
- 解決Tensorflow ValueError: Failed to convert a NumPy array to a Tensor (Unsupported object type numpy.ndarray)ErrorAIObject
- Chaining If Else Statements 巨坑的題目AI
- zt:Cardinality (SQL statements) 最好的解釋SQL
- variable: Type 與 Type variable
- .net source code
- cannot convert (type interface {}) to type int: need type assertion
- Value Type vs Reference Type in SwiftSwift
- rust-quiz:001-macro-count-statements.rsRustUIMac
- PostgreSQL pg_stat_statements模板介紹和部署SQL
- AC010--Preparing Financial StatementsNaN