Category Archives: Error Codes

Oracle: ORA-02292: integrity constraint violated – child record found

‘ORA-02292: integrity constraint violated – child record found’ error occurs when we try to delete a row from a parent table which is having a child table with foreign key constraint and the corresponding data exists in the child table.

ORA-01882: TIMEZONE REGION NOT FOUND |Oracle Error

ORA-01882: TIMEZONE REGION NOT FOUND. This error occurs when timezone region string not found.The specified region name was not found.There are a number of time zone constants defined in oracle to use.See the last part of this post to know hoe to get the defined time zone constants in your oracle database.