Re: Difference between alter system and alter database?

From: Yong Huang <yong321_at_yahoo.com>
Date: 11 Jun 2003 10:19:13 -0700
Message-ID: <b3cb12d6.0306110919.16e1efe7@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?

The difference is the same as that between an instance and a database. An instance is the running background processes plus the memory used by oracle. The database consists of the files: datafiles, controlfiles and redolog files. Hope that helps you remember the commands.

Yong Huang Received on Wed Jun 11 2003 - 12:19:13 CDT