The recent discovery of Oracle 11g on a cloud server in the Export Times error is as follows:
...
. Exporting Post Table Activity
. Exporting the manifested view
. Exporting snapshot logs
EXP-00008: Encountering ORACLE Error 1455
ORA-01455: Converting column overflow integer data type
EXP-00000: Export termination failed
Search from the internet for half a day, there are a lot of saying:
1. Version issue, said 10g export 11g has this problem, but my client and server are the same version, so there is no version issue. Some also say 32-bit and 64-bit problems, my Oracle is 32-bit, the client is also 32-bit, on the same device, so should be unrelated to the version.
2. Exp Plus parameters, many people propose to add various parameters, including:
Direct=y
Indexes=n Statistics=none
Whether it is used alone or in combination, it is invalid or an error.
3, data problems, I simply do not export data, only export database structure, still error, it seems that data-independent.
Calm down to consider a half-day, see is the snapshot log error, but my database does not establish a snapshot ah? Later, although there is no snapshot, but the establishment of materialized view (materialized view), is it a materialized view of the problem?
Delete materialized view after export, all normal, description or materialized view export caused error, really a big hole ah, these export files in re-import all to error, backup work is white did. Fortunately, I found it early!
Oracle 11g Export Datagram "ORA-01455: Converting column overflow integer data type" issue