Re: Enable 32K Block in 8K Block DB

"Charles" <cdavis10717_at_comcast.net> wrote in message news:83dbb3cd.0403281556.43addf38_at_posting.google.com...
> All,
>
> How do I enable a 32K block size in a database that was created with
> 8K block originally under Oracle 8.1.7.4.0?
>
> I want to have different block sizes for tablespaces in this database,
> which is now Oracle 9.2.0.4.0 on AIX.
>
> I'm thinking of doing these steps.
>
> 1. Backup Controlfile to trace. Shutdown.
> 2. Alter init.ora to specify 32k block size.
> 3. Add init.ora parmeters for 8k cache size.
> 4. Startup Oracle and recreate/reuse the database with the backup
> controlfile to trace.
>
> Too simple?
>
> What are the real steps to follow?
>
> Many thanks.
>
> Charles

Charles,

Do you want to change the default block size for the database? If so, why?

Why not just enable the use of 32K block size while retaining the default block size of 8K? This is the most simple way.

If you want to enable the use of 32K block size, try the following (or use a larger size than 4M if you so desire):
ALTER SYSTEM SET db_32k_cache_size=4M;
This can be done while the server is running. Then you can start creating 32K block size tablespaces.

Douglas Hawthorne Received on Sun Mar 28 2004 - 18:24:40 CST