drop tablespace (missing datafile)

[Pietro Abate]

HI,
how I could drop a tablespace of which I have missed the datafile ?

The problem arise because I couldn't mount correctly my db instance
because I've missed the datafile.

I hope someone could help me.

pietro

---------------------
the SVRMGR say:

SVRMGR> connect internal
Connected.
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> connect system
Password:
ORA-01033: ORACLE initialization or shutdown in progress
SVRMGR> drop tablespace prova;
drop tablespace prova
*
ORA-01109: database not open

--------------------

[Marc Mazerolle]

Have you tried :

connect internal
startup nomount
drop tablespace prova;
shutdown
startup

Regards,

Marc Mazerolle

[rspe...@my-deja.com]

try this:

svrmgrl
connect internal
startup nomount
alter database datafile '<full path / filename>' offline drop;
drop tablespace <tablespace_name>;
shutdown;
startup;

HTH,
Roy

In article <slrn7mvjf7...@mueller.students.cs.unibo.it>,

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

[R.Schierbeek]

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