Re: Difference between alter system and alter database?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 11 Jun 2003 09:36:28 -0700
Message-ID: <92eeeff0.0306110836.569ba931@posting.google.com>

Peter <peter_at_nomorenewsspammin.ca> wrote in message news:<dj4kbv0d902to5qh0rd7inqri4tuauhgk1_at_4ax.com>...
> What is the difference between alter system and alter database?
> When do you use one over the other?
>
> Thanks

ALTER DATABASE:
Changes the operation of a database with respect to redo logs and data files. Backs up control files. Mounts, Dismounts, Opens, Closes a database. Performs media recovery.

ALTER SYSTEM:
Performs a specialized system function e.g. Kill session, Start/Stop archiving etc.

Regards
/Rauf Sarwar Received on Wed Jun 11 2003 - 11:36:28 CDT