DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SIntax

  1. #1
    Join Date
    May 2002
    Posts
    163
    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You don't have to backup your temp tablespaces.
    Jeff Hunter

  3. #3
    Join Date
    May 2002
    Posts
    163
    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

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  5. #5
    Join Date
    Apr 2002
    Posts
    55
    pando is right .
    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
  •  


Click Here to Expand Forum to Full Width