5 It is because one of the DBs the column was created with " which makes its name case-sensitive. Oracle Table Column Name : GoodRec Hive cannot recognize case sensitivity : ERROR thrown was - Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "GOODREC": invalid identifier Solution : Rename Oracle column name to all caps. The result will be "ORA-00942: table or view does not exist" even though user2 does have insert and select privileges on user1.customer table and is correctly prefixing the table with the schema owner name.

Understanding the Context

-2 In my case, (ORA-12560: TNS protocol adapter error)Issue cause of database connection issue like database, user name and password. Once you got the issue. Initially you have to check connection details, after check the oracle service and further more. ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 13 06502.

Key Insights

00000 - "PL/SQL: numeric or value error%s" FIXED by changing how I declared the variable "a" to: ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client Asked 13 years, 2 months ago Modified 1 year ago Viewed 987k times 19 ORA-03113: end-of-file on communication channel Is the database letting you know that the network connection is no more. This could be because: A network issue - faulty connection, or firewall issue The server process on the database that is servicing you died unexpectedly. For 1) (firewall) search tahiti.oracle.com for SQLNET.EXPIRE_TIME. We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the According to the error: ORA-02291: integrity constraint (string.string) violated - parent key not found Cause: A foreign key value has no matching primary key value. Action: Delete the foreign key or add a matching primary key.

Final Thoughts

This means that there is no matching key in your referenced table. EDIT #1