Moving ORACLE system tablespace datafiles

To: Any ORACLE V6 or V7 user
Subject: Moving a the datafiles associated with the system tablespace

Many people have posed the question how do I move a system tablespace datafile.
If a DBA refers to the index of the version 6.0 database guide (Database files renaming) he or she is directed to pages 16-14, G-2 and G-7. The instructions provided on page 16-14 of the ORACLE version 6.0 database guide gives very limited instructions for moving a datafile that is not part of the system tablespace. The instructions on this page do not mention that this command cannot be used to move a datafile that is part of the system tablespace. The instructions on pages G-2 and G-7 give two different methods to rename a datafile but do not provide any furthur guidence. These pages do not make any reference to the fact that different methods must be used if a system datafile is to be renamed.

STEPS TO MOVE A SYSTEM TABLESPACE DATAFILE:

1. The database must be mounted but not opened.
2. The file must be copied to it's new location using an operating system command.
3. Connect internal.
4. The alter database command must be used to rename the datafile.
5. Shut the database down.
6. Restart the database.
7. Remove the old file once you are certain that the new file name is being used by the database. Check the data dictionary table sys.dba_data_files to determine if the new file is being used.

-- 
Stephen A. Lindeman              E-mail:Steve.A.Lindeman_at_DaytonOH.NCR.COM 
Data Services Division           Phone: (513) 445-3688
USG DSD Systems Architecture     Fax:   (513) 445-4176