[DB-SIG] Oracle+SQLA: Where are my tables?
John W. Shipman
john at nmt.edu
Wed Nov 20 02:27:28 CET 2013
I'm using SQLAlchemy and cx_Oracle to explore a legacy Oracle
database. When I use Oracle's sqldeveloper application, I can
see the tables and their contents just fine.
When I connect to it using SQLAlchemy, I can create the engine
with no problem, but after I call the .reflect() method on the
MetaData instance, its .sorted_tables list is empty. If I
connect to a Postgres database and do the same thing, the
.sorted_tables list is as the documentation says it should be.
Any suggestions on how to find the tables? A coworker says that
tables in Oracle are segregated into namespaces. Is that my
problem?
I would greatly appreciate any assistance.
Best regards,
John Shipman, Web Developer, National Radio Astronomy Observatories;
john at nmt.edu, http://www.nmt.edu/~shipman/
More information about the DB-SIG
mailing list