| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Standby Database-No space on Disk
Hello All
Oracle 8.1.7, WINNT4.
On our standby Database box, we have run out of space on the partition which
was holding the Temporary tablespace. Now the problem is that when ever I
try to start the recovery, it gives the message that there is no space on
the disk.
How would I add another datafile to the temporary tablespace? Database is a
standby databse with the controlfile for the standby database. Is there a
simple way to add a datafile to the tablespaces on a standby database. Or
should I shutdown the database, move the datafile to another partition,
repartition this old-temporary partition by adding more space to it. And
then copy that temporary-datafile back to this old partition and startup the
database for the Standby mode.
Would appreciate any prompt suggestions. Regards,
Hussain Ahmed Qadri
Database Administrator
Shaukat Khanum Memorial Cancer Hospital & Research Centre
hussain_at_skm.org.pk
www.shaukatkhanum.org.pk
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hussain Ahmed Qadri
INET: hussain_at_skm.org.pk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 24 2002 - 02:58:18 CDT
 |
 |