Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

ORA-36154: (XSMXAGGR01) workspace object is not a data variable.

1 2857

ORA-36155: (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.

1 2836

ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.

1 2720

ORA-36160: (XSMXAGGR04) You may not use AGGREGATE on scalar VARIABLE workspace object.

1 2954

ORA-36178: (XSAGGR01) To be used with AGGREGATE, AGGMAP workspace object must be declared with the AGGMAP command.

1 3510

ORA-36179: (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object.

1 3004

ORA-36180: (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.

1 2473

ORA-36182: (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.

1 3386

ORA-36184: (XSAGGR10) You do not have sufficient permissions for the variable workspace object.

1 2945

ORA-36188: (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.

1 2771

ORA-36198: (XSAGGR33) The AGGREGATE operator string does not require a weight, but ARGS variable workspace object specified %4p as a weight.

1 2620

ORA-36200: (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.

1 2840

ORA-36202: (XSAGOP01) 'number' is not a valid aggregation operator.

1 2982

ORA-36204: (XSAGOP04N) In AGGMAP workspace object, the NAOPERATOR string must be HFIRST, HLAST or HEVEN.

1 2985

ORA-36206: (XSAGOP04R) In AGGMAP workspace object, REMOPERATOR string must be MIN, MAX, FIRST, LAST, HFIRST or HLAST.

1 2926

Un-Answered Questions { Database Errors }

What is Mutex error in Triggers?

3006

what is the instrument that used in Mechanical Energy??

2632

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

1909

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2579

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

2696

2553

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

1573

NZE-28890: Entrust Login Failed

1818

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3110

How will you Handle Error in SQL SERVER 2008?

2352

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2499

ORA-26084: direct path context already finished

1888

hp asking for replication floppy to do reinstall 25254 server assistant

2828

mount: mount to NFS server failed: System Error: Connection timed out

3633

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2405

For More Un-Answered { Database Errors } Questions Click Here