My Oracle Support Banner

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

Last updated on APRIL 16, 2018

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.

NOTE:  ALL database changes should first be tested in staging.  NEVER Run an update statement without first testing the select part of the statement.  Also test it before and after you run the statement.

For example.  If you need to set the review date on one article.

1. Build your update statement.  But DO NOT run it yet.

UPDATE CONTENTTEXT SET displayreviewdate = NULL
WHERE documentid = 'FAQ1' AND majorversion = 2 AND minorversion = 3;

2. Build a select statement into the first statement and run just the select.

-- UPDATE CONTENTTEXT SET displayreviewdate = NULL
SELECT * FROM CONTENTTEXT
WHERE documentid = 'FAQ1' AND majorversion = 2 AND minorversion = 3;

3. When you have determined the one row that will be updated, then you can run the update.

UPDATE CONTENTTEXT SET displayreviewdate = NULL
-- SELECT * FROM CONTENTTEXT
WHERE documentid = 'FAQ1' AND majorversion = 2 AND minorversion = 3;

4. Verify the counts from #2 is the same as the count from #3.

5. Check your updated data - notice the value in displayreviewdate.

-- UPDATE CONTENTTEXT SET displayreviewdate = NULL
SELECT * FROM CONTENTTEXT
WHERE documentid = 'FAQ1' AND majorversion = 2 AND minorversion = 3;

 

 

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.