On Sep 21, 2012, at 1:24 PM, Hank Gay wrote: > On Sep 21, 2012, at 12:59 PM, Michael Bayer <mike...@zzzcomputing.com> wrote: > >> >> on your create_engine(), set "echo='debug'". it will show you all the >> catalog queries being emitted as well as the result rows that are being >> received for each one. >> > > Perfect! This allowed me to track down the problem. It turns out those > tables, though *visible* to the user, were not *owned* by that user; they > were owned by some other user (I think this particular schema was actually > the result of an old data pump export/import process), and the reflection > process only returns tables that are owned by the connected user. Now I'm off > to track down the best way to fix this table ownership issue. Thanks a ton!
oh right, I forgot to mention the Oracle dialect considers the "schema" to be the "owner". So if you said metadata.reflect(schema="ownername"), that would get at those tables. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
