title: Not getting list of tables from database
body: <p>I am trying to get list of tables owned by current Oracle user.I have created user in oracle in which I am having below 2 tables :</p>
  
  <ul>
  <li><p>Categories</p></li>
  <li><p>Address</p></li>
  </ul>
  
  <p>Now when I run below query in oracle then I am getting only above 2 tables which I want :</p>
  
  <pre><code>SELECT table_name FROM user_tables;
  </code></pre>
  
  <p>Reference of above query : <a href="https://www.arungudelli.com/tutorial/oracle/list-all-tables-in-oracle-query/" rel="nofollow noreferrer">https://www.arungudelli.com/tutorial/oracle/list-all-tables-in-oracle-query/</a></p>
  
  <p>But problem is when i am trying to get list of tables using <a href="https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/schema-restrictions" rel="nofollow noreferrer">GetSchema</a> method then i am not getting anything : </p>
  
  <pre><code>public Datatable GetTables(DbConnection conn)
          {
                conn.Open();
                if (conn.State == ConnectionState.Open)
                {
                      var tables = conn.GetSchema("Tables", new string[] { "user_tables" });
                }
                conn.Close();
          }
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/X6Adg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/X6Adg.png" alt="enter image description here"></a></p>
  
  <p>Now when I do like below then I am getting unnecessary tables(> 1000) which are system tables and other tables(dont know from where they are coming though I only have Categories and Address tables) : </p>
  
  <pre><code>var tables = conn.GetSchema("Tables");
  </code></pre>
  
  <p>So I only want to get list of tables owned by current Oracle user.Below is my connection string : </p>
  
  <pre><code>data source="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyService)))";user id=C##Db1;password=root123;
  </code></pre>
  
  <p>Can someone please help me with this?</p>