Re: Index tablespace reorg

If you take a full export (rows=N, you don't need the data), then execute

    imp {userid/pswd} indexfile={filename} file={export filename}

this will create a file {filename} that has the DDL for tables (commented out), and all the Index DDL. You can then edit this file and strip out the 'stuff' you don't need.
Just run it like a Sql script after dropping all the indexes that you wish to rebuild.

Hope this helps.

-- 
My views are my views! You can have your own.
               ___  O 0
              (_/\_)  0
        ====(o)  o

Unknown <zgeist_at_ee.ee.net> wrote in article <5c8bqd$ee9_at_news1.ee.net>...


> Greetings all -

> 

> I have a slew of indexes in a tablespace that I wish to reorganize 

> (and increase in size).  I don't want to use ALTER TABLESPACE ADD

 DATAFILE


> as I would rather just make a new, single file to hold all the

 information.


> 

> Anyway, my problem is that the related data files are in various other

> tablespaces and are not in need of reorganization. Is there an

> easy way to generate the needed CREATE INDEX statements to recreate

> the indexes after I drop/recreate the tablespace ?  I am unaware of any

 way


> to just export the index segments in that tablespace and re-import

> them to the new tablespace.

> 

> The only way I can think of doing this is via the DBA_IND_COLUMNS

> and DBA_INDEX views and creating some SQL commands from that.

> Am I totally confused ?

> 

> Thanks in advance for any assistance.

> 

> Brett Cunningham

> zgeist_at_ee.net

> 

> 

>