Re: Recreate database with different block size

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 26 Sep 2001 18:20:56 +0200
Message-ID: <tr40gt1phra84a@news.demon.nl>

"Stephen B" <stephen.bell_at_cgi.ca> wrote in message news:HBjs7.24941$GQ2.2361520_at_news20.bellglobal.com...
> Hi all,
>
> To change the block size..if I create an identical database with the new
> block size (8K vs 2K) will I be able to import the data from the original?
> My feeling is that I can't ...hopefully someone can confirm or refute that
> assumption.
>
> Any thoughts appreciated,
>
> Steve
>
>

Your assumption is incorrect. You can import in a database with different blocksize without problem. After all, an import is treated as a series of insert statements.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Wed Sep 26 2001 - 11:20:56 CDT