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

Thread: Alter system v/s Alter Database

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    what is the difference b/n

    Alter system
    and
    Alter Database commands


    Regards
    sonia


  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135

    ALTER DATABASE statement is generally used to modify, maintain and recover the database. The changes you made here are permanent.

    ALTER SYSTEM statement is used to dynamically change system parameters plus some additional maintenance work. Here, changes to system parameters will vanish once the db is rebooted.

    Most of the statements once used with "ALTER DATABASE" are now available in "ALTER SYSTEM" statement.


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