problem with missing tablespaces

From: Pietro Abate <abate_at_students.cs.unibo.it>
Date: Mon, 21 Jun 1999 19:46:53 +0200
Message-ID: <Pine.LNX.4.10.9906211939030.10052-100000@caristudenti.students.cs.unibo.it>

HI,

        I have removed a dbs file and now I can't connect and use my default db... this dbs file belongs to a tablespace named 'prova'.

Now when I try to connect it say:
SVRMGR> connect system
Password:
ORA-01033: ORACLE initialization or shutdown in progress SVRMGR> how could I drop or alter this tablespace ? how could I change my default DB ?

TIA,
        pietro

---

SVRMGR> startup
ORACLE instance started.

Total System Global Area                          4754704 bytes
Fixed Size                                          48400 bytes
Variable Size                                     4222976 bytes
Database Buffers                                   409600 bytes
Redo Buffers                                        73728 bytes

Database mounted.
ORA-01157: cannot identify data file 6 - file not found ORA-01110: data file 6: '/tmp/prova.dbs' SVRMGR>
--

                     Rapresentante degli studenti
             in consiglio di laurea di Informatica e Scienze
                        dell'informazione,
             in consiglio di facolta di Scienze MM.FF.NN.

---

Undergraduate student of Computer Science - ALMA MATER STUDIORUM Bologna - Alias: coc0526_at_iperbole.bologna.it Received on Mon Jun 21 1999 - 12:46:53 CDT