1. User Guide and Online Help
  2. Settings and administration
  3. Administer the system
  4. Manage run storage
  5. Move a data mining run with a Move script

Move a data mining run with a Move script

Oracle 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 (Settings icon).
  2. In the Administer System section, click Manage Run Storage.
  3. Click the Row Action menu (Row Action menu icon) for the run, and then click Create Move Script.

    The Move Run Script page now 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.

Parent topic: Manage run storage