The application provides a SQL script that you can run to transfer the tables and indexes for a data mining run to a different tablespace. For example, you might want to move a frequently used run to its own tablespace to improve performance, or move a run to a different tablespace to facilitate archiving of the run at the tablespace level.
1. Click Settings.
The Settings page appears.
2. In the Administer System section, click Manage Run Storage.
The Manage Run Storage page appears.
3. Click the row menu (
) for the run, and then click Create Move Script.
The Move Run Script page appears and displays a SQL script.
4. Copy the SQL script and paste it into an ASCII text editor, such as Notepad.
5. Edit the script to define the destination tablespace for the run.
6. Save the script in a text file and execute it using Oracle tools.