Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to move Tablespace / Database ??

Re: How to move Tablespace / Database ??

From: bgbgbg <brian.gallagher_at_iona.com>
Date: Tue, 19 Dec 2000 16:52:01 -0000
Message-ID: <91o47h$m50$1@bvweb.iona.com>

you can backup controlfile to trace
shutdown db
use o/s commands to move data files to new location
edit tracefile and change as appropriate
connect internal
startup nomount
run tracefile# -alter db open

rgds
brian Received on Tue Dec 19 2000 - 10:52:01 CST

This message: [ Message body ]
Next message: mikeys_at_web.de: "oracle upper error"
Previous message: Sybrand Bakker: "Re: How to move Tablespace / Database ??"
In reply to: Nijntje: "Re: How to move Tablespace / Database ??"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US