OraFAQ Forum: Server Administration » Diff between ALTER SYSTEM and ALTER DATABASE command

Home » RDBMS Server » Server Administration » Diff between ALTER SYSTEM and ALTER DATABASE command

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Diff between ALTER SYSTEM and ALTER DATABASE command [message #35282]

Thu, 03 February 2005 20:07

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:19:23 CDT 2024