Difference between alter database/alter system [message #55760] |
Fri, 14 February 2003 00:22 |
Hitesh Shenoy
Messages: 11 Registered: January 2002
|
Junior Member |
|
|
Hi All,
Please can someone tell me the difference between 'Alter System' and 'Alter Database' command and when should they be used.From what info I could gather 'Alter Database' is database related and 'Alter System' is for instance specific.
But then why do we use 'Alter System' to switch logfiles? We should be using 'Alter Database' cause Redolog files are database objects and not instance.
Please advise. Thanks in advance.
Regards
|
|
|
Re: Difference between alter database/alter system [message #55762 is a reply to message #55760] |
Fri, 14 February 2003 02:26 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
From the docs:
Use the ALTER DATABASE statement to modify, maintain, or recover an existing database.
Use the ALTER SYSTEM statement to dynamically alter your Oracle instance. The settings stay in effect as long as the database is mounted.
The SWITCH LOGFILE clause lets you explicitly force Oracle to begin writing to a new redo log file group, regardless of whether the files in the current redo log file group are full. When you force a log switch, Oracle begins to perform a checkpoint. Oracle returns control to you immediately rather than when the checkpoint is complete. To use this clause, your instance must have the database open.
MHE
|
|
|