Home » RDBMS Server » Server Utilities » Move data
Move data [message #71382] Thu, 24 October 2002 12:34 Go to next message
sonia
Messages: 22
Registered: March 2001
Junior Member
What steps do I need to take to move data from one drive to another? We are running Oracle 8.0.5 on NT.

Report message to a moderator

Re: Move data [message #71386 is a reply to message #71382] Fri, 25 October 2002 02:23 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
Can U stop Ur database ???

if Yes:

DO A COLDBACKUP FIRST !!!!

Shutdown the database.
Mount Ur database ( NOT OPEN )
copy Ur file on the new HD
use
alter database rename 'OLD_FULL_PATHFILE' to 'NEW_FULL_PATHFILE'
open Ur database

AND A FULL BACKUP AGAIN !

if answer is NO ... tell me and I'll explain U

Report message to a moderator

Re: Move data [message #71390 is a reply to message #71382] Fri, 25 October 2002 08:45 Go to previous messageGo to next message
sonia
Messages: 22
Registered: March 2001
Junior Member
I can't stop my database. How can I move the logs?

Thanks for your help.

Report message to a moderator

Re: Move data [message #71400 is a reply to message #71382] Mon, 28 October 2002 02:41 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
U want to move the REDO LOG ???

Best way is to create some others group at the correct location then drop the wrong...

Report message to a moderator

Previous Topic: Export Import affecting sequence triggers.
Next Topic: Problem with Group by
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 06:02:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.