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

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

Absolutely correct - and to re-iterate what is implied in Jonathon's e-mail, the temporary tablespaces in the standby MUST be of type temporary - i.e create TEMPORARY tablespace temp ... , not create tablespace temp ... (which is NOT a temporary tablespace).

To make it easier to clone your production etc, you should also consider using true temporary tablespaces on the production site as well.

If you are still getting ORA 600 errors and core files after checking this, then you should call support and get the problem logged

--
Regards,

Mark Townsend                         

Senior Product Manager				Ph: 	(650) 633 5764
Server Division					Fx: 	(650) 506 7222
Oracle Corporation				Email:	mtownsen_at_us.oracle.com