Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I change an Instance location ?
Fabrice Bachellerie <fbachellerie_at_scopeland.de> wrote:
> I have one instance on C: and of course not enough place now.... Typical
> newbie...
first: *** CREATE FULL BACKUP ***
For control files: change their location in init.ora while the DB is offline.
For non-SYSTEM tablespaces: (database can be open)
Create a new RBS tablespace, new rollback segments, and drop the old ones (taking them offline first).
Create a new temporary tablespace.
for the SYSTEM tablespace, shutdown, startup mount, and rename the files.
startup (alter db open), shutdown normal.
when finished, *** CREATE FULL BACKUP ***
regards
raas
Received on Fri Jan 19 2001 - 06:37:54 CST