Re: How to copy DB with larger DB_block_size to server.

Do I understand you correctly you want to change the db_block_size by recreating the control file?
Given the physical structure of the database (with header blocks in files, tablespaces, and tables), it would mean that all header blocks would have to be recreated, all extents would have to be rearranged, and so on. So this is evidently which is possible *only* by recreating the database, no other solutions, sorry.
So, you have to export, recreate the database after changing init.ora and import, that's the only solution.

Regards,

Sybrand Bakker, Oracle DBA

<yunhuiyang_at_my-deja.com> wrote in message news:8vcr30$k1p$1_at_nnrp1.deja.com...
> Hi, all:
>
> I'm looking for the solution for the following problem.
>
> 1. I have a server with 3 instances runing, all having DB_block_size=2k.
> 2. I want to copy a database with DB_block_size=8k to above server by
> recreating control file.
>
> Can I do it?
>
> I tried and failed. If I use DB_block_size=8k, the DB can't be created
> eventhough it can be create with 4k. I couldn't either use 2k or 4k to
> recreate the control files, since it's smaller than the orignal block
> size.
>
> Any way get out from here?
>
> Thank you
>
> Helen
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 21 2000 - 01:27:56 CST