SIntax

[newcomer]

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

[marist89]

You don't have to backup your temp tablespaces.

[newcomer]

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

[pando]

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

[vendechukp]

pando is right .