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-37023: (XSMLTUPD01) Object workspace object cannot be updated without dimension workspace object.

1 2762

ORA-37026: (XSMLTRESYNC01) Object workspace object cannot be resynced without dimension workspace object.

1 2540

ORA-37027: (XSMLTRESYNC02) Object workspace object cannot be resynced without modified object workspace object because they share a modified composite dimension.

1 3430

ORA-37028: (XSMLTRESYNC03) Object workspace object cannot be resynced without modified object workspace object because they share a modified dimension map.

1 3075

ORA-37030: (XSMLTMAINT01) You cannot maintain workspace object because it is not ACQUIRED.

1 2533

ORA-37031: (XSMLTMAINT02) You cannot MOVE, DELETE, or add SESSION values of dimension workspace object in MULTI mode.

1 3004

ORA-37032: (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.

1 3103

ORA-37035: (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.

1 3186

ORA-37040: (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.

1 2733

ORA-37041: (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.

1 3133

ORA-37042: (XSACQUIRE_DEP_DEADLOCK) Cannot wait to acquire composite, concat, dimension map, or internal partition workspace object since doing so would cause a deadlock.

1 2884

ORA-37043: (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.

1 2885

ORA-37044: (XSACQUIRE_OLDGEN) Cannot acquire object workspace object without resync.

1 2546

ORA-37060: (XSMCSESS08) number is not a valid custom member in dimension workspace object.

1 2704

ORA-37070: You may not execute OLAP DML programs in a parallel query session.

1 3086

Un-Answered Questions { Database Errors }

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

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2849

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

2176

ORA-26084: direct path context already finished

1994

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

1664

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

3910

ORA-26094: stream format error: input column overflow

2853

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2253

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

hp asking for replication floppy to do reinstall 25254 server assistant

2960

IMP-00064: Definition of LOB was truncated by export

6465

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

2030

what is the instrument that used in Mechanical Energy??

2732

When do you get "getwmicomexception"?

2731

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

2705

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