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

Thread: Autoextend

  1. 02-14-2003, 05:59 PM #1
    brado
    brado is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 02-14-2003, 06:34 PM #2
    Turin's Avatar
    Turin
    Turin is offline Junior DBA
    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 06:38 PM.
    Reply With Quote Reply With Quote
  3. 02-15-2003, 08:12 PM #3
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  4. 02-17-2003, 01:49 PM #4
    brado
    brado is offline Junior Member
    Join Date
    Sep 2002
    Posts
    29
    Thanks for the help.
    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