| validation after expdp and impdp [message #508873] |
Tue, 24 May 2011 14:28  |
lg123
Messages: 225
Registered: August 2008
|
Senior Member |
|
|
|
I did the expdp and impdp of a schema and found that out of total 120 indexes, there were almost 80 indexes missing in the destination schema. How to find out only those 80 missing indexes so that I could recreate them all without taking much time?
|
|
|
|
|
|
|
|
| Re: validation after expdp and impdp [message #508882 is a reply to message #508879] |
Tue, 24 May 2011 15:51  |
cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Assuming the 2 schemas are in the same DB a simple query against all_indexes would do the job:
SELECT table_name, index_name
FROM all_indexes
WHERE owner = <target_schema>
MINUS
SELECT table_name, index_name
FROM all_indexes
WHERE owner = <source_schema>
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
