| 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..  |
| 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  |
| Sainathreddy |
| |
| |
| Answer | virus means veary importemt resource under seize tit is a
program written by some one which makes ur system corrupt  |
| 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
 |
| 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  |
| 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  |
| 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  |
| 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.  |
| Neeraj Jha |
| |
| |
| Answer | sys admin is the only authorized one can drop or alter the
table , others can't make any changes.  |
| Sandeep |
| |
| |
| Answer | Cause: An attempt was made to drop a column from a system
table.
Action: This action is not allowed  |
| Chandu |
| |
| |
| Answer | Does not commit your changes, because this table is SYS
schema's table  |
| Soosairaj |
| |
| |
| Answer | Dont have the permission to midify the Database Object  |
| 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  |
| 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  |
| 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  |
| 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  |
| 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  |
| Guest |
| |
| |
|
| |
|
Back to Questions Page |