-
Moving text datatype column over segments
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|