Re: Oracle Migration and db_block_size

Tejaswini wrote:

> The migration is manual , using 'startup migrate'. The block size on
> Oracle 8 is 8k and in Oracle 9i db_block_size can have values like 4k,
> 8k, 16k, 32k depending upon one parameter accepted from user. I am not
> using import and export utility. Is the error 'ORA-00209: control file
> blocksize mismatch' related to changing db_block_size during migration?
>
> Thanks,
> Tejaswini

If you are thinking of using different block sizes inside a single database ... check this group's archives and the many negative comments regarding that practice: Especially those from Howard Rogers.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)