static ServerAccessOracle() { //if (LoggingSystem.LoggingSystem.TraceCode) LoggingSystem.LoggingSystem.LogMessage = "static ServerAccessOracle()"; OracleConnection = getOracleConnection(null); List<string> databaseNames = new List<string>(); try { try { string commandString = "show databases "; OracleCommand OracleCommand = new OracleCommand(commandString, OracleConnection); /*OracleDataReader myReader = OracleCommand.ExecuteReader(); ////if (OracleTrace) SQLView.Log(OracleCommand.CommandText); while (myReader.Read()) { if (!string.IsNullOrEmpty(myReader.GetString(0))) { databaseNames.Add(myReader.GetString(0)); } } myReader.Close(); */ } catch (InvalidOperationException ioe) { } } catch (OracleException retrieveSymbolIndexException) { Console.WriteLine("Error: {0}", retrieveSymbolIndexException.ToString()); } foreach (string database in databaseNames) { List<string> tableNames = new List<string>(); try { try { OracleConnection.ChangeDatabase(database); getOracleConnection(database); string commandString = "USE " + database + "; SHOW TABLES ;"; OracleCommand OracleCommand = new OracleCommand(commandString, OracleConnection); OracleDataReader myReader = OracleCommand.ExecuteReader(); ////if (OracleTrace) SQLView.Log(OracleCommand.CommandText); while (myReader.Read()) { if (!string.IsNullOrEmpty(myReader.GetString(0))) { string tb = myReader.GetString(0); string DB = myReader.GetString(0); if (tb.Equals("simbs") || tb.Equals("srel")) { tableNames.Add(tb); } } } myReader.Close(); } catch (InvalidOperationException ioe) { } } catch (OracleException retrieveSymbolIndexException) { Console.WriteLine("Error: {0}", retrieveSymbolIndexException.ToString()); } if (tableNames.Contains("simbs") && tableNames.Contains("srel")) { GooDBDs.Add(database); } } OracleDB = "SYSTEM"; //if (MyResultsTrace)//SQLView.LogResult(new string[] { name }); }