From bc5ad4e8afcdda269e0ec0d1c2fc40da13d2b999 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sat, 26 Dec 2009 22:41:44 +0000 Subject: merged r6570 from 0.5 branch, dont reflect IOT tables [ticket:1637] --- lib/sqlalchemy/dialects/oracle/base.py | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'lib/sqlalchemy/dialects') diff --git a/lib/sqlalchemy/dialects/oracle/base.py b/lib/sqlalchemy/dialects/oracle/base.py index ddcc9f460..082a987ba 100644 --- a/lib/sqlalchemy/dialects/oracle/base.py +++ b/lib/sqlalchemy/dialects/oracle/base.py @@ -551,12 +551,14 @@ class OracleDialect(default.DefaultDialect): if schema is None: cursor = connection.execute( "SELECT table_name FROM all_tables " - "WHERE nvl(tablespace_name, 'no tablespace') NOT IN ('SYSTEM', 'SYSAUX')") + "WHERE nvl(tablespace_name, 'no tablespace') NOT IN ('SYSTEM', 'SYSAUX') " + "AND IOT_NAME IS NULL") else: s = sql.text( "SELECT table_name FROM all_tables " "WHERE nvl(tablespace_name, 'no tablespace') NOT IN ('SYSTEM', 'SYSAUX') " - "AND OWNER = :owner") + "AND OWNER = :owner " + "AND IOT_NAME IS NULL") cursor = connection.execute(s, owner=self.denormalize_name(schema)) return [self.normalize_name(row[0]) for row in cursor] -- cgit v1.2.1