How to move a table to another tablespace using dbms_redefinition?
Hi experts.
Due to the analysis of the awr made by the free tool of Burleson, I need to move some tables to another tablespace using dbms_redefinition. How to do it?
You have 73,203 table fetch continued row actions during this period. Migrated/chained rows always cause double the I/O for a row fetch and "table fetch continued row" (chained row fetch) happens when we fetch BLOB/CLOB columns (if the avg_row_len > db_block_size), when we have tables with > 255 columns, and when PCTFREE is too small. You may need to reorganize the affected tables with the dbms_redefintion utility and re-set your PCTFREE parameters to prevent future row chaining.
Due to the analysis of the awr made by the free tool of Burleson, I need to move some tables to another tablespace using dbms_redefinition. How to do it?
You have 73,203 table fetch continued row actions during this period. Migrated/chained rows always cause double the I/O for a row fetch and "table fetch continued row" (chained row fetch) happens when we fetch BLOB/CLOB columns (if the avg_row_len > db_block_size), when we have tables with > 255 columns, and when PCTFREE is too small. You may need to reorganize the affected tables with the dbms_redefintion utility and re-set your PCTFREE parameters to prevent future row chaining.
0