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 FEBRUARY 03, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 9.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 16-Dec-2013***
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