Oracle Errors Interview Questions
Questions Answers Views Company eMail

ORA-02785: Invalid shared memory buffer size

1 2500

ORA-02786: Size needed for shared region is greater than segment size

1 2066

ORA-02787: Unable to allocate memory for segment list

1 2347

ORA-02788: Unable to find kernel process pointer in async process array

1 2399

ORA-02789: Maximum number of files reached

1 2416

ORA-02790: File name is too long

1 2261

ORA-02791: Unable to open file for use with asynchronous I/O

1 2578

ORA-02792: Unable to fstat() a file being used for asynchronous I/O.

1 2105

ORA-02793: Close of asynchronous I/O failed.

1 2233

ORA-02794: Client unable to get key for shared memory

1 2504

ORA-02795: Request list is empty

1 2476

ORA-02796: Done request is not in correct state

1 2296

ORA-02797: No requests available

1 2358

ORA-02798: Invalid number of requests

1 2414

ORA-02799: Unable to arm signal handler

1 2085


Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

ORA-26094: stream format error: input column overflow

2248


ORA-26032: index string.string loading aborted after string keys

1653


ORA-26076: cannot set or reset value after direct path structure is allocated

1472


ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2313


ORA-26095: unprocessed stream data exists

2801






Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2137


ORA-26084: direct path context already finished

1481


RMAN-05017: no copy of datafile number found to recover

1881


if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2230


ORA-26079: file "string" is not part of table string.string

1518


NZE-28868: Peer certificate chain check failed.

2263


In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2325


when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

1748


ORA-26028: index string.string initially in unusable state

3398


ORA-26082: load of overlapping segments on table string.string is not allowed

1376