Dropping Mining Activities Created in Oracle Data Miner Classic

If your database contains mining activities from Oracle Data Miner Classic, delete the mining activities and drop the repository before upgrading the database. Follow these steps:

1. Use the Data Miner Classic user interface to delete the mining activities.

2. In SQL*Plus or SQL Developer, drop these tables:

   DM4J$ACTIVITIES
   DM4J$RESULTS
   DM4J$TRANSFORMS
   

   and these views:

   DM4J$MODEL_RESULTS_V
   DM4J$RESULTS_STATE_V
   

There should be no tables or views with the prefix DM4J$ in any schema in the database after you complete these steps.