Re: alter database or alter system?

"Sajnish Gupta" <sajnish_gupta_at_yahoo.com> wrote in message news:3c02c8c7$0$26900$4c41069e_at_reader1.ash.ops.us.uu.net...
> Is there a general rule, when to use the alter database command or when to
> use alter system command?
>
> Thanks for your help.
> Sajnish
>
>
>

There is none, other than to read the documentation to see whether alter database or alter system applies. Generally speaking alter database alters the database = modifies it's structure and alter system modifies system wide parameters kills sessions etc etc.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address