TheHades0210 wrote:what exactly should be reported as expected & desire.
Yes but i dont know what table name and index of these 3 instances. I want to compare then as a whole instance. Which dba tables best too use to compare both index and PK(constraints).
TheHades0210 wrote:compare content of DBA_OBJECTS
What is expected in this comparison is the differences of these 3 instances with respect to their Indexes and Constraints, since 2 of these instances were cloned from the base instance(one of the 3). It is desired to know what are these missing objects and will be created to the cloned instances . Regarding on the partitioning of tables, yes some of the tables are partitioned. For the assigned system name of index, honestly i don't know. Is there a way i can check?
TheHades0210 wrote:DESC DBA_OBJECTS
Thanks for the reply, comparing the indexes. Which is better to use dba_ind_columns or dba_objects, and what are the differences between this 2 dba tables with respect to indexes?
TheHades0210 wrote:most likely are system generated, but not necessarily so.
Thank you for such elaborated explanation. I only want to know why under INDEX_NAME of dba_ind_Columns, some of the names has $ and # characters. Is this system generated Indexes?
If so, what application generate this indexes?I don't know what applications are installed in your DB.