Where is the IM datadictionary schema? (Doc ID 1039541.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

Oracle Knowledge - Version 8.0.x and later
Information in this document applies to any platform.
Information in this document applies to any platform.

Symptoms

Where is the IM datadictionary schema?

The IM data dictionary schema is located in $IM_HOME/database folder. 
The name of the file is called datadictionary.html

Here all the IM database tables are defined.  They can be used but should never be updated without the direction of oracle product support. If there is a corruption please open an Oracle support request.

Updating metadata is not supported without the direction of product engineering for a known issue. The product interface should always be used to change the metadata.  If that is not possible then a SR should be created with Oracle support to resolve the issue.  If there is some created corruption of data by someone updating the database directly a backup should be used to restore the information.  Or there may be a database in another environment that can be used.  Oracle support also does not build report SQL for these tables outside the context of product issues.  Please investigate with your DBA first.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms