ORA-3217
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-3217

Hybrid View

  1. #1
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

    Question

    Hi,

    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?

    Thanks

    Sameer

    [Edited by Sameer on 08-19-2002 at 04:59 AM]

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You don't need to take a backup of a temporary tablespace.

    Regards
    Jim
    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!

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