Home > Data Miner 4.0 > Oracle Data Mining Applicat... > Install Prerequisites and O... > Installation Strategy > Drop the Data Miner Reposit...
If you plan to stop using Data Miner, you should drop the Repository. You may have to Drop the repository when you upgrade from one version of Oracle Database to another. When you drop the Repository, all workflows and internal tables are dropped. Models created by Oracle Data Miner are dropped. Tables created by the Create Table or View node are not dropped.
Note: Drop Repository cannot be undone. When you drop a repository, the repository and all internal user objects created by Data Miner are permanently removed.The objects removed include models, tables or views generated by the Create Table node, hidden tables used store results (model viewers), and text specification objects used to support text transformations. In addition all Data Miner workflows are dropped. To save a workflow, export it and later import it as described in Import and Export Workflows. |
Before you drop the Repository, check that no projects or workflows are open. If any connections are open, the process may fail.
For Drop Repository to complete successfully, no sessions with the role of ODMRUSER can be active. (Active ODMRUSER sessions can result in object locks that block dropping of the repository.)
During the process of dropping the repository:
The Database does not allow any new connections to be established during this process.
All sessions with the ODMRUSER role are automatically disconnected.
All workflows and internal tables are dropped. Models created by Oracle Data Miner are dropped. Tables created by the Create Table or View node are dropped, as described in the earlier note.
After you drop the repository, you must install the repository again before you can perform any data mining. See Install the Data Miner Repository Using the GUI or Install the Repository Using Scripts.