Hello, my Question is:
Does ORacle move the table-segment database-block- ( due to higher performance ) or row-oriented like an normal INSERT-Stmt.
This question is important, because if MOVE works only database-block-oriented then Reorgansiation would not change the filling-grade of the Databaseblocks.
Then exp/imp shpuld be prefered.
Oracle move data of table row by row.
in ALTER TABLE MOVE statment u can use -->
full set of storage and block structure parameters (including INITIAL, PCTFREE, PCTUSED, MAXTRANS ...)
oracle can't change any of its without reorganisation db block.
Click Here to Expand Forum to Full Width