ALTER TABLESPACE BEGIN BACKUP.
What is the syntax for TEMPORARY TABLESPACE while TEMPORARY TABLESPACE got created with TEMPFILE option;
The above syntax is not working.
You don't have to backup your temp tablespaces.
That is fine. Just to know about the syntax I raised this thread.
Suppose if I have created a Temp tablespace as
create tablespace temp datafile 'xxxxx' size 10M TEMPORARY;
And then if I try to take backup like
alter tablespace temp begin backup;
It works fine.
But while I create a temporary tablespace with TEMPFILE clause, what is the SYNTAX to take hot backup of that tablespace as above?
it wont let you, it's not a syntax problem
a temp tablespace is purely temporary, the data it contains does not mean anything, lose it does not mean anything
VenDe ChukPeen Zuri
Someone who quotes himself as a DBA and posts simple question in forums is a big idiot to me . I donot care what others think
Click Here to Expand Forum to Full Width