alter database

• Fishbarnriots

  SSCrazy

  Points: 2568

  More actions

  November 17, 2006 at 7:05 am

  #62675

  Quick question, when using alter database and to modify file size, it is a good idea to place the database into single user mode or can this be done when the database in in use?

  Also, how much of a hit does a server take when the files automatically grow?

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  November 17, 2006 at 7:54 am

  #672601

  You do not need to set it to single user mode.