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-01307: no LogMiner session is currently active

1 5054

ORA-01308: initialization parameter utl_file_dir is not set

2 12416

ORA-01309: invalid session

1 4534

ORA-01310: requested return type not supported by the lcr_mine function

1 3685

ORA-01311: Illegal invocation of the mine_value function

1 2835

ORA-01312: Specified table/column does not exist

1 3010

ORA-01313: LogMiner dictionary column type different from specified type

1 3110

ORA-01314: Name of the column to be mined should be a string literal

1 3207

ORA-01315: Log file has been added or removed during select

1 3728

ORA-01316: Already attached to a Logminer session

1 3650

ORA-01317: Not attached to a Logminer session

1 2992

ORA-01319: Invalid Logminer session attribute

1 3065

ORA-01320: Invalid Logminer dictionar attribute

1 2972

ORA-01322: No such table

1 2953

ORA-01323: Invalid state

1 3410

Un-Answered Questions { Database Errors }

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

2792

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

1994

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

2016

How to view the error log for any specific instance?

2548

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

2037

ORA-26082: load of overlapping segments on table string.string is not allowed

1830

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

1740

What is live lock, deadlock and what is Lock escalation?

2506

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

6725

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2868

NZE-28890: Entrust Login Failed

1943

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

2264

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

2476

What is the use of NOLOCK locking hint?

1837

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2703

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