Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

(Re)Creating TEMP after DUPLICATE

240948Sep 18 2006 — edited Oct 26 2006

When I finished a DUPLICATE session last night, I was prepared to add files to the TEMP tablespace. My understanding was that RMAN creates the TEMP tablespace, and I just need to add files to it. However I found that I needed to create a new TEMP2 tablespace and drop the old TEMP. Until I did this, Oracle complained that one of the original TEMP tempfiles was corrupt.

Does anyone have any precise explanation of exactly what happens and what is supposed to be done as part of the DUPLICATE process?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 23 2006

Added on Sep 18 2006

#performance-availability, #recovery-manager-rman

6 comments

2,420 views