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-30023: Duplicate undo tablespace specification

1 4365

ORA-30024: Invalid specification for CREATE UNDO TABLESPACE

1 5955

ORA-30025: DROP segment 'string' (in undo tablespace) not allowed

1 10061

ORA-30026: Undo tablespace 'string' has unexpired undo with string(sec) left, Undo_Retention=string(sec)

1 3625

ORA-30027: Undo quota violation - failed to get string (bytes)

1 8401

ORA-30029: no active undo tablespace assigned to instance

1 3234

ORA-30030: suppress resumable related error message

1 3057

ORA-30031: the suspended (resumable) statement has been aborted

1 7947

ORA-30032: the suspended (resumable) statement has timed out

1 10911

ORA-30033: Undo tablespace cannot be specified as default user tablespace

1 5936

ORA-30034: Undo tablespace cannot be specified as temporary tablespace

1 3422

ORA-30035: Undo tablespace cannot be specified as default temporary tablespace

1 3275

ORA-30036: unable to extend segment by string in undo tablespace 'string'

1 4735

ORA-30037: Cannot perform parallel DML after a prior DML on the object

1 3212

ORA-30038: Cannot perform parallel insert on non-partitioned object

1 3159

Un-Answered Questions { Database Errors }

write a database figure to implement the master detained relationship.

2957

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

2818

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

1962

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

6671

ORA-26029: index string.string partition string initially in unusable state

2167

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

1951

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

2752

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

2532

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

1629

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

1695

How to view the error log for any specific instance?

2496

ORA-26094: stream format error: input column overflow

2825

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2260

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

2120

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1673

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