Database Errors Interview Questions
Questions Answers Views Company eMail

LPX-00208: unknown DTD keyword "~s"

1 2896

LPX-00209: PI names starting with XML are reserved

1 11001

LPX-00210: expected '~1c' instead of '~2c'

1 4679

LPX-00211: attribute default must be REQUIRED, IMPLIED, or FIXED

1 2830

LPX-00212: comment must not contain "--"

1 3804

give full details of this ORA-12988: cannot drop column from table owned by SYS

Oracle,

8 19189

In one table there is 10 records without id num,without primary key and it is not sorted then how to extract last 6 record from table?

4 7422

Trying to transfer data from Prod region to Test region.So,exporting data from Prod table(e.g xyz in prod) into a temporary table(e.g abc) and then inserting into Test table(e.g xyz in prod),but not able to insert data from one db2 table to another,the error coming out is 'foreign key vaue is not valid'

1 3975

what is meant by write off and write on in sap?

Reliance Communications, Wipro,

5 10582

I've got a database (Oracle Database 10g Enterprise Edition Release 10.2.0.2.0) installed on a server. Via the network I try to connect to the database via a frontend DEVELOPER 2000 R 2.1 (SQL*Plus: Release 3.3.4.0.0 ) while connecting to database I've got the following error- message: ORA-12637: Packet receive failed

2 4931

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.

Investment Bank,

2367

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

HCL,

6239

ORA-13601 encountered when generating server alert SMG-3503

DB Experts,

11660

imp-00038: could not convert to environment character set's handle error occurs while importing oracle 10g data into oracle 9i database.

1 19159

I am experiencing an error failed to retrieve data from data base. it is an oracle table. Is there a limit on the number of fields that can be a report. My table has 321 fields and I do not have all of them in the report yet.

1 4472


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

2330


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

8092


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

1249


When do you get "getwmicomexception"?

2274


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

1662






NZE-28868: Peer certificate chain check failed.

2275


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.

2337


Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2147


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

2177


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.

1094


What severity level errors are managed in TRY-CATCH block?

1800


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

1873


ORA-26095: unprocessed stream data exists

2824


ORA-26094: stream format error: input column overflow

2264


ORA-16627: No standby databases support the overall protection mode.

3565