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
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:
Post a Comment