Move tablespaces to 8k size

[loriek]

We've got a number of 2k tablespace we want to move to the 8k size. Actually, it's all of them. Export / Import is an option if it will work quickly, but traditional imports take 12 hours...

 

[SantaMufasa]

Loriek,

By far, the fastest method to transform your 2K-block objects to 8K-block objects is to use the Oracle "MOVE" clause for tables and the "REBUILD" clause for indexes:

alter table <table_name> move tablespace <8K- tablespace name>;
alter index <index_name> rebuild tablespace <8K-tablespace name>;

You will be amazed at how fast this rebuilding occurs...many times faster than export/import.

Warning: If your table contains large objects (e.g. CLOBS or BLOBS) you cannot use the MOVE clause.

Let us know your findings.



Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”