EXP-00008: ORACLE error 1455 encountered


I an facing below error when attempting to export schema level on 12.1 oracle database.

[oracle@sonu EXPIMP]$ exp system/password owner=DEV file=DEV.dmp log=DEV.log statistics=none

EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00056: ORACLE error 1403 encountered
ORA-01403: no data found


solution :-


Try adding below parameter to resolved this issue.

constraints=n indexes=n statistics=none

[oracle@sonu EXPIMP]$ exp system/password owner=DEV file=DEV.dmp log=DEV.log constraints=n indexes=n statistics=none


issue resolved.



No comments:

SHRD0014: GLLEZL - process exiting with failure

  SYMPTOMS Journal Import completes with the following error: Error ------ ORA-01653 : unable to extend table GL.GL_IMPORT_REFERENCES ORA-01...