alter tablespace temp begin backup;

Dear all,

Can't we copy the temp tablespace data file as a hotbackup mode?

SQL> alter tablespace temp begin backup;
alter tablespace temp begin backup
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE


SQL>

I belive, it was working in oracle8i. Please help me why this is not working..

you dont backup temp

Thanks Dav.

how about undo or rollback tablespaces? do we need to back it up too?
TEMP and UNDO are the two TS with large runaway size allocation in our
database.

UNDO/ROLLBACK definitely yes.

oh my...do we need to shrink the undo to make the file smaller to backup?

eh? just backup whatever you have