summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases
diff options
context:
space:
mode:
authorJonathan Ellis <jbellis@gmail.com>2007-08-03 04:01:41 +0000
committerJonathan Ellis <jbellis@gmail.com>2007-08-03 04:01:41 +0000
commitf4b524f9b3455a75466fb4658c6bdd1eab96fa7c (patch)
treec29b0236b3cc4831f5afcc4a769fe3e510db8a94 /lib/sqlalchemy/databases
parentb8588ef4f76c9d0104bfc53b7af1f99386be4d4c (diff)
downloadsqlalchemy-f4b524f9b3455a75466fb4658c6bdd1eab96fa7c.tar.gz
table_names shouldn't include system tables. (if user wants that they should poke around in catalog manually.)
Diffstat (limited to 'lib/sqlalchemy/databases')
-rw-r--r--lib/sqlalchemy/databases/oracle.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/sqlalchemy/databases/oracle.py b/lib/sqlalchemy/databases/oracle.py
index e5411481f..f183b1e4e 100644
--- a/lib/sqlalchemy/databases/oracle.py
+++ b/lib/sqlalchemy/databases/oracle.py
@@ -367,7 +367,7 @@ class OracleDialect(ansisql.ANSIDialect):
def table_names(self, connection, schema):
# sorry, I have no idea what that dblink stuff is about :)
- s = "select table_name from all_tables"
+ s = "select table_name from all_tables where tablespace_name NOT IN ('SYSTEM', 'SYSAUX')"
return [row[0] for row in connection.execute(s)]
def reflecttable(self, connection, table, include_columns):