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

Thread: creating temporary tablespace in oracle 7.2

  1. #1
    Join Date
    Jun 2003
    Posts
    24

    Question creating temporary tablespace in oracle 7.2

    I need some urgent help on creating of temporary tablespace in oracle
    7.2

    when i exec this statement
    CREATE TABLESPACE TEMP
    DATAFILE '/u03/oradata/F/TempF_01.dbf' SIZE 1950M
    DEFAULT STORAGE ( INITIAL 1000M NEXT 480M MINEXTENTS 1 MAXEXTENTS
    121 PCTINCREASE 0 )
    TEMPORARY;
    ---it says invalid create tablespace statement

    so I

    CREATE TABLESPACE TEMP
    DATAFILE '/u03/oradata/F/TempF_01.dbf' SIZE 1950M
    DEFAULT STORAGE ( INITIAL 1000M NEXT 480M MINEXTENTS 1 MAXEXTENTS
    121 PCTINCREASE 0 );
    ----without the temporary word and I am able to create

    when I want to alter

    alter tablespace temp temporary; ----it says invalid alter statement.

    can I know what i did wrong. Please help

    Regards,
    Cindy

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    If you really want help then you should give the exact error message that you got when you tried it. Also you should not create a 2gb tablespace with a default initial extent of 1gb. When you try this what happens. Oh and is there any reason why you don't upgrade to 9i SR2 or 10g?

    Code:
    DROP TABLESPACE temp INCLUDING CONTENTS;
    
    CREATE TABLESPACE TEMP
    DATAFILE '/u03/oradata/F/TempF_01.dbf' SIZE 1950M REUSE
    DEFAULT STORAGE ( INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS
    121 PCTINCREASE 0 ) TEMPORARY;

  3. #3
    Join Date
    Jun 2003
    Posts
    24
    hi,

    I am not able to do an upgrade as this is client db and they are not willing to perform an upgrade

    below is the error

    SQL> CREATE TABLESPACE TEMP
    D 2 ATAFILE '/u03/oradata/F/TempF_01.dbf' SIZE 1950M
    3 DEFAULT STORAGE ( INITIAL 1000M NEXT 480M MINEXTENTS 1 MAXEXTENTS 121 P
    CTINCREASE 0 )
    4 TEMPORARY;
    TEMPORARY
    *
    ERROR at line 4:
    ORA-02180: invalid option for CREATE TABLESPACE


    SQL> CREATE temporary TABLESPACE TEMP
    2 DATAFILE '/u03/oradata/F/TempF_01.dbf' SIZE 1950M
    3 DEFAULT STORAGE ( INITIAL 1000M NEXT 480M MINEXTENTS 1 MAXEXTENTS 121 P
    CTINCREASE 0 ) ;
    CREATE temporary TABLESPACE TEMP
    *
    ERROR at line 1:
    ORA-00901: invalid CREATE command

    SQL> alter tablespace TEMP temporary;
    alter tablespace TEMP temporary
    *
    ERROR at line 1:
    ORA-02142: missing or invalid ALTER TABLESPACE option

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    True temporary tablepsace with the tempfile option were not available in 7.2 thats why the error.

    You cannot use the temporary keyword in 7.2 at all.

    regards
    Hrishy

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