Re: Standby Oracle 8i server as report server - Error!

I haven't had this problem, but that might be a fluke. You can write to temporary tablespaces, you can even add data files to temporary tablespaces in the standby.

Strategy:

create temporary tablespace temp_proper tempfile '........' etc.

If the 'live' temp does not need to be as large as the 'standby/report' temp you can:

    alter tablespace temp_proper add tempfile '......' etc.

after starting up the standby in read only mode.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

W J Parsons wrote in message <3862380B.D2E046D8_at_leeds.ac.uk>...
>Hi Alexander,
>If I remember correctly, the feature that lets you open the Standby
>database "Read Only" really DOES mean read only. This is fine for small
>queries that can be processed in memory, but larger queries (with sorts
>or joins) will normally have to write to the TEMP tablespace while they
>are running.
>This could well be the cause of your problem.
>
>The only thing I could suggest is re-tuneing the instance so that you
>can process much lager sorts in memory before using the temp tablespace.
>(I think the SORT_AREA_... parameters would be a good place to start)
>
>Hope this helps
>
>Will Parsons
>
>
>"Alex Andr." wrote:
>>
>> Hello!
>> I try to use my standby Oracle 8i on SCO UnixWare 7 as report server
>> and open it in "Read only" mode. Short queries work good but complex
>> queries end with core file and internal Oracle error.
>> Someone try to do this? It work?
>>
>> Thank you for any replay.
>> Alexander.
>
>--
>
>
>ISS UNIX support
>The University Of Leeds.
>0113 233 5670
Received on Thu Dec 23 1999 - 09:49:14 CST