My Oracle Support Banner

Export of Config Schema Does Not Include All Tables in Schema When Attempting to Clone OFSAA Environment with Oracle 19c (Doc ID 2757218.1)

Last updated on MAY 15, 2024

Applies to:

Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.1.0.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.1.0.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When attempting to clone an OFSAA environment that uses an Oracle 19c Database, you are unable to export all tables in the 'config' schema.  Checking the export log, only 22 tables are exported from the config schema when it contains hundreds of tables.  There are no errors in the export log.

The export is launched with the following command:

expdp <USER>/<PASSWORD>@<SID> schemas=<SCHEMA NAME> directory=DPUMP_DIR dumpfile=<NAME>.dmp logfile=<NAME>.log

You expect all 'config' schema tables to be added to the *.dmp file.

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
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.