What does the second query report for tablespace_name? SYSTEM?
If so, you need to talk to your DBA about why the default tablespace for
your owner is SYSTEM. Normally the system is configured to have user tables
go somewhere else.
>From the SQLAlchemy side, the maintainers of databases/oracle.py might
consider removing SYSTEM, SYSAUX condition from the table_names query when
schema is provided. I'm not sure of side effects, but should be OK, because
table list will still be filtered by schema name.
You could experiment with this yourself to see if that is the issue and
submit a ticket
A crude experiment (no guarantees, this might break everything) is to do
this early in your script, some time before creating engine and reflecting
the tables.
import sqlalchemy.databases.oracle
def my_table_names(self, connection, schema): # a modified version of
OracleDialect.table_names()
# note that table_names() isnt loading DBLINKed or synonym'ed tables
if schema is None:
s = "select table_name from all_tables where
nvl(tablespace_name, 'no tablespace') NOT IN ('SYSTEM', 'SYSAUX')"
cursor = connection.execute(s)
else:
# remove SYSTEM, SYSAUX tablespace filter from original query
s = "select table_name from all_tables where OWNER = :owner" #
removed SYSTEM tablespace filter
cursor = connection.execute(s, {'owner':
self._denormalize_name(schema)})
return [self._normalize_name(row[0]) for row in cursor]
sqlalchemy.databases.oracle.OracleDialect.table_name = my_table_names
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
