Home » RDBMS Server » Server Administration » moving .dbf files....
moving .dbf files.... [message #56353] Mon, 24 March 2003 11:24 Go to next message
raman
Messages: 66
Registered: February 2000
Member
Hi

When I created a 9i database, mistakenly mentioned wrong path for .dbf files in tablespaces.

I have already imported the data from another database into this 9i database.

Now I would like to change the path to the correct one.

The following are some of the tablespaces in which the path was given wrong for the .dbf files:

SYSTEM
TEMP
TOOLS
UNDOTBS1
XDB

Can I do it?

thankyou,
-ramanujam

Report message to a moderator

Re: moving .dbf files.... [message #56354 is a reply to message #56353] Mon, 24 March 2003 13:25 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Nice article here.

http://www.jlcomp.demon.co.uk/faq/rename_datafile.html

Even I did not know that there were 2 ways to do it. I did it the 2nd method sometime back.

NOTE: after the move, backup the control files.

Report message to a moderator

Previous Topic: lost index files
Next Topic: IP address change.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:20:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.