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.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Click Here to Expand Forum to Full Width