How to move an Oracle database from one hard drive to another?
I haven't worked with Oracle extensively and not for quite some time. We have an Oracle Express database on the C drive of a server which is about full. While I was able to add a new tablespace on the E drive (which has lots of room), I'd like to move the entire existing database to that drive to free up space on C. Is there a way to do this other than doing a backup, deleting the existing database, recreating on the E drive and doing a restore? In any case, can you go into detail at to the steps involved, since (as I said) it's been a long time since I got down and dirty with Oracle)?
kenzo20472012-09-04T08:52:40Z
Favorite Answer
You can move an entire database (ie all data, log and control files) to a different location, but it is a bit tricky. I will email you the instructions directly. I have not done that for quite a while, so there may be errors. Is that Express 10g or 11g ?
You should still take a backup before attempting the steps in my note.
Then again, Express is limited to a small amount of data anyway (10GB in 11g, 5GB in 10g) so it may be just as fast to create new database and export/import the data (or backup/restore).
till now you do away with your demanding stress, backup your information right into a secure place exterior the demanding disk. positioned the demanding disk interior the recent workstation and start up off the workstation. it is going to instantaneous you with one in all those great variety of got here across driving force that want be put in. forget approximately approximately those it can't deploy and enable it boot thoroughly. Beging to reload each and all of the drivers applying the installation disk provided with the workstation. you'll be able to could boot the workstation in risk-free mode if the vedio driving force won't load at bootup. yet in any different case is to accomplish abode windows restore yet stay away from formatting the disk. Which ever way you go, you will could desire to reinstall the drivers.