My Oracle server consists of 2 hard disks of 6.5 GB each. On harddisk one the oracle server (plus tablespaces) is loaded, whereas on harddisk 2 only Data and Index tablespace is allocated. My problem is that my first harddisk is almost full (only 34 MB remaining) and because of which I believe that the overall ERP software has become very slow. What do I do in this case? Right now i cant afford to go in for a new high capacity server....
well originally the whole server plus all the tablespace were on Hard disk 1 only. When there was a need to add datafiles these data files were configured on Hard disk 2 due to space constraints. I have about 5 GB free space on harddisk 2....No there are no non sys/system objects in system tablespace
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.