EXP-00056 ORA-1455

When exporting data with exp, exp-OOO56 is reported to the end, ORA-01455: the conversion column overflows the integer data type.

The reason for searching the Internet is that the Export command converts the statistics value of the table to an integer. If the value exceeds 2 ^ 32-1, an error is returned, check whether the num_rows value of dba_tables and dba_indexes exceeds this value. If manual modification is exceeded:

Dbms_stats.set_table_stats (<owner>, <table_name>, <statistic_field >=> <new lower value>)

Delete the corresponding statistics: Analyze table <table_name> Delete statistics

Analyze index <index_name> Delete statistics

According to this view, we found that the num_rows values in dba_tables and dba_indexes are not too large, so we decided to ignore them, if you can add the parameter indexes = n statistics = none to the exp command, this error is not reported. If you try it, an error is still returned.

In this case, check whether a stored procedure is being executed. Check and kill the locked process and try again, or report an error.

Finally, we can see that it is caused by views. Check that a view is not compiled successfully. Save the view statement, delete the view, and try again. No error is returned.

EXP-00056 ORA-1455