Diff. b/w Table Reorganisation and Tablespace reorg.

[sanjeev_kumar18]

Hello all,

Is there any diff. b/s tablespace and table reorg.? And also when to do table reorg.?

[former_member204746 · Accepted solution]

there are major differences.

basically, a tablespace will hold many tables...

a tablespace reorg will reorganize all tables/objects from within this tablespace. this is often used to go from dictionary managed to locally managed tablespaces.

a table reorg will just reorg.... well... on 1 table only.

[markus_doehr2]

A table reorganization is just one table getting exported, dropped, re-created and imported. The tablespace contains many tables and this is then done for all of the tables.

Please get some knowledge about Oracle database concepts (http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/toc.htm)

Markus