ORA-00942 when importing data from Oracle Database to Pandas

Question

I try to import data from a oracle database to a pandas dataframe.

right Now i am using:

import cx_Oracle
import pandas as pd
db_connection_string = '.../A1@server:port/servername'
con = cx_Oracle.connect(db_connection_string)
query = """SELECT* 
           FROM Salesdata"""
df = pd.read_sql(query, con=con)

and get the following error: DatabaseError: ORA-00942: Table or view doesn't exist

When I run a query to get the list of all tables:

cur = con.cursor()
cur.execute("SELECT table_name  FROM dba_tables")
for row in cur:
    print (row)

The output looks like this:

('A$',)
('A$BD',)
('Salesdata',)

What I am doing wrong? I used this question to start.

If I use the comment to print(query)I get:

SELECT* 
           FROM Salesdata

Comment out your data frame df and print the query. print(query). Check what is the result. This would make us understand the issue — Jim Macaulay
– Jim Macaulay, Commented Jun 10, 2020 at 6:34

pifor · Accepted Answer · 2020-06-10 07:39:29Z

1

Getting ORA-00942 when running SELECT can have 2 possible causes:

The table does not exist: here you should make sure the table name is prefixed by the table owner (schema name) as in select * from owner_name.table_name. This is generally needed if the current Oracle user connected is not the table owner.
You don't have SELECT privileges on the table. This is also generally needed if the current Oracle user connected is not the table owner.

You need to check both.

answered Jun 10, 2020 at 7:39

pifor

7,9722 gold badges11 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ORA-00942 when importing data from Oracle Database to Pandas

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related