TSPITR Expdp Phase Limits The Number of Exported Tablespaces, e.g. to 137 (Doc ID 1967439.1)

Last updated on FEBRUARY 23, 2015

Applies to:

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

Symptoms

Performing TSPITR using RMAN. The recover tablespace command includes more than 137 tablespaces. In this case there were 240 tablespaces.

The recovery set of tablespaces is self contained and all works fine but the expdp phase only exports 137 tablespaces from the 240 as mentioned in the recover tablespace command.

Trying several times, the expdp phase always exports 137 tablespaces as maximum. There is no error and expdp completes successfully but simply skips the rest of the tablespaces after 137.

Changes

None, simply trying to perform TSPITR with more than 137 tablespaces.

NOTE:
The number of tabelspaces may differ, e.g. in another situation with a 11.2.0.4 TSPITR of 231 tablespaces, the expdp exported the first 227 tablespaces.

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