ORACLE db name in table definitions

[vkuznet]

Hi,
I've got a new DB to handle and the account is setup in a way that I
need to specify dbname for selects, e.g. select * from DBNAME.T

So, I created a table
T=Table('DBNAME.T'....)

and once I used it
res=select([T]).execute()
the sqlalchemy constructed the following query with *quotes*

select "DBNAME.T".id from "DBNAME.T"

the problem is that ORACLE doesn't accept it, but if I manually drop
*quotes* from this select and pass it to sqlplus everything works,
i.e.

select DBNAME.T.id from DBNAME.T

How to disable *quoting* for SQLAlchemy?

Thanks,
Valentin.

[Michael Bayer]

dont stick "foo.bar" in your table name. use the schema="DBNAME"
parameter on your Table.

[vkuznet]

Thanks,
it works.