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

Oracle Errors Interview Questions

Questions Answers Views Company eMail

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

1 2930

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 2912

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

1 2797

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

1 3062

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

1 3601

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

1 3084

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

1 2567

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

1 3457

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

1 3018

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 2855

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

1 2693

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

1 2953

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

1 3076

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

1 3085

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

1 3038

Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

ORA-26084: direct path context already finished

1949

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

3993

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

1970

NZE-28868: Peer certificate chain check failed.

2803

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2733

NZE-28890: Entrust Login Failed

1882

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

2233

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

1620

ORA-16626: failed to enable specified object

2218

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

1958

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

2410

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

1710

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.

2870

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

1941

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

2155

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