Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Oracle Errors Interview Questions
Questions Answers Views Company eMail

TNS-01005: trace OFF | USER | ADMIN | SUPPORT [] : set tracing to the specified level

1 3252

TNS-01006: set password : set the password for subsequent calls

1 3327

TNS-01007: quit | exit : exit LSNRCTL

1 2979

TNS-01008: version [] : get the version information of the listener

1 3067

TNS-01009: service [] : get the service information of the listener

1 2963

TNS-01013: set|show trc_{ } []: set|show trace parameters of current listener

1 3313

TNS-01014: set|show log_{ } []: set|show log parameters of current listener

1 3936

TNS-01015: set|show parm_name []: sets|shows current listener parm values

1 4047

TNS-01016: change_password []: changes the password of the listener

1 3671

TNS-01017: set|show current_listener []: sets|shows current listener

1 3376

TNS-01018: save_config []: saves configuration changes to parameter file

1 3393

TNS-01019: set rawmode ON | OFF: set output mode for services and status commands

1 3063

TNS-01020: STATUS of the LISTENER

1 3102

TNS-01021: ------------------------

1 2879

TNS-01022: Alias string

1 3674


Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

ORA-26084: direct path context already finished

2000


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

3916


ORA-26029: index string.string partition string initially in unusable state

2236


ORA-26027: unique index string.string partition string initially in unusable state

6794


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

4042


ORA-26030: index string.string had string partitions made unusable due to:

1990


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

2804


ORA-16626: failed to enable specified object

2278


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

1823


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

8883


[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

2779


How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2768


NZE-28890: Entrust Login Failed

1932


IMP-00070: Lob definitions in dump file are inconsistent with database.

1801


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

2669