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 MARCH 17, 2021
Applies to:Oracle Financial Services Profitability Management - Version 126.96.36.199.0 and later
Oracle Financial Services Asset Liability Management - Version 188.8.131.52.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 184.108.40.206.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
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.
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