Moving/Renaming the Data Files of a Tablespace 

Actions of SAPDBA to move or rename the data files of a tablespace with Move/rename data files of a tablespace (script name):

Preparatory phase

  1. Generates the <timestamp> subdirectory in the working directory and the log <time stamp>.rmv .
  2. Defines the new data file (possibilities which are supported by SAPDBA: enter the new path, generate a symbolic link, allocate a file, allocate a raw device).
  3. Generates the SQL and shell scripts and the restart file restart.rmv in the <timestamp> subdirectory (see Restart File for Reorganizations).
  4. Checks whether there will be sufficient space available for the file(s) of the tablespace in the selected file system(s). Further information of SAPDBA (for example whether or not directories should be deleted).
    5.

    Main phase
  5. For the SYSTEM tablespace or a tablespace with rollback segments:
    Closes the database instance with     shutdown immediate . The instance is then brought to mount status.

    6. For all other tablespaces: sets the tablespace offline (database remains open).

  6. Adjusts the file structure at operating system level (possibly creates new directories, moves the files, deletes old directories and symbolic links if there is no more data in the directory, etc.) ( del<TSP>.sh ).
  7. Possibly renames the data files, saves the old and new control file ( ren<TSP>.sql ).
  8. Opens the database or sets the tablespace online (depending on the action taken in step 5).