>>-REORG-------------------------------------------------------->
>--+-TABLE--table-name--| Table Clause |-----------------+------>
'-INDEXES ALL FOR TABLE--table-name--| Index Clause |-'
>--+-------------------------------+---------------------------><
'-| Database Partition Clause |-'
Table Clause:
|--+-------------------+---------------------------------------->
'-INDEX--index-name-'
.-ALLOW READ ACCESS-.
>--+-+-------------------+--+--------------+--+-----------+--+-------------+-+--|
| '-ALLOW NO ACCESS---' '-USE--tbspace-' '-INDEXSCAN-' '-LONGLOBDATA-' |
| .-ALLOW WRITE ACCESS-. .-START--. |
'-INPLACE--+-+--------------------+--+------------------+--+--------+-+---'
| '-ALLOW READ ACCESS--' '-NOTRUNCATE TABLE-' '-RESUME-' |
'-+-STOP--+------------------------------------------------'
'-PAUSE-'
Index Clause:
.-ALLOW READ ACCESS--.
|--+--------------------+--+-------------------------+----------|
+-ALLOW NO ACCESS----+ | .-ALL---. |
'-ALLOW WRITE ACCESS-' +-CLEANUP ONLY--+-------+-+
| '-PAGES-' |
'-CONVERT-----------------'
Database Partition Clause:
|--ON----------------------------------------------------------->
.-,--------------------------------------------------.
V |
>--+-+-DBPARTITIONNUM--+--(----db-partition-number1--+--------------------------+-+--)----------------------------------+--|
| '-DBPARTITIONNUMS-' '-TO--db-partition-number2-' |
'-ALL DBPARTITIONNUMS--+-------------------------------------------------------------------------------------------+-'
| .-,--------------------------------------------------. |
| V | |
'-EXCEPT--+-DBPARTITIONNUM--+--(----db-partition-number1--+--------------------------+-+--)-'
'-DBPARTITIONNUMS-' '-TO--db-partition-number2-'