Viewing Schema Release Numbers

If you are using an Oracle Database instance for your metadata repository, you can view the release number of the schema using SQL*Plus, as follows:

SQL> COL COMP_ID FORMAT A20
SQL> COL COMP_NAME A30
SQL> COL VERSION FORMAT A20
SQL> SELECT COMP_ID, COMP_NAME, VERSION FROM SCHEMA_VERSION_REGISTRY;
COMP_ID              COMP_NAME                     VERSION
-------------------- ----------------------------- --------------------
APM                  Authorization Policy Manager  11.1.1.3.0
BAM                  BAM Services                  11.1.1.5.0
BIPLATFORM           OracleBI and EPM              11.1.1.4.0

Leave a Reply

Your email address will not be published. Required fields are marked *