Hi all, i try to introspect a schema for an Oracle database on a site with multiple users, which have nearly identical schemas (common scenario on a development host).
E.g. in the database there are: msc_ora1.sct0001_00 msc_ora2.sct0001_00 create by the two users msc_ora1 and msc_ora2. Now it try to use SQLAlchemy (0.4 with cx_Oracle) to introspect those tables and get an exception: >>> import sqlalchemy as sa >>> meta = sa.MetaData >>> engine = sa.create_engine(oracle://msc_ora1:[EMAIL PROTECTED]) >>> conn = engine.connect() >>> meta.bind = conn >>> meta.reflect() Traceback (most recent call last): File "<stdin>", line 1, in <module> File "build\bdist.win32\egg\sqlalchemy\schema.py", line 1200, in reflect File "build\bdist.win32\egg\sqlalchemy\schema.py", line 114, in __call__ File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 909, in reflectta ble File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 1178, in reflectt able File "build\bdist.win32\egg\sqlalchemy\databases\oracle.py", line 434, in refl ecttable File "build\bdist.win32\egg\sqlalchemy\databases\oracle.py", line 380, in _res olve_table_owner File "build\bdist.win32\egg\sqlalchemy\databases\oracle.py", line 368, in _loc ate_owner_row sqlalchemy.exceptions.AssertionError: There are multiple tables with name 'SCT00 0001_00' visible to the schema, you must specifiy owner I tried with: >>> meta.reflect(schema=msc_ora1) but it raises the same exception. I have noticed the 'owner' attribute on the Table class, but how can i specify an owner for reflection as requested by the Exception? Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax: +49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: [EMAIL PROTECTED] Sitz der Gesellschaft: Bremen | Geschäftsführer: Karl Heinz Zachries Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
