Re: Rebuild db - chg 2k to 4k?

From: <darryl.snedeker_at_fmr.com>
Date: 1996/12/06
Message-ID: <32a827db.6660171@news-srv2.fmr.com>#1/1

You're on track Barb.

Suggestions:
!) Perform a full database backup

        (Hot or Cold - Must be a good backup)

2) Export full database, ensure no errors are reported.
3)  Backup export file (ensure it is a good copy)
4)  Produce a 'Create database' script by:
	alter database backup controlfile to trace;
 	modifiy the trace file create in the udump directory to 
	   include the 'create database' syntax
5) modify your init.ora file and specify DB_BLOCK_SIZE=4096

6) Run script
7) Import the full export file.

This is a rough plan and I am encouraging to review all details applicable to your endeavor and most importantly....Test before implementing and be certain you can go back if necessary !!!

Good Luck,

-D

On Fri, 6 Dec 1996 07:45:07, BEH_at_csd.uwm.edu (Barbara Hiles) wrote:

>Can someone tell me if I can do this - either the way I'm thinking I can or
>some other way?
>
>Our db was initially set up with 2k blocks (because no one knew any better and
>we took the defaults).
>Now, from everything I see/hear, I think we should be using 4k blocks and
>would like to change.
>Can I export, rebuild with 4k blocks and import? Or does the export maintain
>the block size?
>
>Thanks - Barb.

################################################################

Email: darryl.snedeker_at_fmr.com

Disclaimer: The opinions expressed herein are my own and in

             no way reflects the same of my employer.
             All recommendations and advice must be verified
             to be accurate by the recipient before implementation.

Quote Du' Jour: Thinking up some cute saying to entertain the masses.

#############################################################################

Received on Fri Dec 06 1996 - 00:00:00 CST