Re: Moving System Tablespace

From: Kevin Loney <"75663,327"_at_compuserve.com>
Date: 1996/12/04
Message-ID: <32A5B184.5B80_at_compuserve.com>#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?

See the DBA FAQs, I think this is number 5 or number 6. You need to use the ALTER DATABASE method for moving datafiles. Check www.osborne.com under the DBA Handbook entry.

Kevin Received on Wed Dec 04 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: N.Prabhakar: "Re: Moving System Tablespace"
Previous message: Thomas J. Kyte: "Re: Q:How can users change their login password?"
In reply to: Leslie Carter: "Moving System Tablespace"
In reply to Leslie Carter: "Moving System Tablespace"
Next in thread: N.Prabhakar: "Re: Moving System Tablespace"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message