Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alter database VS Alter system

Adeel AhmedJul 23 2009 — edited Jul 23 2009
I want to know what is the difference between ALTER DATABASE & ALTER SYSTEM

google says..
alter database commands cannot be audited; where as alter system can
alter database needs bouncing database but alter system doesn't

but ALTER DATABASE BACKUP CONTROL FILE TO TRACE; doesn't require bouncing.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2009
Added on Jul 23 2009
#database, #general-database-discussions
3 comments
4,090 views