Re: Moving System Tablespace
From: Lun Wing San (Oracle) <"Lun>
Date: 1996/12/05
Message-ID: <32A71683.4604_at_qrcsun.qrc.org>#1/1
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-5841Received on Thu Dec 05 1996 - 00:00:00 CET