DataPump Export/Import Ignore LOB Storage Parameters For GLobal Temporary Tables (Doc ID 2223015.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

DataPump Export doesn't extract the Lob Storage Parameters in the dump file for global temporary tables.

Example:
-----------
- On source database, a global temporary table is created with the following clause for lob storage:

create global temporary table t1 (c1 number, c2 clob) lob (c2) store as basicfile (enable storage in row retention max cache reads);

- Checking the dump file created by the export and generating the sql file for that table on the source database shows:

CREATE GLOBAL TEMPORARY TABLE "TEST"."T1"
( "C1" NUMBER,
"C2" CLOB
)
ON COMMIT DELETE ROWS ;

==> DDL statement is incorrect as Lob Storage Parameters clause is missing.

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