About EXP-00056: Encountering ORACLE Error 1455 ORA-01455: Conversion column overflow integer data type EXP-00000: Export termination Failure Problem Solving method collation

When the client exports the database with exp, the following conditions are encountered

...

....

......

.. The synonym is being exported. Exporting view EXP-00056: Encountering ORACLE Error 1455 ORA-01455: Conversion column overflow integer data type EXP-00000: Export termination failed

EXP-00056: Encountering ORACLE Error 1455 when table, synonyms, and views appear

I have encountered this problem two times in a row.

I have checked many posts online, the solution is different:

The first type:

sql> connect/as sysdba sql> @catmetx. SQL sql> @utlrp. SQL Sql> exit

This method I did not go to verify!

The second type:

Most say the Oracle client version is inconsistent with the database server version

So I did the exp operation on the server.

The final export is successful, but there is a warning!

This problem was solved the first time it appeared.

However, I do not agree with this statement, because before this I have successfully exported data and now can export other user data, database server on one, the environment is the same, so I think it should not be a version of the problem.

The third type:

ORA-01455: The transform column overflows the integer data type, and the Export command transforms the table's statistics value into shaping. This error is reported when the statistics value exceeds 2^31-1. Finally, after the exp command, add "Indexes=n statistics=none" two parameters. EXP username/password File=c:\xxx.dmp indexes=n statistics=none

Once tried against me this situation has no effect, if you are caused by this reason, give you a connection reference http://wenku.baidu.com/link?url= Yc5zsoibg5zlpflu8ofud8x3ljj4tuglz1hhi6duhniwj38tpf7nmn1gmb39gpmhxcrzmtyghza5p0qqolk0o4-ojulkoxir2ib9-4kmzk7

The fourth type:

Exp.exe to use Expdp.exe similar to import when using the Impdp.exe command in the Plsql/dev method to change to E:\oracle\product\10.2.0\client_2\bin\expdp.exe.

I've tried this method without success.

The fifth type:

Materialized view causes

Delete materialized views and insert operations on associated tables

Successfully resolved once, but I encountered another database with no materialized views.

The sixth type:

There is a compile not through the view, first delete can PS: And on the internet, found that there are also index,trigger caused similar errors

I have not confirmed this method yet.

By the time I present the second case in the export, the log content is as follows:

1, the database server export success, but there is a warning!

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-production with the partitioning, OLAP, Data Mining and R EAL Application Testing Options exported ZHS16GBK character set and Al16utf16 NCHAR character set

The specified user is about to be exported .... Exporting Pre-schema process objects and operations. Exporting the external function library name for user XXX. Export the public type synonym. Exporting a private type synonym. Exporting user xxx Object type definition EXP-00097: Object Type "XXX". " Sys_plsql_75837_219_1 "is not in a valid state and does not export type EXP-00097: Object Type" XXX "." Sys_plsql_75837_145_1 "is not in a valid state and does not export type EXP-00097: Object Type" XXX "." Ku$_collection_t "is not in a valid state and does not export type EXP-00097: Object Type" XXX "." ku$_tablespace_t "is not in a valid state and will not export the object that the type is about to export XXX .... Exporting database links. The ordinal is being exported. The cluster definition is being exported. The table that is about to export XXX passes the regular path .... . Exporting table AAA exported 40 rows

.

.

.

. The synonym is being exported. The view is being exported. The stored procedure is being exported. The operator is being exported. The referential integrity constraint is being exported. The trigger is being exported. The index type is being exported. Exporting bitmaps, functional indexes, and extensible indexes. Exporting post table activity. Exporting the manifested view. The snapshot log is being exported. The job queue is being exported. Exporting refresh groups and subgroups. The dimension is being exported. Exporting Post-Schema process objects and operations. Exporting statistics export successfully terminated with warning.

2, the client on the export failed, the content is as follows:

...

....

......

.. The synonym is being exported. Exporting view EXP-00056: Encountering ORACLE Error 1455 ORA-01455: Conversion column overflow integer data type EXP-00000: Export termination failed

I noticed that the object was invalid and the hint was given.

But failure this time is not prompted to have invalid objects.

So the conclusion is that I think there are two cases, the first one is due to inconsistent character set between the customer service and server side, and the second may be related to the invalid object.

About EXP-00056: Encountering ORACLE Error 1455 ORA-01455: Conversion column overflow integer data type EXP-00000: Export termination Failure Problem Solving method collation