-3

I have 3 different tables in which we first time insert the data and update for same case from 3 others tables.

We have 1500 columns used for selecting and updating, also there is a master like get country code from country description like description is INDIA and getting value from master is IN code.

Improve this question
New contributor
QAP is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
3
  • Without any further information (table structure, procedure code, complete and precise error message), it is virtually impossible for anyone to help you .... Commented 4 hours ago
  • what is the problem that you are trying to solve? ... please add a focused, answerable question to your post Commented 3 hours ago
  • ORA-00060 is dead lock: so it's more likely a problem of application architecture than of database structure, common causes are you are NOT doing the lock operations of some objects in the same order everywhere… The SYS.SYSTEMSTATS table and the SYS.MONITOR table records information about deadlocks and timeouts, also v$session_blockers view contains info. Commented 3 hours ago
Related questions
1234
Get list of all tables in Oracle?
1397
How do I limit the number of rows returned by an Oracle query after ordering?
1176
How do I rename a MySQL database (change schema name)?
Load 4 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.