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-14298: LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

1 3128

ORA-14299: total number of partitions/subpartitions exceeds the limit of 65535

1 3840

ORA-14301: table-level attributes must be specified before partition-level attributes

1 3312

ORA-14302: only one list of added-LOB-storage-clauses can be specified in a statement

1 2759

ORA-14303: partitions or subpartitions are not in the right order

1 3399

ORA-14304: List partitioning method expects a single partitioning column

1 4911

ORA-14305: List value 'string' specified twice in partition 'string'

1 3099

ORA-14306: List value 'string' specified twice in partitions 'string', 'string'

1 3919

ORA-14307: partition contains too many list values

2 3526

ORA-14308: partition bound element must be one of: string, datetime or interval literal, number, or NULL

1 5677

ORA-14309: Total count of list values exceeds maximum allowed

1 3072

ORA-14310: VALUES LESS THAN or AT clause cannot be used with List partitioned tables

1 9854

ORA-14311: Expecting VALUES LESS THAN or AT clause

1 9403

ORA-14312: Value string already exists in partition string

1 8573

ORA-14313: Value string does not exist in partition string

1 5080

Un-Answered Questions { Database Errors }

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

2807

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

2110

what is the instrument that used in Mechanical Energy??

2684

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

1970

[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

2733

hp asking for replication floppy to do reinstall 25254 server assistant

2886

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.

2871

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

2707

What is SCD (Slowly Changing Dimensions)? What are its types?

2668

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

1958

NZE-28868: Peer certificate chain check failed.

2803

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6659

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

2658

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3177

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

2733

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