Avg. Page Density Issue with Copy Objects

Avg. Page Density Issue with Copy Objects

Post by James Rowland-Jone » Thu, 27 Mar 2003 19:07:13



Hi,

Scenario
Table with no index populated by a copy objects DTS task
avg. page density 41%
Table with no index populated by a datapump avg. page
density 95+%

Without adding an index or moving the data out of the
receiving table and back in again is there a way to
physically resort the data in the pages for this table?

Also why would copy objects DTS task be doing this?