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

Thread: Turn auto Extend Off

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    Turn auto Extend Off

    Hi,

    I have a locally managed tablespace. It has three files all are auto extendable by system.

    Can I set the file to be non autoextendable.

    If yes HOW ?

    Regards
    Vijay
    --------------------------
    The Time has come ....

  2. #2
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    I am running Oracle 817 on Solaris 8
    --------------------------
    The Time has come ....

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Code:
    ALTER DATABASE DATAFILE 'filename' AUTOEXTEND OFF;
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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