ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories >> ERRORS >> Database-Errors
 
  Oracle-Errors (16375)  SQLServer-Errors (5)  MySQL-Errors (1)
 


 

Back to Questions Page
 
Question
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

Rank Answer Posted By  
 Question Submitted By :: Hasib
I also faced this Question!!   © ALL Interview .com
Answer
i think is your system operating system firewall is on.so 
you off the firewall.
 And  if in ur system installed any antivirus softwares 
then u check antivirus firewall is off.

 first u check oracle client database is connecting is 
correct  through network. 

above the process do to server and client systems. ok..
 
0
Balaji
 
 
Question
what is meant by write off and write on in sap?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   Wipro , Reliance Communications
I also faced this Question!!   © ALL Interview .com
Answer
virus means very important resource under seize
it is a programm written by some one which makes ur system 
corrupt
 
0
Sainathreddy
 
 
Answer
virus means veary importemt resource under seize tit is a 
program written by some one which makes ur system corrupt
 
0
Suren
 
 
 
Question
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'
Rank Answer Posted By  
 Question Submitted By :: Aparna
I also faced this Question!!   © ALL Interview .com
Answer
insert into abc.tablename(select * from xyz)here xyz is
database1 abc is tempory database but here u select database
is xyz then only this query is excuted if u any doubt mail
me yhis is my mail id laxmanit08@gmail.com 
any query u wnt just send a msg ok bye tc



laxman
 
0
Laxman
 
 
Question
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?
Rank Answer Posted By  
 Question Submitted By :: Yashu
I also faced this Question!!   © ALL Interview .com
Answer
CREATE TABLE Sample
(
Col1 varchar(5)
)
insert into Sample values('j')

TABLE:
Col1
j
r
c
r
e
f
g
h
x
j

USING CURSOR: ANSWER

DECLARE @COL1 VARCHAR(5)
DECLARE @COUNT VARCHAR(5)
SET @COUNT=0
DECLARE c1 CURSOR
FOR
SELECT COL1 FROM SAMPLE
OPEN C1
FETCH NEXT FROM C1
INTO @COL1
WHILE @@FETCH_STATUS=0
BEGIN
SET @COUNT=@COUNT+1
IF @COUNT>=5
BEGIN
SELECT @COL1
END
FETCH NEXT FROM C1
INTO @COL1
END
CLOSE C1
DEALLOCATE C1
 
0
Thiyagaraj.ramaswamy
 
 
Answer
create table empmaster(ename  varchar(34))

insert into empmaster values('r')

select * from empmaster

Query: 

select top 6 (ename) from empmaster order by ename desc
 
0
Rangaraj
 
 
Answer
select * from table_name limit 6;
above query is wrkg in mysql 
ex;
select * from emp limit 6;
this one is upto 6
u want 10 limit 10 ;
thts ur choice

select * from emp columnname limit 6;
ok
 
0
Laxman
 
 
Question
give full details of this ORA-12988: cannot drop column 
from table owned by SYS
Rank Answer Posted By  
 Question Submitted By :: Saswata
This Interview Question Asked @   Oracle
I also faced this Question!!   © ALL Interview .com
Answer
If this is the only error message, you should stop trying to
modify a system table (table owned by sys), as this is not
allowed.
 
0
Neeraj Jha
 
 
Answer
sys admin is the only authorized one can drop or alter the 
table , others can't make any changes.
 
0
Sandeep
 
 
Answer
Cause:  An attempt was made to drop a column from a system
table.
Action: This action is not allowed
 
0
Chandu
 
 
Answer
Does not commit your changes, because this table is SYS 
schema's table
 
0
Soosairaj
 
 
Answer
Dont have the permission to midify the Database Object
 
3
Bhupesh
 
 
Question
LPX-00212: comment must not contain "--"
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
Cause: A syntax error was detected in the comment.

Action: Use '--' only when specifying the end of the comment.

Please add more information about this Error
 
0
Guest
 
 
Question
LPX-00211: attribute default must be REQUIRED, IMPLIED, or FIXED
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
Cause: Attribute default was invalid.

Action: Default must be REQUIRED, IMPLIED, or FIXED.

Please add more information about this Error
 
0
Guest
 
 
Question
LPX-00210: expected '~1c' instead of '~2c'
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
Cause: A syntax error was detected.

Action: Use proper syntax.

Please add more information about this Error
 
0
Guest
 
 
Question
LPX-00209: PI names starting with XML are reserved
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
Cause: Processing instruction starting with XML was found.

Action: Use another name for the processing instruction.

Please add more information about this Error
 
0
Guest
 
 
Question
LPX-00208: unknown DTD keyword "~s"
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
Cause: An unknown keyword was found in the DTD.

Action: Use a proper keyword.

Please add more information about this Error
 
0
Guest
 
 
 
Back to Questions Page
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com