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!

Drop tablespace that needs recovery?

SrdjanRasulicFeb 14 2007 — edited Feb 15 2007

- production 9.2.0.4 server

I canceled big import on my production database. SMON started it's job with big affect to performance.

I shuted down database, taking offline all datafiles in which I imported some data. After startup, SMON generated ORA-00376 every five minutes.

I have one undo segment marked as 'NEEDS RECOVERY'

What will happen if I just drop tablespaces which I don't want to be recovered?

Thanks
Srdjan

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2007

Added on Feb 14 2007

#general-database-discussions

8 comments

738 views