Re: ORA-02142: missing or invalid ALTER TABLESPACE option

Hi All,

I am using RMAN tool and facing the following problem :

RMAN> sql 'alter tablespace SUBVENT01.dbf offline immediate';

sql statement: alter tablespace SUBVENT01.dbf offline immediate
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 11/09/2011 18:07:50
RMAN-11003: failure during parse/execution of SQL statement: alter tablespace SUBVENT01.dbf offline immediate
ORA-02142: missing or invalid ALTER TABLESPACE option

can you please suggest me how to overcome this issue. datafile name is SUBVENT01.dbf .

Thanksin advance

Santosh