Home > Administer Data Miner > Data Miner Internal Tables
Tables and views whose name has the prefix ODMR$
are created by Data Miner to support workflows. For example, the Transformation Node generates a number of statistics to assist the user in performing transformations. The ODMR$
tables and views contain data that is necessary for a workflow to operate.
ODMR$
tables and views are created in the user's schema. The ODMRSYS schema does not contains tables and views that support workflow, instead it contains metadata information about the workflows.
If you delete a workflow all of the ODMR$
tables and views are automatically deleted.
You can use SQL Developer filtering to filter out these tables and views. Applying a filter makes it easier to navigate a schema that contains many of these objects.
If space utilization is a problem, delete workflows that you no longer need.
To preserve a workflow and still free up space, export the workflow and then delete it.
If you need to track and manage space utilization more closely, you can use two separate tablespaces, one for the ODMRSYS (repository) and one for the users.