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!

ora-01187

611515Jul 28 2010 — edited Jul 28 2010

Oracle 10.2.0.1.0 / OEL

When i tried to query dba_temp_files

it throws ora-01187 & ora-01150

normally we don't take backup of tempfiles.

now i can not drop temporary tablesapce and recreate it.

what is the corrective action?

This post has been answered by Girish Sharma on Jul 28 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2010

Added on Jul 28 2010

#general-database-discussions

7 comments

1,437 views