How to List Tables with Reorganisation Type

[former_member45798]

Hi All,

Please help with SQL query to list Tables (selected 'n' tables) with their reorg type (like Offline/Online) in SINGLE query.

Approach:

1.Take top 50 tables

2. If  table has data type LONG or LONG RAW, table should be considered for OFFLINE reorganization and remaining tables for ONLINE reorg.

Help is much appreciated !

As of now, getting it done using separate queries and excel sorting.

Thanks

Ram

[Former Member]

View COL could give you a start.

It has a list of all tables with all columns and respective column types.

In sqlplus, as SAP schema owner, try something like this:

select table_name < your top 50 query here >

MINUS

select tname from col

where colype like 'LONG%';

[former_member45798]

Thanks for reply,

Want to get the results as below and with single SQL query. Help !! 🙂

Eg::

Table  Reorg_Type

T1       OFFLINE

T2       ONLINE

T3        ONLINE

T4        OFFLINE

Rgds

Ram