Oracle exp EXP-00008 and ORA-01455: Converting column overflows integer datatype Solution

 

This error may occur when Oracle exports a database using Exp:

 

Encountering errors in export logfile
EXP-00008: Oracle Error # encountered.
ORA-01455: Converting column overflows integer datatype

 

This error is not reported when the parameter indexes = n statistics = none is added to the exp command.

 

Cause of this error:

The Export command converts the statistics value of the table to an integer. This error is reported when the statistics value exceeds 2 ^ 31-1.

 

 

 

Solution:

 

1. view the values of the corresponding table through dba_tables and dba_indexes. That is, the num_rows value to check whether it exceeds 2 ^ 31-1.

If the numrows of a table exceeds the value, you can manually modify the value of the table, for example:
SQL> execute SYS. dbms_stats.set_table_stats ('Scott ', 'emp', numrows => 1000000000000 );

 

Command Format:

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

 

2. Delete the corresponding statistics

Table:

SQL> analyze table <table_name> Delete statistics

Index:

SQL> analyze index <index_name> Delete statistics
Or use:

Execute SYS. dbms_stats.delete_index_stats (ownname => 'Scott ', indname => 'my _ indx_1 ');

Execute dbms_stats.delete_table_stats (ownname => 'Scott ', tabname => 'table _ name ')

 

After the modification, You can import the data.

 

 

 

Bytes ---------------------------------------------------------------------------------------------------

Blog: http://blog.csdn.net/tianlesoftware

Online Resources: http://tianlesoftware.download.csdn.net

Video: http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Chat group: 40132017

-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.