EXP: ORA-1455 is raised when exporting from an 11.2 database using a 9i,10g or 11gR1 exp utility
(Doc ID 1381690.1)
Last updated on MARCH 04, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 9.2 to 11.1]
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.
When attempting to export data from an 11.2 database via a pre-11.2 traditional export utility (EXP), the export operation raises ORA-1455 errors.
Note that the ORA-1455 errors raised due to the problem discussed in this note may be raised at any point during the execution of traditional export operation.
Additionally, the query below, when issued against the source 11.2 database must return at least one row for the cause of the ORA-1455 error to possibly be the same cause as described in this document:
The 11.2 database was created and the initialization parameter DEFERRED_SEGMENT_CREATION was left at its default value of TRUE.
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