Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Oracle Errors Interview Questions
Questions Answers Views Company eMail

ORA-02084: database name is missing a component

1 8333

ORA-02085: database link string connects to string

1 4061

ORA-02086: database (link) name is too long

1 1725

ORA-02087: object locked by another process in same transaction

1 1472

ORA-02088: distributed database option not installed

1 2043

ORA-02089: COMMIT is not allowed in a subordinate session

Oracle,

1 8054

ORA-02090: network error: attempted callback+passthru

1 1924

ORA-02091: transaction rolled back

1 3836

ORA-02092: out of transaction table slots for distributed transaction

1 1849

ORA-02093: TRANSACTIONS_PER_ROLLBACK_SEGMENT(string) more than maximum possible(string)

1 1785

ORA-02094: replication option not installed

1 2100

ORA-02095: specified initialization parameter cannot be modified

1 3773

ORA-02096: specified initialization parameter is not modifiable with this option

1 3397

ORA-02097: parameter cannot be modified because specified value is invalid

1 6751

ORA-02098: error parsing index-table reference (:I)

1 1574


Post New Oracle Errors Questions






Un-Answered Questions { Oracle Errors }

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...

1847


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...

1753


When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

1876


IMP-00064: Definition of LOB was truncated by export

5282


IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

844






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

1797


ORA-16516: The current state is invalid for the attempted operation.

6649


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

1110


ORA-26084: direct path context already finished

1053


ORA-16627: No standby databases support the overall protection mode.

3114


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

1017


invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

2410


IMG-02003: 2FF03 - incorrect color histogram feature specification

765


NZE-28890: Entrust Login Failed

941


[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

1817