From f4b524f9b3455a75466fb4658c6bdd1eab96fa7c Mon Sep 17 00:00:00 2001 From: Jonathan Ellis Date: Fri, 3 Aug 2007 04:01:41 +0000 Subject: [PATCH] table_names shouldn't include system tables. (if user wants that they should poke around in catalog manually.) --- lib/sqlalchemy/databases/oracle.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/sqlalchemy/databases/oracle.py b/lib/sqlalchemy/databases/oracle.py index e5411481f4..f183b1e4ed 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): -- 2.47.3