My Oracle Support Banner

ORA-39187 & ORA-39921 for CLI_SWP$ tables while performing Full Transportable Tablespace export (Doc ID 2426177.1)

Last updated on MAY 19, 2022

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

1. You are trying to perform a Full Transportable Tablespace(TTS) export of the database by using the following parameters in the expdp command:

TRANSPORTABLE=ALWAYS

FULL=Y

VERSION=12

2. Unified Auditing has been disabled in the database and is not being used.

 

 

The export job aborts with the errors like this:

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.