home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!gatech!hubcap!ncrcae!ncrlnk!usglnk!usdsd1!slindemn
- From: slindemn@usdsd1.DaytonOH.NCR.COM (Steve Lindeman)
- Newsgroups: comp.databases.oracle
- Subject: Moving ORACLE system tablespace datafiles
- Message-ID: <1523@usdsd1.DaytonOH.NCR.COM>
- Date: 27 Jul 92 13:56:31 GMT
- Reply-To: slindemn@usdsd1.DaytonOH.NCR.COM (Steve Lindeman)
- Distribution: na
- Organization: NCR USG Data Services Division
- Lines: 37
-
-
- 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@DaytonOH.NCR.COM
- Data Services Division Phone: (513) 445-3688
- USG DSD Systems Architecture Fax: (513) 445-4176
-