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:

ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%'

 This MySQL error — ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%' — means that MySQL cannot find the user ...