Oracle Database Discussions

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!

temp tablespace after restore

138002Mar 9 2009 — edited Mar 9 2009

Hi,
I restored a database from production into Dev, both are running on 10gR2 in Unix. After the restore, I dont see the temp tablespace when I query v$tempfile or dba_temp_files. But when I query dba_tablespaces I see temp tablespace. Can someone tell me why?
Thanks

This post has been answered by OrionNet on Mar 9 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2009

Added on Mar 9 2009

#general-database-discussions

9 comments

3,960 views