I need to fetch all the tables in the database and for that I am using ADODB's Connection.OpenSchema as below -
_connection.OpenSchema(SchemaEnum.adSchemaTables, new string[] { "", "ADMIN", "", "TABLE" });
This call returns a Record set that contains the all the tables. This call actually returns duplicate tables in the record set whereas the data in the database is absolutely correct.
Here I am using Oracle Server and Client - 12.2 Version
I have used Oracle server 12.2 64 bit and tested it with both Oracle client 12.2 - 32 bit as well as 12.2 - 64 bit. I found duplicate values both the times.
To ensure that the issue is only on Oracle Client 12.2 - I also tested the same with Oracle server 12.2 - 64 bit and Oracle client 12.1 . This time the tables were not duplicate. Hence the issue is only with Oracle client 12.2
The duplicate tables were found in particular order. Out of all the tables, only the first tables 100 were duplicated and rest of the tables after 100th were fine in the list.
What can be done to avoid the duplicate tables?