This content has been marked as final. Show 4 replies
Thanks Srini for the inputs.
Only thing here is that I am not trying to move Table with in a schema but trying to copy over objects (DDL and Data) of one schema to another.
Right - you cannot "rebuild" LOB indexes. You will need to issue "ALTER TABLE <x> MOVE;" commands to "rebuild" those indexes.
aah, got it. I can feel the amount of time it will take to move. I guess I may not be able to save time by going through this approach then.
Thanks for your help Srini!