Oracle Database Express Edition (XE)

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 when dbf file is lost.

vuatabcDec 18 2006 — edited Dec 18 2006

I want to delete a tablespace but I accidentally deleted the physical file. Now the command drop tablespace fails complaining about not able to find the dbf file.

How can I drop it ( in order to re-create it ) ?

Thanks for your help ?

Vu

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 15 2007

Added on Dec 18 2006

2 comments

450 views