ORA-01455: resolution for converting column overflow integer data type, ora-01455 Data Type
Export: Release 10.2.0.5.0-Production on Tuesday March 27 16:43:44 2018
Copyright (c) 1982,200 7, Oracle. All rights reserved.
Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
The ZHS16GBK and AL16UTF16 NCHAR character sets have been exported.
Will export the specified user...
. Exporting objects and operations in the pre-schema Process
. Exporting the external function library name of the user GLOBAL
. Export PUBLIC type Synonyms
. Exporting the special type Synonym
. Exporting the GLOBAL object type definition.
The GLOBAL object to be exported...
. Exporting database link...
. Exporting sequence number
. Exporting cluster Definition
. The GLOBAL table will be exported through the regular path...
.. Export table COLDESCRIPTION export 1948 rows
... Exporting table CS_ZH_SWRYDZB exported 2211 rows
... Exporting table DM_GY_SWJG 63 rows
... Exporting table DM_GY_SWRY export 445 rows
.. Export table DM_XZQH export 120 rows
.. Export table DOCMETHOD export 914 rows
.. Export table DOCRELATION export 223 rows
.. Export table DOCTYPE export 250 rows
.. Export table FIELDDEFINE export 2292 rows
.. Export table GSZJ_BGTXF_UPDATE $ _ TEMP export 464 rows
.. Export table GSZJ_DCDB_UPDATE $ _ TEMP export 138 rows
.. Export table GSZJ_FW_UPDATE $ _ TEMP export 742 rows
.. Export table GSZJ_NB_UPDATE $ _ TEMP export 229 rows
.. Export table GSZJ_SW_UPDATE $ _ TEMP export 93 rows
... Export table ODPSLOG export 6013 rows
EXP-00008: ORACLE error 1455
ORA-01455: conversion column overflow Integer Data Type
EXP-00000: Export termination failed
Solution:
Execute the following statement select 'altertable' | table_name | 'allocateextent; 'fromuser_tableswheresegment_created = 'no ';
Execute the execution results one by one to export the results normally.