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-19642: incremental-start SCN is string

1 3807

ORA-19643: datafile string: incremental-start SCN is too recent

1 8095

ORA-19644: datafile string: incremental-start SCN is prior to resetlogs SCN string

1 3175

ORA-19645: datafile string: incremental-start SCN is prior to creation SCN string

1 4113

ORA-19646: cannot change size of datafile string from string to string

1 3287

ORA-19647: non-zero LEVEL cannot be specified when INCREMENTAL is FALSE

1 3293

ORA-19648: datafile string: incremental-start SCN equals checkpoint SCN

1 5063

ORA-19649: offline-range record recid string stamp string not found in file string

1 3132

ORA-19650: Offline-range record recid string stamp string in file string has SCN string

1 3304

ORA-19651: cannot apply offline-range record to datafile string: SCN mismatch

1 3313

ORA-19652: cannot apply offline-range record to datafile string: file is fuzzy

1 2801

ORA-19653: cannot switch to older file incarnation

1 6265

ORA-19654: must use backup controlfile to switch file incarnations

1 8546

ORA-19655: cannot switch to incarnation with different resetlogs data

1 3974

ORA-19656: cannot backup, copy, or delete online log string

1 3565

Un-Answered Questions { Database Errors }

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

6650

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

1704

why we are using shift key in unix shell script

3158

ORA-16516: The current state is invalid for the attempted operation.

8813

What is the use of NOLOCK locking hint?

1781

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

2210

what is new g/l functionality

2609

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

1766

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

6742

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

1674

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

2103

ORA-26095: unprocessed stream data exists

3558

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3381

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

1938

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

1962

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