Oracle Errors Interview Questions
Questions Answers Views Company eMail

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

1 2178

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 2234

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

1 2159

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

1 2256

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

1 2899

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

1 2346

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

1 1868

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

1 2810

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

1 2241

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 2101

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

1 2042

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

1 2250

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

1 2401

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

1 2283

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

1 2210


Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

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

2315


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

2319


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?

2308


NZE-28890: Entrust Login Failed

1409


ORA-26095: unprocessed stream data exists

2803






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

1559


ORA-26094: stream format error: input column overflow

2252


IMP-00064: Definition of LOB was truncated by export

5886


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

1520


ORA-26084: direct path context already finished

1483


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

2232


ORA-16626: failed to enable specified object

1771


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

2859


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.

2327


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

3556