Anuj Singh Oracle DBA
Thursday, 4 December 2025
How to solve ORA-02291: integrity constraint violated - parent key not found
›
How to solve ORA-02291: integrity constraint violated - parent key not found . =====================================================...
Wednesday, 26 November 2025
unix command for DBA
›
Basic File Navigation The "pwd" command displays the current directory. root> pwd /u01/app/oracle/product/9.2.0.1.0 The ...
Tuesday, 18 November 2025
ON DELETE CASCADE | CASCADE CONSTRAINTS
›
ON DELETE CASCADE and CASCADE CONSTRAINTS ==================================================== CREATE TABLE DEPTX (DEPTNO NUMBER PRIMA...
Wednesday, 12 November 2025
ORA-02292: integrity constraint violated - child record found
›
SQL> delete from ANUJ.DEPT where deptno=10; delete from ANUJ.DEPT where deptno=10 * ERROR at line 1: ORA-02292: integrity constraint (ANU...
Wednesday, 5 November 2025
Oracle 26ai ( on free vm )
›
export TWO_TASK= sqlplus / as sysdba SQL*Plus: Release 23.26.0.0.0 - Production on Wed Nov 5 14:25:30 2025 Version 23.26.0.0.0 Copyrig...
Friday, 17 October 2025
ORA-00054: resource busy and acquire with NOWAIT
›
ORA-00054: resource busy and acquire with NOWAIT set linesize 300 pagesize 300 col file# for 9999999 col block# for 9999999999999999 ...
Tuesday, 9 September 2025
How to get Oracle current session id ?
›
How to get Oracle current session id ? Oracle my session ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS'; set lines...
›
Home
View web version