Hi,

I have a database running on 8.1.6 Enterprise Edition.
Database is in ARCHIVELOG mode.



When I try to backup TEMP tablespace using

ALTER TABLESPACE TEMP begin backup;

I get error:

ORA-03217: invalid option for alter of TEMPORARY TABLESPACE.

How do I backup temp tablespace?

I have used following sql to create TEMP tablespace --

CREATE TABLESPACE temp tempfile '/data/oradata/temp01.dbf' size 100M extent management local;


How do I tke online backup this tablespace?

Thanks

Sameer

[Edited by Sameer on 08-19-2002 at 04:59 AM]