Re: Standby database under 8i - 'create temp tablespace'?

>You can safely create temporary tablespaces provided that they consist of tempfiles and are locally managed.

Thanks, Vladimir. I'll try to find that section of the doc. I _am_ planning to use this as a read-only database for reporting most of the time, which is why I need the temp tablespace; the db will be manually recovered to catch up on redo a couple of times a day.

I will review the section you cite for more info on recreating that temp tablespace.

Cheers,

BD Received on Wed May 03 2006 - 13:26:46 CDT