Re: alter database or alter system?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 28 Nov 2001 09:48:37 +1100
Message-ID: <3c0417df$0$13481$afc38c87@news.optusnet.com.au>

And 'alter DATABASE backup controlfile to trace' causes what precisely to be written to database files???!

In general, I'd buy the distinction you make. I tend to thing "alter system" refers to memory/transient issues and "alter database" refers to controlfile/permanent issues. But there's always the odd exception.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Erwin Dondorp" <ng_at_dondorp.com> wrote in message
news:3C0404C6.7020602_at_dondorp.com...


> Sajnish Gupta wrote:

>

> > Is there a general rule, when to use the alter database command or when

to


> > use alter system command?

>

>

> There is a clear distinction:

>

> ALTER SYSTEM

> changes the INSTANCE, so only changes to the running processes.

>

> ALTER DATABASE

>

> changes the DATABASE, these changes are written to the database files.

>

>

> Erwin

>

Received on Tue Nov 27 2001 - 16:48:37 CST