move table with subpartition to 32k block size tablespace
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 ?
| Activity | Duration | Oracle Downtime Required | Remarks |
1 | Large database block size | 30 Min | Yes |
SQL> alter system set db_32k_cache_size=5G ; Restart the database.
SQL> create tablespace DWH_LST_Data datafile '/ora/db003/data002/BRT1DS1/ DWH_LST_Data01_1.dbf' size |