Author's note : Thank you all for your supporting letters. You have been a motivation to this web spot's posting. I wish you all the
very best for you and your families for the new year.
Interested to know about a next post? You can suscribe to my RSS feed HOW TO:
If you want a newer, fresher and quicker method to move a datafile from one disk to another here is the way to do it : Make sure the tablespaces are read-only and then
alter tablespace users offline;
copy c:\mydb\users01.dbf e:\mydb\users01.dbf
alter database rename file 'c:\mydb\users01.dbf' to 'e:\mydb\users01.dbf';
alter tablespace users online;
then make your tablespaces read write again, and you're done :-)
I had a test server with 60Gb Hard disk drive. Database was updated thoroughly and space run out quickly. What i did was to install a second hard disk drive and create there another folder to store my moved datafile. So in order to move c:\mydb\users.dbf to e:\mydb\users.dbf here are the steps to do it safely :
open sql worksheet and connect to the database as sysdba with the sys account,
make sure that all users are out of the database and that no pending transactions are taking place, then run
shutdown immediate;
execute
start mount;
copy-paste the datafile you wish to move, to the new location,
execute
ALTER DATABASE RENAME FILE 'C:\MYDB\USERS.DBF' TO 'E:\MYDB\USERS.DBF';
Name: John Galanopoulos Home: The NeverLands About Me: A source code wonderer since the early 80s with my first ZX81 by Sinclair, home computer. See my complete profile
Author's note : Thank you all for your supporting letters. You have been a motivation to this web spot's posting. I wish you all the
very best for you and your families for the new year.
