-
Hi,
Like
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.
Thanks
Vis
Nwcomer
Student
-
You don't have to backup your temp tablespaces.
Jeff Hunter
-
Hi Jeff
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?
Regards
Vis
Nwcomer
Student
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|