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-01678: parameter string must be pairs of pattern and replacement strings

1 7196

ORA-01679: database must be mounted EXCLUSIVE and not open to activate

1 3758

ORA-01680: unable to extend LOB segment by string in tablespace string

1 3444

ORA-01681: max # extents (string) reached in LOB segment in tablespace string

1 3418

ORA-01682: read-only DB cannot allocate temporary space in tablespace string

1 4238

ORA-01683: unable to extend index string.string partition string by string in tablespace string

1 8036

ORA-01684: max # extents (string) reached in table string.string partition string

1 3735

ORA-01685: max # extents (string) reached in index string.string partition string

1 3551

ORA-01686: max # files (string) reached for the tablespace string

1 7429

ORA-01687: specified logging attribute for tablespace 'string' is same as the existing

1 4134

ORA-01688: unable to extend table string.string partition string by string in tablespace string

1 8697

ORA-01689: syntax error in clause "string" of string

1 3336

ORA-01690: sort area size too small

1 9774

ORA-01691: unable to extend lob segment string.string by string in tablespace string

1 5868

ORA-01692: unable to extend lob segment string.string partition string by string in tablespace string

1 7181

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

2868

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

2300

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

2006

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

1671

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

2716

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

3229

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2856

ORA-16626: failed to enable specified object

2278

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

6722

What is the use of NOLOCK locking hint?

1837

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

2787

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

1823

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2768

ORA-26095: unprocessed stream data exists

3642

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

8883

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