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

Thread: Autoextend

  1. #1
    Join Date
    Sep 2002
    Posts
    29

    Autoextend

    I've turned on the autoextend function for the datafiles in my database through the OEM. Do I need to restart the database for the change to take effect? I know this qustions is simplistic but please excuse a newbie.

  2. #2
    Join Date
    Sep 2001
    Location
    Mexico
    Posts
    93
    No, it is not necessary to shut down the DB. Oracle rulez!
    Just take care that :
    * You have enought space in your hard disk / filesystem to support the NEXT EXTENT parameter of your segments (tables, indexes, etc). If you are using Local managed tablespaces you should have enought space to support the increment of the datafiles according Oracle's formula.

    Regards.
    Last edited by Turin; 02-14-2003 at 05:38 PM.

  3. #3
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    If you are goin to use AUTOEXTEND, use a MAXSIZE on your datafiles as well.
    OCP 8i, 9i DBA
    Brisbane Australia

  4. #4
    Join Date
    Sep 2002
    Posts
    29
    Thanks for the help.

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