Re: 2 questions, deleting a tablespace on a damaged instance and tablespace

In <bl99bk$kbg$1_at_reader2.panix.com> Stan Brown <stanb_at_panix.com> writes:

>In <duUdb.129017$bo1.58527_at_news-server.bigpond.net.au> "Richard Foote" <richard.foote_at_bigpond.com> writes:

>>"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
>>news:3f774ec9$0$32058$afc38c87_at_news.optusnet.com.au...
>>> Stan Brown wrote:
>>>
 

>OK, thnaks for the clarification. I wasn't having any luck with the
>original syntax.
 

>So, for the file I have already deleted physicaly (which maps one to one to
>a tablespace), then I should use something like "drop tablespcae
>'table_space_name'"? ? After doing a startup mount?
 

>Or would it be an alter databse command?
 

>The exact syntax would be _most_ helpful. The instnaces is 7.3.4.5

OK, I definatley need some syntax help here. I've tried the following:

SVRMGR> drop tablespace INDEX1_TS ;
drop tablespace INDEX1_TS
*
ORA-01109: database not open
SVRMGR> alter databse drop tablespace INDEX1_TS ; alter databse drop tablespace INDEX1_TS

      *
ORA-00940: invalid ALTER command

Both commands were entered into svrmgrl after a conect internal and a startup mount.

The tablespace in question is containd in this datafile:

         7 ONLINE  READ WRITE  108474696          0 8598323200
		 /db_local1/oradata/pwhse/indexes/index1.dbf
					 

What am I doing wrong here?

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin