diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2009-12-26 22:41:44 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2009-12-26 22:41:44 +0000 |
| commit | bc5ad4e8afcdda269e0ec0d1c2fc40da13d2b999 (patch) | |
| tree | 9604e460a5d5cd330a45ac68911ceaf3f9bc22a2 /lib/sqlalchemy/dialects/oracle/base.py | |
| parent | aa6f068a92cd7f62479b8555bf114053a5be31d6 (diff) | |
| download | sqlalchemy-bc5ad4e8afcdda269e0ec0d1c2fc40da13d2b999.tar.gz | |
merged r6570 from 0.5 branch, dont reflect IOT tables [ticket:1637]
Diffstat (limited to 'lib/sqlalchemy/dialects/oracle/base.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/oracle/base.py | 6 |
1 files changed, 4 insertions, 2 deletions
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] |