Help me! move database

smily · June 10th, 2004, 06:19 AM

Hello,

I want to move my database to another harddisk (from C to D).
How can I do that?

I have all ready shutdown the database en move the database folder but all the datafiles are directed to the my c disk.
How can i change that?

Thanks!:D

lionofthejungle · June 10th, 2004, 06:27 AM

hi Smily,

just change the control file to point to your datafiles at new location

Regards
the lion

smily · June 10th, 2004, 07:12 AM

Hey Lion,

Is it possible to give me a little more information?
I'm a beginner

Thanks

aas · June 27th, 2004, 08:18 AM

Quote:

quote:Originally posted by lionofthejungle
hi Smily,

just change the control file to point to your datafiles at new location

1. shutdown DB
2. move your .dbf files to new location
3. change the control file for moved DB (.ctl)
4. start DB

Best regards...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
readyState won't move from 1 to 2!	lmireskandari	Javascript	0	February 28th, 2007 11:50 AM
move database to another server	timbal25	Oracle	2	April 29th, 2004 08:51 AM
Move SQL TempDB Database	ritag	SQL Server 2000	2	March 31st, 2004 01:48 PM