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

In <bl9a5b$ks4$1_at_reader2.panix.com> Stan Brown <stanb_at_panix.com> writes:

>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?

oOK, I finally figure out the syntax for the end backup statement, but it did not work:

alter database datafile '/oracle_home/oradata/pwhse/system01.dbf' end backup
*

ORA-01235: END BACKUP failed for 1 file(s) and succeeded for 0
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/oracle_home/oradata/pwhse/system01.dbf'
ORA-01208: data file is an old version - not accessing current version

What is this yelling me?

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