Re: drop tablespace (missing datafile)

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: Tue, 22 Jun 1999 20:23:21 +0200
Message-ID: <7kok76$8ru$1@news.worldonline.nl>

How about:

SVRMGR> startup mount
SVRMGR> alter database datafile '/tmp/prova.dbs' offline drop ;
SVRMGR> Alter database open ;

Good luck !

---

Roelof Schierbeek, DBA
Bytelife BV
The Hague, Holland
email: bytelife AT worldonline.nl
check out : http://home.worldonline.nl/~bytelife

Pietro Abate heeft geschreven in bericht ... >HI,
> how I could drop a tablespace of which I have missed the datafile ?

...> ---------------------

> the SVRMGR say:
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 4754704 bytes
> Fixed Size 48400 bytes
> Variable Size 4222976 bytes
> Database mounted.
> ORA-01157: cannot identify data file 6 - file not found
> ORA-01110: data file 6: '/tmp/prova.dbs'
Received on Tue Jun 22 1999 - 13:23:21 CDT