Re: Moving System Tablespace

From: Lun Wing San (Oracle) <"Lun>
Date: 1996/12/05
Message-ID: <32A71683.4604_at_qrcsun.qrc.org>#1/1


Leslie Carter wrote:
>
> I am trying to reorganize a database and am moving some tablespaces to
> different disks. To do this I am bringing the tablespace offline, then
> issuing an alter tablespace rename datafile command. Can I do this with
> the system tablespace? My question is if I take the system tablespace
> offline and rename it, how will the data dictionary get updated?

  Yes, you can do in this way and it is suggested by Oracle manual. The name and the location of the datafile(s) are stored in control file not data dictionary.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841
Received on Thu Dec 05 1996 - 00:00:00 CET

Original text of this message