Skip to Content

Diff. b/w Table Reorganisation and Tablespace reorg.

Hello all,

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 08, 2008 at 02:12 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08, 2008 at 11:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded