Re: Index tablespace reorg

In article <32E8B608.7539_at_att.com>, akirby_at_att.com says...
>
>Unknown wrote:
>>
>> Greetings all -
>>...
>> tablespaces and are not in need of reorganization. Is there an
>> easy way to generate the needed CREATE INDEX statements to recreate
>> ...
>> Brett Cunningham
>> zgeist_at_ee.net
>
>Brett,
> You're not confused, but I do think you have a serious problem.
> If you have indexes on your system but you don't have the
> scripts that were used to originally create them, what are you
> going to do if you have to recreate the database from scratch?
> Import only works if you want the exact same schema with the
> same storage, etc. I would suggest going back and creating
> ...
>
>Allen Kirby AT&T ITS Production Services
>akirby_at_att.com Alpharetta, GA.

  The solution to the problem would be to export the user   in question and reimport the data with the INDEXFILE-parameter set.

  This will create an ACII readable file with the create statements   for all tables (REMd out) and all indexes.

  This file can be edited normally and afterwards executed as   sql-script.   

  ( have a look at "oracle server utility user guide" p. 2-15 )   

  hth

-- 
    _/_/_/   _/_/_/ _/    _/  // Reinhard Kuhn             /  It can be      
   _/    _/ _/     _/  _/    //         (kuhn_at_cas-ps.com) /  done quickly,   
  _/_/_/   _/_/_/ _/_/      // CAS GmbH                  /  cheaply or well  
 _/  _/   _/     _/  _/    // Lemberger Strasse 14      /   - pick any two!  
_/   _/  _/_/_/ _/    _/  // 66955 Pirmasens, Germany  /