).Empirica Signal 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. In the
left navigation pane, click the Settings icon
().
2. In the Administer System section, click Manage Run Storage.
3. Click the
Row Action menu (
) for the run, and then click
Create Move Script.
The Move Run Script page displays an 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.