I have a table with text datatype column. I want to move that table to another segment (already defined) of the database. I have recreated the PK index and other indexes on new segment. If I say "select * from sysindexes" for that table, it shows that the index containing text column is still on the old segment.
Can any suggest me a way to move that index onto new segment. As of now, I know one solution to create an identical table on new segment, copy over the info from old, drop the old and rename the new table.

Thanks for your help,
Nishant