Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> drop tablespace (missing datafile)

drop tablespace (missing datafile)

From: Pietro Abate <abate_at_students.cs.unibo.it>
Date: 22 Jun 1999 17:54:47 GMT
Message-ID: <slrn7mvjf7.fl6.abate@mueller.students.cs.unibo.it>


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
	 
	-------------------- 
Received on Tue Jun 22 1999 - 12:54:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US