Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot Add Temp Tablespace to Standby Database
Have you added the tablespace to your master database?
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Steven" <steven.pannell_at_gmx.net> wrote in message news:afs9i6$gn7kd$1_at_ID-82797.news.dfncis.de...Received on Tue Jul 02 2002 - 09:17:53 CDT
> 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.
>
>
>