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

Thread: Very URGENT...

  1. 09-02-2002, 03:34 AM #1
    iyyappan
    iyyappan is offline Junior Member
    Join Date
    Jun 2002
    Posts
    88
    Hi,

    How to change temp tablespace autoextend on.

    My temp tablespace is right now autoextend off.

    TEMP 500 /u01/oracle/visdata/tmp1VISION.dbf

    Please tell me the correct syntax.

    Thanks in advance.
    Iyyappan.M
    Reply With Quote Reply With Quote
  2. 09-02-2002, 03:35 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    tahiti.oracle.com and search autoextend

    plz dont ask syntax provlems here coz you can find it easily from docs
    Reply With Quote Reply With Quote
  3. 09-02-2002, 05:21 AM #3
    asharsidd
    asharsidd is offline Junior Member
    Join Date
    Jun 2002
    Posts
    73

    Wink

    Pando is right..Anyway

    SQL>ALTER TABLESPACE temp
    DATAFILE 'TEMP 500 /u01/oracle/visdata/tmp1VISION.dbf'
    AUTOEXTEND ON NEXT 200M;

    You cannot succeed if you fear to face challenges.
    MAS
    BE(CS) , OCP 8/8i.


    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