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

Thread: ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

Threaded View

  1. 03-05-2003, 10:38 AM #1
    abcd
    abcd is offline Junior Member
    Join Date
    Aug 2001
    Posts
    27

    ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

    Hi,,,
    Oracle DBMS: 9i R2
    O.S.: HP-UX 11i

    I was upgrade Oracle from 8.1.7 to 9.2.0.1,,,
    and finished from migrate data from old to new database,,,
    but I found the performance is slow,,,
    when I searched about any problem I found the the TEMP tablespace is full, I try to enlarge the space but it was still full, I try to make it offline but I can't, the error message was appear:
    ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

    I try to create another new TEMP tablespace but it also full,,,

    What I do to solve this problem?
    Last edited by abcd; 03-05-2003 at 10:44 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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