| seema |
Posted: Sep 13, 2008 12:43:22 AM |
Total Post: 70
Joined: Jan, 2008
|
In Oracle we have three option -:
Alter system
Alter database
Alter session
Now i just want to know that at what time we will use which alter command is there any specific time ...??? |
|
|
 http://shaharear.blogspot.com |
| Posted: Sep 14, 2008 02:18:55 AM |  |
|
Total Post: 135
Joined: Apr, 2008
|
Use the ALTER DATABASE statement to Modifies a database, or the files and filegroups associated with the database.
Use the ALTER SYSTEM statement to dynamically alter your Oracle Database instance. The settings stay in effect as long as the database is mounted.
Use the ALTER SESSION statement to Modifies session
|
|
|
|
|
| Gajendra |
| Posted: Sep 17, 2008 02:10:32 AM | |
|
Total Post: 18
Joined: Aug, 2008
|
ALTER SESSION
Changes the functional characteristics
of current database session.
ALTER SYSTEM
Makes dynamic changes to the database instance.
ALTER DATABASE
Changes one or more characteristics
of an existing database SQL Statements
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
