This content has been marked as final. Show 5 replies
Pl post exact expdp and impdp commands used, along with the first 20 and last 20 lines of the export and import logs. What are these 7 indexes ?1 person found this helpful
Have you seen some errors in logfiles??1 person found this helpful
Sorry. Forgot to mention this important finding earlier. There were no errors found in expdp or impdp logs.
When you say 'missing' how do you know they are missing? I've seen cases before when indexes have system generated names that these are different between environments and this appears at first glance to be a difference. However all that has happened is that the index got a different name. This is very common for lobindexes for example. Do you also have missing indexes the other way round - how did you do the comparison?
did you take count of number of objects or the indexes itself on both databases and compare it. if the count matches, it might have been created with a different name.
you can also use the following SQLs. on both dbs and compare. you can load the output from the SQLs into an excel sheet and compare.
select owner, table_name, count(1) from dba_tables where owner='<schema_name>' group by owner, table_name