Database Administration (MOSC)

MOSC Banner

move table with subpartition to 32k block size tablespace

edited Mar 20, 2015 10:02AM in Database Administration (MOSC) 1 commentAnswered

ALTER TABLE <TABLE NAME to be moved> MOVE TABLESPACE <destination TABLESPACE NAME>;  activity executed perfectly

but

Few tables with sub-partitions move to new 32K tablespace has failed due to block size dependency 

can you share your inputs on this ?

 

  1. Sr. No.

Activity

Duration

Oracle Downtime Required

Remarks

1

Large database block size

30 Min

Yes

  1. Downtime required to add new parameter

SQL> alter system set db_32k_cache_size=5G ;

Restart the database.

  1. New tablespace will create with the block size 32K by below command :-

       SQL> create tablespace DWH_LST_Data datafile     

'/ora/db003/data002/BRT1DS1/ DWH_LST_Data01_1.dbf' size

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center