Traditional Exports Can Fail With EXP-8 ORA-1455 Errors
(Doc ID 1295767.1)
Last updated on OCTOBER 05, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.5 [Release 10.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
You may encounter the following error/warning while trying to perform traditional export:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining Scoring Engine and Real Application Testing options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user <username>
exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export <username>'s tables via Conventional Path ...
. . exporting table <table_name_1>
. . exporting table <table_name_2>
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
. . exporting table <table_name_2>
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings
With the Partitioning, OLAP, Data Mining Scoring Engine and Real Application Testing options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user <username>
exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export <username>'s tables via Conventional Path ...
. . exporting table <table_name_1>
. . exporting table <table_name_2>
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
. . exporting table <table_name_2>
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |