Re: changing db block sizes in Oracle 7.2.3
From: Steve Phelan <stevep_at_XXnospamXX.toneline.demon.co.uk>
Date: 1998/03/03
Message-ID: <888918715.26892.0.nnrp-07.c2de712e_at_news.demon.co.uk>#1/1
Date: 1998/03/03
Message-ID: <888918715.26892.0.nnrp-07.c2de712e_at_news.demon.co.uk>#1/1
rklainer_at_neo.lrun.com wrote in message <6dfp7e$r9k$1_at_nnrp1.dejanews.com>...
>My assumption is that I need to recreate the database to change the block
size
Correct.
>I can't save the dictionary data with all my userids and the passwds and
all
>the synonyms and other things I have setup. If there is a better way let me
>know thanks Please email rklainer_at_neo.lrun.com
Perform a 'full export'. Once you've recreated the db with the new block size, do a 'full import'.
Steve Phelan. Received on Tue Mar 03 1998 - 00:00:00 CET