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?
[Edited by Sameer on 08-19-2002 at 04:59 AM]
You don't need to take a backup of a temporary tablespace.