TSPITR Expdp Phase Limits The Number of Exported Tablespaces, e.g. to 137
Last updated on FEBRUARY 23, 2015
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
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.
None, simply trying to perform TSPITR with more than 137 tablespaces.
The number of tabelspaces may differ, e.g. in another situation with a 22.214.171.124 TSPITR of 231 tablespaces, the expdp exported the first 227 tablespaces.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms