Importing the FDMEE Schema (Oracle Database)

Oracle Hyperion Financial Data Quality Management, Enterprise Edition Release 11.2.15 includes a utility—aif_import.par—to import metadata and data from the aif_objects.dmp file that you exported from Release 11.2.12+. Use Oracle Data Pump to import the Release 11.2.12+ schema into the Release 11.2.15 schema.

To import the FDMEE schema to Release 11.2.15:

Execute the following command from the Oracle Data Pump location on the Release 11.2.15 database server to import the data:
```
impdp remap_schema=<SOURCE SCHEMA NAME>:<TARGET SCHEMA NAME> parfile=aif_import.par
```
where <SOURCE SCHEMA NAME> is the name of the Release 11.2.12+ schema.

where <TARGET SCHEMA NAME> is the name of the Release 11.2.15 schema.

aif_import.par imports the metadata and data from aif_objects.dmp to the new schema.

You can ignore "ORA-31684: Object type INDEX XXXX already exists" error.

For Oracle Database 21c - Ensure that you open the pluggable database and set <CONTAINER=PDB NAME> as indicated below, prior to executing the import command:
```
ALTER PLUGGABLE DATABASE ALL OPEN;
ALTER SESSION SET CONTAINER=<PDB NAME>
```
```
impdp <user>/<password>@<PDB SID> remap_schema=<SOURCE SCHEMA NAME>:<TARGET SCHEMA NAME> parfile=<DIR PATH>/aif_import.par
```
After the import process is complete, execute the following SQL in the Release 11.2.15 database server environment to complete the database configuration. Log in as the user who owns the FDMEE tables for release 11.2.15:
```
aif_post_import_updates.sql
```