Re: Difference between alter system and alter database?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 11 Jun 2003 06:55:46 -0700
Message-ID: <2687bb95.0306110555.7f673172@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

Peter, See the SQL manual.

Alter database normally deals with information related to the physical files that make up the db: control, redo logs, and data base data files.

Alter system comands generally affect the instance and its operating parameters.

HTH -- Mark D Powell -- Received on Wed Jun 11 2003 - 08:55:46 CDT