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 DECEMBER 16, 2013

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms