Re: Difference between alter system and alter database?

On 11 Jun 2003 09:36:28 -0700, rs_arwar_at_hotmail.com (Rauf Sarwar) wrote:

Yes, thanks. I ask this just because sometimes it is unclear why this is so. It is supposed to be obvious from their names but sometmes it is not that clear cut..

>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 - 12:18:04 CDT