Topic: Database Administration >> ALTER SYSTEM vs. ALTER DATABASE
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: ALTER SYSTEM vs. ALTER DATABASE |
| Burton |
Posted: May 10, 2007 10:23:34 AM |
Total Post: 53
Joined: Dec, 2006
|
Friends:
Is there a general rule to remember, to decide when we use ALTER SYSTEM, and when we use ALTER DATABASE?
I am reading up on Control Files, and thought that to change a control file we would use Alter System but no, I was wrong.
I was hoping there might be a rule for us to know when deciding which command to use?
B |
|
|
 Ratnaker |
| Posted: May 11, 2007 06:00:37 AM |  |
|
Total Post: 140
Joined: Apr, 2007
|
Hi Burton,
ALTER SESSION :
Use the ALTER SESSION statement to set or modify any of the conditions or parameters that affect your connection to the database. The statement stays in effect until you disconnect from the database.
ALTER SYSTEM :
Use the ALTER SYSTEM statement to dynamically alter your Oracle Database instance. The settings stay in effect as long as the database is mounted.
ALTER DATABASE :
Use the ALTER DATABASE statement to modify, maintain, or recover an existing database.
Ratnaker
|
|
|
|
|
| Burton |
| Posted: May 11, 2007 07:51:51 AM | |
|
Total Post: 53
Joined: Dec, 2006
|
thanks, that is helpful.
B
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 843 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 272 |
| neeraj sharma | 252 |
| Ramesh Jois | 245 |
| Bishal Khetan | 207 |
|
|
