Re: Index tablespace reorg

From: Strategic Data Systems <sds_at_dataplusnet.com>
Date: 1997/01/29
Message-ID: <5cnodr$aps$1@news.inc.net>#1/1

In article <32E8B608.7539_at_att.com>, akirby_at_att.com says...
>
>Unknown wrote:
>>
>> Greetings all -

>> 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

Export the table(s) in question
Do an import like this: imp user/passwd file=exportfile indexfile=create.sql full=y where: exportfile=the file exported to in step 1 create.sql=text file out put of create table ans create index SQl statements

You then can edit the create.sql to change any ofther paraemeters in the create table/index scripts. Received on Wed Jan 29 1997 - 00:00:00 CST