When updated table, found error: ORA-08102: index key not found, obj# 116528, file 96, block 8795 (2) This problem I had resolved by rebuild indexes (ORA-08102 on index objects). But today I can not use this solution: [...]
You are trying to delete a record, but one or more child records were found, preventing the delete. A (parent / child) relationship between 2 tables are defined by a foreign key constraint. eg: CREATE TABLE PARENT ( ID [...]
“ORA-00980: synonym translation is no longer valid” is a common error encountered in a development environment. This can happen for many reasons. Some of them are 1. You created a synonym on non-existing obje[...]
ORA-01940: Cannot drop a user that is currently connected Problem Description: SQL> drop user strmadmin cascade; drop user strmadmin cascade * ERROR at line 1: ORA-01940: cannot drop a user that is currently connected[...]
This page is an introduction to my blog, which is dedicated to Oracle data base performance management.
I found over the years sharing knowledge to be an invaluable tool in assisting me in my various consulting assignments. Spending most of my time in capacity planning, tuning, application sizing and performance management, I thought it might be [...]
dba Ask TEM Dba
(0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5)