RE: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long]

At 10:16 AM 3/22/01 -0500, Brooks, Ken wrote:

I got it.

ah. :) good

I had the table name listed as aradmin_eps_service_instructions when in fact it should have been aradmin.eps_service_instructions (with the dot). I did not know this because all of the tables I had seen linked to this before used _ ,but the actual name (which i normally don't have priveledge to even view) uses the .

Actually, in Oracle parlance, the table name is EPS_SERVICE_INSTRUCTIONS, and it exists in the ARADMIN schema. If there is no public synonym called EPS_SERVICE_INSTRUCTIONS, then you'd need to specify both schema and table name (eg: owner.table_name) in order to view the table. If you didn't have the privs to view a given table, you'd not be able to view it whether you specified the schema or not. :) A list of the tables you can "see" along with their schema (owners) can be obtained by running the following SQL query: SELECT OWNER,TABLE_NAME FROM ALL_TABLES;

Whee!

Indeed. :) ..or, try: SELECT OWNER||'.'||TABLE_NAME FROM ALL TABLES; - Brian ------------------------------------- Brian S. Dunworth Sr. Software Development Engineer Oracle Database Administrator The Printing House, Ltd. (850) 875-1500 x225 <brian@theprintinghouse.com> -------------------------------------