Re: Moving System Tablespace

From: Chakravarthy Nalamotu <kittu_at_gis.eng.hawaii.edu>
Date: 1996/12/03
Message-ID: <58275v$g87_at_news.Hawaii.Edu>#1/1

You can do this while the database is mounted but closed. This way you do not have to take the SYSTEM tablespace offline.
Make sure, you backed up the database before doing this.
Kittu.

Leslie Carter (leslie_at_darth.lfso.loral.com) 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?
Received on Tue Dec 03 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: gregk18588_at_aol.com: "reading image files from Oracle Forms"
In reply to Leslie Carter: "Moving System Tablespace"
Next in thread: Brian Wolkowski: "Re: Moving System Tablespace"

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

Original text of this message