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

Thanks all for replay. If I add temporary tablespace can I drop it before open Standby Database for production?

Jonathan Lewis wrote:

> 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 Tue Dec 28 1999 - 02:19:31 CST