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).