toad error ORA-00904:

Toad for Oracle
1

I am using 11g 11.2.02.0 and toad 10.6;

When I select the data tab, on table ACCOUNT_CUSTOMER_ADDRESS, I get a toad error ORA-00904: “USER_ID_CHG_BY¿”: invalid identifier; Following is the SQL thru SQL monitor ; This is not happening always but often on many tables.

I do not see no errors with Ora 9 database.
SQL PLUS is fine too;

Timestamp: 09:35:02.704
Select * from SYS.DBA_COL_PRIVS where OWNER = :own
and TABLE_NAME = :OneObjectName
ORDER BY grantee, OWNER, table_name, column_name, privilege
o = ‘W’
O = ‘A’

2

What version is your Oracle Client?

Can you give us a DDL of the ACCOUNT_CUSTOMER_ADDRESS table?

I see funny characters like "?????" in the column names in your output.
Do these column names have unicode character in them?

Ed
[TeamT]

On 4/28/2011 9:45 AM, jsajan1 wrote:

I am using 11g 11.2.02.0 and toad 10.6;

When I select the data tab, on table ACCOUNT_CUSTOMER_ADDRESS, I get a toad error ORA-00904: "USER_ID_CHG_BY¿": invalid identifier; Following is the SQL thru SQL monitor ; This is not happening always but often on many tables.

I do not see no errors with Ora 9 database.
SQL PLUS is fine too;

Timestamp: 09:35:02.704
Select * from SYS.DBA_COL_PRIVS where OWNER = :own
and TABLE_NAME = :OneObjectName
ORDER BY grantee, OWNER, table_name, column_name, privilege
o = 'W'
O = 'A'

3

Ed is right to ask about Oracle Client version. We have seen this with older
clients. Try a newer Oracle client (preferably 11g) and I think the problem will
disappear.