Hi Davey, yeah I have check all other parameters and sure that its due to hard disk space problem. I want to transfer the datafiles on the 2nd hard disk....can u guide me how to do it....or just tell me if the following steps are correct:
Steps to transfer datafile on the second hard disk:
(1) Shut down the oracle database useing SvrMgr
(2) Shift the data file from one harddisk to another
(3) Re-configure the path of the datafile in the tablespace and start the database again.

Thanks
Sfdba