Re: Recreate database with different block size

As the others have pointed out, an import will work - but for plan B you could:

Upgrade to Oracle 9.
Add tablespaces of the required, but different, block size.
Move all your objects from the old tablespaces to the new tablespaces (using NOLOGGING). Drop the empty, old, tablespaces.

Leaving only the TEMP, and system tablespaces at the original size. (Drop the old rollback t/s, and create a new one at a different size if you fancy).

Alternatively:
Create a new empty 9 database in the new block size.
Use transportable tablespaces to transport the old tablespaces to the new database.
Add new tablespaces that match the new database block size.
Proceed as above - moving objects from old tablespaces to new tablespaces.
Drop the old transported tablespaces.

NB - both options would work - but I don't think I would advise it seriously at present.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Stephen B wrote in message ...


>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

>

>