| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: alter database or alter system?
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 - 15:25:26 CST
 |
 |