Oracle Designer/Oracle SCM Meta Model 20188367001

Oracle Designer/Oracle SCM Meta Model

This post – or rather its comments – contain some investigations into the Designer 9i/10g Meta Model and Meta Meta Model. That is: the tables that contain the definitions for the Designer Model. There are three levels at stake here:

  1. Model: the definition of a table as defined by the developer and to be generated into the Application Schema in the Database
  2. Meta Model (or Designer Model): the Designer tables that contains the table and column definitions as created by the developer; this table is called i$sdd_tab
  3. Meta Meta Model (or Designer Meta Model): the Repository Model table that contains the definition of the table i$sdd_tab along with the tables that contain definitions for all properties (columns) of the table definitions (the i$sdd_tab table); these tables are called i$rm_element_types and i$rm_properties (for the logical definitions) and i$rm_sql_tables and i$rm_sql_columns

A good place to start working is the Designer Meta Model Application System (Dump), as presented on the AMIS website, see Article on Designer 9i/10g Meta Model.

I use the Designer Meta Model primarily in the extensions to the Repository Object Browser I am currently working on.


  1. Pingback: Headphones For Less April 29, 2007
  2. Pingback: High Heel Shoes Store April 28, 2007
  3. Pingback: Honda Auto Parts Locator April 25, 2007
  4. Pingback: Camping Equipment Cheap April 22, 2007
  5. Lucas Jellema July 9, 2004
  6. Lucas Jellema July 9, 2004
  7. Lucas Jellema July 9, 2004