Home » RDBMS Server » Server Administration » moving of datafiles.
moving of datafiles. [message #369437] Thu, 21 September 2000 13:26 Go to next message
Raghavendra M.K.
Messages: 10
Registered: September 2000
Junior Member
Hi ,

How can i move the datafiles to different directory ?

Thanks in advance
Raghavendra

Report message to a moderator

Re: moving of datafiles. [message #369440 is a reply to message #369437] Thu, 21 September 2000 16:00 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,
You have to take the corresponding tablespace offline.
And use operating system command to move the data files to different directories.
And then issue alter tablespace rename datafile
command to give the new path for the datafile.

Report message to a moderator

Previous Topic: command buffer space exhausted
Next Topic: how do I....?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 03 02:44:52 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.