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-36958: (XSFCAST26) The OFFSET value for cycle number cannot be greater than the cycle's PERIODICITY, which is number. You specified number.

1 2600

ORA-36960: (XSFCAST27) The value of the string expression must be an odd number. You specified number.

1 2837

ORA-36961: Oracle OLAP is not available.

1 6920

ORA-36962: (XSRELTBL08) string is not a valid qualified data reference for dimension workspace object.

1 3217

ORA-36964: (XSRELTBL09) workspace object is not a valid level relation.

1 2656

ORA-36966: (XSRELTBL10) workspace object must be a dimension.

1 3198

ORA-36968: (XSRELTBL11) workspace object must be a relation.

1 2745

ORA-36970: (XSRELTBL12) workspace object must be a self-relation.

1 3048

ORA-36972: (XSRELTBL13) Relation workspace object must be dimensioned by workspace object.

1 3227

ORA-36976: (XSRELGID00) The format of the GROUPINGID command is: GROUPINGID [relation1] INTO {variable | relation2 | surrogate} [USING levelrelation] [INHIERARCHY {inhvariable | valueset}] [LEVELORDER levelordervs] The source relation can be omitted only when using both surrogate gid and level order valueset.

1 3014

ORA-36978: (XSRELGID01) workspace object must be a self-relation.

1 2875

ORA-36980: (XSRELGID02) Variable workspace object must have a numeric data type.

1 2705

ORA-36982: (XSRELGID03) The grouping variable/relation workspace object must be dimensioned by all dimensions of the source relation workspace object which have more than one element in status.

1 3143

ORA-36984: (XSRELGID04) A value cannot be inserted into dimension workspace object.

1 2864

ORA-36986: (XSRELGID05) Relation workspace object must be dimensioned by workspace object.

1 2738

Un-Answered Questions { Database Errors }

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

1958

mount: mount to NFS server failed: System Error: Connection timed out

3668

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

1710

ORA-26084: direct path context already finished

1949

write a database figure to implement the master detained relationship.

2936

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

2410

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

1683

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

1620

ORA-26027: unique index string.string partition string initially in unusable state

6747

ORA-26095: unprocessed stream data exists

3578

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

3993

IMP-00064: Definition of LOB was truncated by export

6415

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

2733

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

What is the use of NOLOCK locking hint?

1788

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