Entering content frameProcedure documentation Moving or Renaming the Data Files of a Tablespace Locate the document in its SAP Library structure

Use

You can use SAPDBA for Oracle to move or rename the data files of a tablespace.

Prerequisites

Procedure

  1. Choose Reorganization ® Move/rename data files of a tablespace.
  2. Enter Tablespace name.
  3. This is the name of the tablespace for which you want to move or rename the data files.

  4. Enter the Working directory.
  5. This is the working directory for the reorganization. The default is <SAPDATA_HOME>/sapreorg or <SAPREORG> , based on the environment variable SAPREORG . Logs and scripts are saved in this directory. For more information on <SAPREORG> , see Environment Variables (UNIX) and Environment Variables (Windows NT).

  6. Choose Start to prepare for the reorganization.

SAPDBA prepares for the reorganization by:

  1. Reply to the prompts in the preparation phase as necessary.
  2. SAPDBA prompts you to change the data file specification.

  3. Enter the number of the data file that you want to change and choose a new path on a file system or raw device.
  4. SAPDBA performs the final checks and prompts you to start the reorganization.

  5. Choose how to start the reorganization:

Note

If you chose the SYSTEM tablespace or a tablespace with rollback segments, SAPDBA closes the database instance with shutdown immediate . The instance is then brought to mount status. After the reorganization, SAPDBA opens the database.

For all other tablespaces, SAPDBA puts the tablespace offline but the database remains open. After the reorganization, SAPDBA puts the tablespace online.

Result

On successful completion, SAPDBA displays a confirmation message.

If there has been an error, SAPDBA displays the appropriate error message. You can restart the reorganization after fixing the problem.

After the reorganization, you must back up the database. SAPDBA displays the backup menu on completion.

Leaving content frame