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 a tablespace and datafile when database is mounted

662220Mar 19 2012 — edited Mar 19 2012

I tried to import data in my oracle 11g. It failed midway. I presumed that i did not size the redolog properly. Now my database cannot go beyound the mounted mode.

ORA-01157: cannot identify/lock data file 7 – see DBWR trace file
ORA-01110: data file 7: ‘ /data1/owprojects/xxxxx.dbf ‘

Its a new oracle installation and i do not need the corrupt datafile.

I cant take the tablespace offline neither can i drop the tablespace including its contents.

Do i drop from the Linux OS. If yes which other file to i edit to remove the pointer to this tablespace.

Thanks and Best Regards
J

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2012

Added on Mar 19 2012

#general-database-discussions

3 comments

5,968 views