Home > Data Miner 4.0 > Oracle Data Mining Applicat... > Install Prerequisites and O... > Installation Strategy > Overview of Installation Sc... > Drop the Data Miner Repository
dropRepositoryAndUserObjects.sql
drops the Repository and the user objects.
Before you drop the Repository, check that no projects or workflows are open. If any connections are open, the script may fail.
Example: @dropRepositoryAndUserObjects.sql
During the process of dropping the repository:
The Database does not allow any new connections to be established during this process.
Any connections granted rights to the Data Miner Repository are disconnected.
These steps are taken to ensure there are no conflicts in dropping 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 dropped.
For more details, read the script or see Drop the Data Miner Repository Using the GUI.
See Load or Drop Sample Data to drop the sample data.