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; j...@nmt.edu, http://www.nmt.edu/~shipman/ _______________________________________________ DB-SIG maillist - DB-SIG@python.org https://mail.python.org/mailman/listinfo/db-sig
