Oracle Database Discussions

Hi All,

I was trying to export schema from development to production Database. After completing the export and import when I query dba_tables and dba_indexes the count matches exactly in production and development but when I querry

select count(*),segment_type from dba_segments where owner='Schemaname' group by segment_type order by 2;


Both in Development and Production it give different values for all segments including tables and indexes.

Can any one please let me know where this mismatch is coming. Am I doing the wrong query?

Thanks & Regards,
Vikas Krishna