Yes, I forgot to say about this. The first query (the one that is conducted by SQLAlchemy) doesn't work when run on the database.
The second query you provided, does work so it appears that my tables are actually stored in the SYSTEM tablespace. Do you know of a way around this? On 18 Sep, 11:52, Mike Conley <[email protected]> wrote: > Did you verify that the full query gives results? > > SELECT table_name FROM all_tables > WHERE nvl(tablespace_name, 'no tablespace') NOT IN ('SYSTEM', 'SYSAUX') > AND owner = 'SCHEM'; > > I've been away from Oracle for a while, but I do remember it is unusual, but > still possible for user's tables to be in the SYSTEM or SYSAUX tablespaces. > > Double check with > > SELECT table_name, tablespace_name FROM all_tables WHERE owner = 'SCHEM'; --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
