Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: Temp tablespace in Oracle 9i

    Hi all,
    I am getting an error when issuing the following statement in Oracle 9i :


    SQL> alter tablespace temp begin backup;
    alter tablespace temp begin backup
    *
    ERROR at line 1:
    ORA-03217: invalid option for alter of TEMPORARY TABLESPACE



    How does one make put the "temp" tablespace into backup mode, to start s hot backup. Any help is greatly appreciated in advance.

    Mehran

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You don't do hotbackup of a temporary tablespace V9.2 Oracle

  3. #3
    Join Date
    Mar 2004
    Posts
    3
    Originally posted by anacedent
    You don't do hotbackup of a temporary tablespace V9.2 Oracle

    Are you saying that we do not need to backup temp tablespace in Oracle 9i
    Or
    There is not method of taking a hot backup of temp tablespace

    Thanks,
    Mehran

  4. #4
    Join Date
    Mar 2004
    Posts
    3

    Temp tablespace in Oracle 9i

    Originally posted by mehranm
    Are you saying that we do not need to backup temp tablespace in Oracle 9i
    Or
    There is not method of taking a hot backup of temp tablespace

    Thanks,
    Mehran

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Are you saying that we do not need to backup temp tablespace in Oracle 9i

    >There is not method of taking a hot backup of temp tablespace

    Both the statements above are true.
    All the information within a temporary tablespace is transitory
    and cen be (re)created from permanent objects within the DB.

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    I am more curious to know why you even bother with that statement when this statement covers it all:

    PHP Code:
    backup database plus archivelog
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •