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

Thread: Temporary Tablesapce

  1. #1
    Join Date
    Jan 2004
    Posts
    25

    Temporary Tablesapce

    Hi folks,

    The following error i got while i created a temporary tablespace.

    CREATE TEMPORARY TABLESPACE TEMP
    DATAFILE 'D:\ERP\TEMP.DBF' SIZE 1000M REUSE AUTOEXTEND ON
    DEFAULT STORAGE ( INITIAL 100K
    NEXT 100K
    MAXEXTENTS UNLIMITED
    PCTINCREASE 0) ;

    I got the error:
    ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE.

    Can anyone point out whats wrong in this.

    Thanx.

  2. #2
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    It should be TEMPFILE not DATAFILE. Your syntax is for locally managed temporary tablespace hence use extent management local uniform size 100K.

    CREATE TEMPORARY TABLESPACE TEMP
    TEMPFILE 'D:\ERP\TEMP.DBF' SIZE 1000M REUSE AUTOEXTEND ON
    EXTENT MANGEMENT LOCAL UNIFORM SIZE 100K;
    Last edited by kris109; 01-30-2004 at 01:06 AM.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  3. #3
    Join Date
    Jan 2004
    Posts
    25
    I am getting the same error msg,, even if i changed as u said.

  4. #4
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    What is your database version?

    SQL> CREATE TEMPORARY TABLESPACE TEMP12
    TEMPFILE 'C:\oracle\oradata\junk\TEMP12.DBF' SIZE 10M REUSE
    AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 100K

    Tablespace created.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  5. #5
    Join Date
    Aug 2002
    Posts
    115
    TRY

    CREATE TABLESPACE TEMP
    DATAFILE 'D:\ERP\TEMP.DBF' SIZE 1000M REUSE AUTOEXTEND ON
    DEFAULT STORAGE ( INITIAL 100K
    NEXT 100K
    MAXEXTENTS UNLIMITED
    PCTINCREASE 0) TEMPORARY ;

  6. #6
    Join Date
    Jan 2004
    Posts
    25
    Thanx Kris.

    I created based on ur query and created successfully.

    DB- Production 9.2
    OS - Win2k.

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