This is what I use for Oracle in torque.build: torque.database.schema=XYZ
> -----Original Message----- > From: Duddikunta, Padmanabha [mailto:[EMAIL PROTECTED] > Sent: Monday, June 16, 2003 9:22 AM > To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' > Subject: Schema qualifier for table names > > I having trouble specifying schema qualifier for tables. I login to > database using a user "dbuser", but my tables lie under a different schema > > say XYZ schema. > > > > Now I want to query XYZ.TABLE1. But torque seems to generate sql > something > like, > > > > SELECT COL1, COL2, COL3 FROM dbuser.TABLE1 instead of > > > > SELECT COL1, COL2, COL3 FROM XYZ.TABLE1 > > > > > > I would appreciate any pointer on solving this problem. > > > > Thanks > > Paddy > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
