Exporting the FDMEE Schema (Oracle Database)
Oracle Hyperion Financial Data Quality Management, Enterprise Edition Release 11.2.15 includes a utility
—aif_export.par
—to export data from the Release 11.2.12+
environment.
To export the FDMEE schema from Release 11.2.12+:
- In the Release 11.2.12+ environment, execute the Data Pump command from the Oracle Data Pump
location on the database server to export the data. For
example:
expdp parfile=<DIR PATH>/aif_export.par
Enter user credentials for the FDMEE schema.
Export produces the export data file in the default Data Pump output directory (
\Oracle\admin\orcl\dpdump
). The export filename isaif_objects.dmp
.For Oracle Database 21c - Ensure that you open the pluggable database and set
<CONTAINER=PDB NAME>
as indicated below, prior to executing the export command:ALTER PLUGGABLE DATABASE ALL OPEN; ALTER SESSION SET CONTAINER=<PDB NAME>
expdp <sourceuser>/<password>@<PDB SID> parfile=<DIR PATH>/aif_export.par
- Copy
aif_objects.dmp
to a location accessible to the Oracle Data Pump location on the database server in the Release 11.2.15 environment.
See the Oracle Database Utilities guide on the Oracle Help Center to familiarize yourself with the Oracle Data Pump Utility.