My Oracle Support Banner

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 9.2.0.1 to 11.1.0.7 [Release 9.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 16-Dec-2013***

Symptoms

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:

Changes

The 11.2 database was created and the initialization parameter DEFERRED_SEGMENT_CREATION was left at its default value of TRUE.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.