title: Connecting to an Oracle database using SQLAlchemy
body: <p>I am able to successfully connect to a SQLite database and access a particular table using the set of commands below:</p>
  <pre><code>from sqlalchemy import create_engine, MetaData, Table, and_
  from sqlalchemy.sql import select
  from pandas import DataFrame 
  
  db = create_engine('sqlite:///path\\database.db')
  metadata = MetaData(db)
  table = Table('table name', metadata, autoload=True)
  </code></pre>
  <p>I am able to fetch data from an Oracle database using <a href="https://oracle.github.io/python-cx_Oracle/" rel="noreferrer">cx_Oracle</a>.</p>
  <p>However, when I try to connect to an Oracle database in SQLAlchemy, I am getting the following error:</p>
  <blockquote>
  <p>NoSuchTableError: &lt;table name&gt;</p>
  </blockquote>
  <p>I have used the following commands:</p>
  <pre><code>db = create_engine('oracle://username:password@hostname:1521/instance name', echo='debug')
  md = MetaData(bind=db)
  t = Table('table name', md, autoload=True, schema='schema name')
  </code></pre>
  <p>When I use the following command:</p>
  <pre><code>t= Table('table name', md, autoload=True, oracle_resolve_synonyms=True)
  </code></pre>
  <p>I get the following error:</p>
  <blockquote>
  <p>AssertionError: There are multiple tables visible to the schema, you must specify owner</p>
  </blockquote>
  <p>Can you please explain where exactly I am going wrong?</p>