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