Hi all,
We are running out of space on our server and I was going to add another hard disk to it. I had thought about somewhat crude but easy way to go about it. Since I can afford to shutdown my database for a couple of hours tomorrow, I thought that I would shutdown the database, move some datafiles to other partitions, redefine the partitions as to increase their size (WinNT 4 and Oracle 8i) and then move back the datafiles and then start the database. This way I would have more space to accommodate any increase in size of the datafiles and not worry about changing any of the database complexities (plus more space for the archives generated, as the database is in archive mode). Neither the control file nor any of the parameters would have to be changed as no change in location took place. Is there anything wrong in this method? What could be the other options, if any? Anything else that I need to keep in mind?
Thanks and regards,
Hussain Ahmed Qadri
DBA
SKMCH&RC
