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-34001: (MODCOMP14) Concat leaf dimension workspace object already is used in a DIMENSION statement, either explicitly or as a leaf of another concat dimension.

1 2833

ORA-34019: (MSCGADD03) workspace object is not a LIST PARTITION TEMPLATE.

1 2985

ORA-34021: (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.

1 2652

ORA-34059: (MSEXECUT12) You cannot delete non session-only dimension values from unique concat dimension workspace object.

1 2635

ORA-34061: (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.

1 2886

ORA-34141: (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object.

1 2629

ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.

1 2884

ORA-34145: (MXCGPUT03) You cannot use the APPEND keyword with SURROGATE workspace object.

1 2852

ORA-34164: (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue.

1 2634

ORA-34177: (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it.

1 2515

ORA-34179: (MXCHGDCL20) workspace object is not a PARTITION TEMPLATE.

1 2782

ORA-34181: (MXCHGDCL21) workspace object is not a partitioned VARIABLE.

1 2624

ORA-34183: (MXCHGDCL22) Partition number already exists.

1 3338

ORA-34210: (MXCHGDCL18) You cannot change workspace object to a dimension composite because one or more surrogates has been defined for it.

1 2719

ORA-34243: (MXDCL11) You can only use the string keyword when defining a COMPOSITE.

1 3446

Un-Answered Questions { Database Errors }

ORA-26095: unprocessed stream data exists

3517

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1633

What is the meaning of lock escalation and why/how to stop this?

2608

ORA-26094: stream format error: input column overflow

2747

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

1573

NZE-28890: Entrust Login Failed

1818

ORA-26084: direct path context already finished

1888

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

3814

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.

2817

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

What severity level errors are managed in TRY-CATCH block?

2176

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2476

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

1706

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?

2674

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

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