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-37100: (XSUNCOMMITTED) You have one or more updated but uncommitted analytic workspaces.

1 2794

ORA-37101: (XSVPART01) Partitioning information can only be given for variables dimensioned by a PARTITION TEMPLATE.

1 2821

ORA-37102: (XSVPART02) Invalid partition name string.

1 2889

ORA-37103: (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.

1 2976

ORA-37104: (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.

1 3175

ORA-37105: (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions.

1 2877

ORA-37106: (XSVPART06) Invalid partition name number.

1 3191

ORA-37107: (XSVPART07) Attempt to write to non-existent partition of workspace object.

1 3381

ORA-37111: Unable to load the OLAP API sharable library: (string)

1 3838

ORA-37112: OLAP API requires Oracle 9.2 or later

1 3042

ORA-37113: OLAP API initialization error: (string)

1 3122

ORA-37114: OLAP API bootstrap error: (string)

1 3128

ORA-37115: New OLAP API history is not allowed

1 3150

ORA-37116: OLAP API table function error: (string)

1 3116

ORA-37117: olapi history retention has been disabled

1 3102

Un-Answered Questions { Database Errors }

What is Mutex error in Triggers?

3117

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

2577

ORA-16626: failed to enable specified object

2272

What is the use of NOLOCK locking hint?

1831

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

3435

ORA-26032: index string.string loading aborted after string keys

2176

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.

2571

[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

2772

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

2751

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

1728

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

2465

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

1986

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.

2945

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

2517

ORA-26084: direct path context already finished

1994

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