| anil |
Posted: Apr 14, 2008 03:49:37 PM |
Total Post: 27
Joined: Dec, 2007
|
hi all there is any concept to use alter system or alter database
in which condition we user alter system and alter database
i am little bit confuse to altering those keyword.
my simple question is in which condition we use alter system and
which is alter database? |
|
|
 Mohammed Taj |
| Posted: Apr 15, 2008 12:59:53 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
There is three type of level.
1. DATABASE LEVEL
2. SYSTEM LEVEL
3. SESSION LEVEL
According to Level we use "alter COMMAND"
For instance
1. if need to take backup (hot) then we use database level
1. alter DATABASE begin backup;
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_1004.htm#SQLRF00802
2. if we need to set any init parameter for system level
alter SYSTEM set processes = xxx scope=spfile;
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2013.htm#SQLRF00902
3. if we need to set any init parameter for any session level.
alter SESSION set nls_date_format = 'dd-mm-yyyy hh24:mi:ss';
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2012.htm#SQLRF00901
|
|
|
|
|
| Murtuja |
| Posted: Apr 15, 2008 02:27:55 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
alter system commands make chnages in Instance.
alter database commands make chnages in Database.
|
|
|
|
|
| Amjad Ali |
| Posted: Apr 15, 2008 10:56:33 AM | |
|
Total Post: 13
Joined: Apr, 2008
|
Hi Friends....
This was the same question which I use to always think about... but after some experience I came to know that alter database command is maximum or is use only when we want to make changes in the physical structure of the Database, and it is recorded in the control file.....
Md. Taj and Murtuja dear if you can drop a few lines on it... I wanted to confirm this.......
Thanks and Regards...
|
|
|
|
|
| Mohammed Taj |
| Posted: Apr 15, 2008 11:11:28 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
If we understand in simple way...
1. session, system or database
if we want to make any change only at session level use session
if we want to make any change for system level use system which also apply for session level
if we want to make any change for database level use database which also apply for system and session level.
|
|
|
|
|
| Murtuja |
| Posted: Apr 16, 2008 04:06:15 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Amjad,
Your understanding about theses commands "alter system or database" are correct.
If you have still any question then please post here.we will try to answer it best.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
