SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to copy indexes on multiple tables to a different schema

KrithiJun 24 2013 — edited Jun 24 2013

I have done a mistake in manpulating data so all my indexes on certain tables are being lost now.

(I did an impdp with table_exists_action='replace' instead of 'truncate' and exclude=index was given in the options)

I have the indexes on a different schema(its a number of tables and its the same way indexes needs to be created) which i need to copy over.

Whats the best way to recreate indexes now?a re import with removing exclude=indexes or does anyone has a script to re create indexes from one schema to another?

Thanks

Version of oracle =11gR2

Windows o.s

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2013

Added on Jun 24 2013

3 comments

3,077 views