Re: Control file blocksize mismatch

Peter <peter_at_nomorenewsspammin.ca> wrote:

>I changed the db_block_size in the init file and teh restarted the DB.
>
>Then I got this problem
>
>SQL> alter database mount;
>alter database mount
>*
>ERROR at line 1:
>ORA-00209: control file blocksize mismatch, check alert log for more
>info
>
>I know you cannot change block size, but is there any method around
>this situation?
>

Yes, re-edit your init file to use the correct value...Once created,the database block size if fixed... You could, of course, build a new database instance using the block size you want and then use exp/imp to move your data to the new db....

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Wed Apr 30 2003 - 15:12:12 CDT