| Oracle parameters [message #58661] |
Wed, 24 September 2003 11:32  |
maleev
Messages: 7
Registered: July 2002
|
Junior Member |
|
|
Hi,
where can I find a list of init parameters which CANNOT be modified after database creation?
Regards,
Anton
|
|
|
|
| Re: Oracle parameters [message #58663 is a reply to message #58661] |
Wed, 24 September 2003 12:47  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Except for DB_BLOCK_SIZE , everything else is modifiable for a given database, after database creation.
DB_NAME can be modified after renaming the database. DB_BLOCK_SIZE can be modified after recreating the database(new one).
Thiru
|
|
|
|
| Re: Oracle parameters [message #58664 is a reply to message #58663] |
Wed, 24 September 2003 12:55 |
maleev
Messages: 7
Registered: July 2002
|
Junior Member |
|
|
Thanx for your post ;)
Hm this means that I have to be extremely careful only with DB_BLOCK_SIZE. Every other parameter could be modified either with alter system or in the init.ora (in which case shutdown->startup)...
Regards,
Anton
|
|
|
|
| Re: Oracle parameters [message #58665 is a reply to message #58664] |
Wed, 24 September 2003 13:08 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Anton,
you have to be careful with EVERY parameter ;)
Actually,if you attempt to change DB_BLOCK_SIZE, Oracle wont permit it . see below :
SQL> alter system set db_block_size=8192 scope=spfile;
alter system set db_block_size=8192 scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-32016: parameter "db_block_size" cannot be updated in SPFILE
Also DB_NAME cannot be modified in this fashion or changing init.ora , until you rename the database. See Mahesh's post earlier about renaming the database.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
