If you are using a tempfile for tempoary tablespace on the primary, then you don't need this at all on the standby (whilst its recovering)
hth connor --- Hussain Ahmed Qadri <[EMAIL PROTECTED]> wrote: > > 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 > [EMAIL PROTECTED] > www.shaukatkhanum.org.pk > > > ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).