From 9f4f68afd26a7b365397dc87ed48a4508f29618a Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 21 Nov 2006 22:04:31 +0000 Subject: [PATCH] [ticket:373] --- lib/sqlalchemy/databases/oracle.py | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/lib/sqlalchemy/databases/oracle.py b/lib/sqlalchemy/databases/oracle.py index 62ef3b6c2f..8fd9e3785f 100644 --- a/lib/sqlalchemy/databases/oracle.py +++ b/lib/sqlalchemy/databases/oracle.py @@ -108,6 +108,7 @@ constraintSQL = """SELECT LOWER(loc.column_name) AS local_column, LOWER(rem.table_name) AS remote_table, LOWER(rem.column_name) AS remote_column + LOWER(rem.owner) AS remote_owner, FROM all_constraints ac, all_cons_columns loc, all_cons_columns rem @@ -272,7 +273,7 @@ class OracleDialect(ansisql.ANSIDialect): if row is None: break #print "ROW:" , row - (cons_name, cons_type, local_column, remote_table, remote_column) = row + (cons_name, cons_type, local_column, remote_table, remote_column, remote_owner) = row if cons_type == 'P': table.primary_key.add(table.c[local_column]) elif cons_type == 'R': @@ -282,7 +283,7 @@ class OracleDialect(ansisql.ANSIDialect): fk = ([], []) fks[cons_name] = fk refspec = ".".join([remote_table, remote_column]) - schema.Table(remote_table, table.metadata, autoload=True, autoload_with=connection) + schema.Table(remote_table, table.metadata, autoload=True, autoload_with=connection, owner=remote_owner) if local_column not in fk[0]: fk[0].append(local_column) if refspec not in fk[1]: -- 2.47.2