Re: HELP !!! Can not even connect me...

Mathias Wiedmer <mathiaswiedmer_at_yahoo.com> wrote in message news:<3D08E3DD.6030201_at_yahoo.com>...
> If there is any possibility to drop the fault TS, whithout connecting, I
> would be fine. The problem are all the other tablespaces, which I need.
> Just to delete the datafile is properbly not enough?!

1. Start SVRMGRL (in 9i SQLPLUS / nolog)
2. connect internal (in 9i connect / as sysdba)
3. startup mount;
4. alter database datafile '\doomed\nobackup\stupid_dba\blah.dbf' offline drop;
5. alter database open;
6. drop tablespace BLAH;

That's all. You will lose *ALL* objects stored in the fault tablespace, but living without backup is not for weak.

Note: substitute BLAH for your sorry tablespace and \doomed\nobackup\stupid_dba\blah.dbf for your datafile.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.