Home » RDBMS Server » Server Administration » Diff between ALTER SYSTEM and ALTER DATABASE command
Diff between ALTER SYSTEM and ALTER DATABASE command [message #35282] Thu, 03 February 2005 20:07 Go to next message
Balaji. C
Messages: 1
Registered: February 2005
Junior Member
Hi,
I used to get confused with ALTER SYSTEM and ALTER DATABSE commands used in Oracle SQL.
Example:

For switching log file we use ALTER SYSTEM.
SQL>ALTER SYSTEM SWITCH LOGFILE;

For adding a Log file we use ALTER DATABASE
SQL>ALTER DATABASE ADD LOGFILE MEMBER 'filename' [[REUSE]] TO GROUP int;

Is there any way to remember easily where to use ALTER SYSTEM and ALTER DATABASE commands.
Why not Oracle will allow us to use ALTER SYSTEM wherever we use ALTER DATABASE and vice versa.

Regards,
Balaji. C

Report message to a moderator

Re: Diff between ALTER SYSTEM and ALTER DATABASE command [message #35287 is a reply to message #35282] Thu, 03 February 2005 22:01 Go to previous message
sri
Messages: 154
Registered: February 2000
Senior Member
Use the ALTER SYSTEM statement to dynamically alter your Oracle instance. The
settings stay in effect as long as the database is mounted.

Use the ALTER DATABASE statement to modify, maintain, or recover an existing
database.

Report message to a moderator

Previous Topic: Objects - created by package body
Next Topic: OracleTNSListerner80 is not starting
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 03:30:50 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.