Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
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)?
3 Answers
- kenzo2047Lv 69 years agoFavorite 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).
- 4 years ago
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.
