Status and Version of Data Miner Repository

The following query returns the Repository Version number and the status of the Data Miner Repository:

set echo on;
-- value of VERSION and REPOSITORY_STATUS
select property_name, property_str_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES
where property_name IN ('VERSION','REPOSITORY_STATUS');

The following log is produced when you run the script:

-- value of VERSION and REPOSITORY_STATUS
 
select property_name, property_str_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES
where property_name IN ('VERSION','REPOSITORY_STATUS')
 
PROPERTY_NAME PROPERTY_STR_VALUE
------------------------------ ------------------------------
VERSION 11.2.0.1.12
REPOSITORY_STATUS LOADED 

The Data Miner repository has two values for status NOT_LOADED and LOADED.

The status is NOT_LOADED, usually indicates that an the Repository is being upgraded to support a new version of SQL Developer or a new patch release. When the upgrade completes, status is LOADED. If an upgrade fails, you must determine why the upgrade failed and run the upgrade again.