Reorg complete database

[Former Member]

Hello,

we got rid of a couple of clients on the DEV and QAS System after the project finished.

I assume that we now need to reorg the database. So far I have only found instructions how to reorg a certain table. Is there no "reorg everything" command in Oracle?

Thanks for thinking!

Andi

[lbreddemann · Accepted solution]

Hello Andreas,

please review note

#646681 - Reorganisation von Tabellen mit BRSPACE

and don't be misled by the tile.

It's explained in the note how to reorganize complete tablespaces.

A "reoganize everything" is not available and also not necessary most often.

If you want to just have the database reloaded from scratch - then you can perform a export and import via the R3load tools (just like you do it for heterogenous system copies).

But in the case you described I'd propose to stick with BRSPACE.

regards,

Lars

[Former Member]

Hi

U can use table reorg # brspace -f tbreorg -t <table_name>

For Mulitple Tables u can make spool.sql and run on SQL> spool.sql

Reorg set the HWM to required lavel as by shrink&compact in oracle 10g.

Regards

Surendra jain