Home > Administer Data Miner > Status and Version of Data ...
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.