Cannot Add Temp Tablespace to Standby Database

From: Steven <steven.pannell_at_gmx.net>
Date: Tue, 2 Jul 2002 15:24:25 +0200
Message-ID: <afs9i6$gn7kd$1@ID-82797.news.dfncis.de>

Hi,

I'm using Oracle 8.1.6 with solaris 2.7 and I am attempting to add a temp tablespace to my standby database as described in the oracle documentation. I use this command:

CREATE TEMPORARY TABLESPACE tbs_1 TEMPFILE 'file_1.f'

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M; However, I always get the error message:

ORA-00372: file 1 cannot be modified at this time ORA-01110: database file 1: 'system.tbs'

Well it makes sense somehow as the standby database is in read only mode. But in that case how can I add my temporary table??

Anyone know how to do this?

Thanks for any help,
Steve. Received on Tue Jul 02 2002 - 08:24:25 CDT