title: How do I know if a table in Oracle is fragmented?
body: <p>I have a table which seems to be taking up more space than it needs to. I have been advised to copy the data to a new table and rename the new table and old table to swap them. How can I confirm if a current table is actually fragmented? How can I estimate or calculate the new size of the fresh table containing the same data?</p>