ORA-39194 when doing rman table recovery with a large list of tables (Doc ID 2179723.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

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

Symptoms

 While using the Oracle 12 rman table recovery feature when we specify a list of approximately 200 tables in the rman recovery command it fails with error. The restore and recovery within the auxiliary instance works successfully, but when the export is attempted from the auxiliary instance an ORA-39194 error occurs.

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