Quote Originally Posted by davey23uk
logical or physical standby?

well you can have temp tablespace in either, I do exactly what you want - a physical which is opened read only once a day for reporting purposes and we use temp
I am thinking about using physical standby if the end users
don't need access the stadnby all the time.