reorg command

[RedHotRider]

I am a junior DBA and I am trying to find info on the REORG command. I have the Oracle8i dba book. Not much info. We have a customer who gave us a few housekeeping scripts that do imports/exports and then runs a reorg on a table and a index.

TIA

 

[rcurva]

Actually, there is no REORG command, but there is a REORG wizard available in Oracle Enteprise Managager 2.1 +.

You can actually use the export/import utilities in rebuilding your tables.
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[stefanhei]

Hi.
How does he call reorg?
@reorg or start reorg are used for SQL*Plus-Skripts
exec reorg is used for PL/SQL Procedures.
You can query all_source where name = 'REORG' for the code, or view it with tools like TOAD Enterprise-Manager.

Stefan

 

[RedHotRider]

The script basically runs a few imports and exports and then:

reorg table table_name index index_name;