How to import only indexes after we imported table
952873Mar 16 2013 — edited Mar 17 2013Hi experts,
I exported table "abc"
imported table "abc" to new table "xyz".
Now how can i import all the indexes that exist on table "abc" to table "xyz".
i used below syntax and getting below error
syntax : remap_table=abc:xyz, abc_index1:xyz_index1, abc_index2:xyz_index1, content=metadata_only
error : ora-39151 : table abc exists. All dependent metadata and data will be skipped due to table_exists_action of skip
Db version is 11gR3.
Thanks
Naveen