RE: Rollback segment full

clude a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED] Fa

RE: will the Return Order of rows change with time ?

nd can be combined with "where rownum < 100" to return the earliest 100 rows without even reading more than 100 rows from the table - a cute trick. hth, Mark. "Ratnesh Kumar Singh"

RE: will the Return Order of rows change with time ?

en execute my query,will the Order of rows returned be the same as before the rebuild ? any explanations are most welcome many thanks ratnesh singh --------- Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Wo

will the Return Order of rows change with time ?

thanks ratnesh singh --------- Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Work : (91 22) 7611090/110/128/350 Ext. 2107/2106 Home : (91 22) 8662162 http://www.patni.com World-Wide Partnerships. W

RE: Idle Connections

how about setting the parameter sqlnet.expire_time=10 in the sqlnet.ora file ? ( the figure 10 is in minutes ) --- Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Work : (91 22) 7611090/110/128/350 Ext

RE: db2

rafaq.com -- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this m

RE: MUST read Oracle Architecture - Abrief Intro

ail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see

RE: locking issues in web based applications

r intensive applications to be of any use. There must be other better ways of doing this. I need your suggestions. TIA, ratnesh ------- Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Work : (91 22) 7611090/11

RE: ANALYZE question

RACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --

locking issues in web based applications

need your suggestions. TIA, ratnesh ------- Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Work : (91 22) 7611090/110/128/350 Ext. 2107 Home : (91 22) 8662162 http://www.patni.com World-Wide Partnerships. World-Class

RE: Sequence number generation

ou may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: RE: dblink problem ( ORA-02019)

ora or "alter system" after db startup does not seem likely. regards Ratnesh -Original Message- Sent: Tuesday, July 16, 2002 6:57 PM To: Ratnesh Kumar Singh; Multiple recipients of list ORACLE-L Folks, Since I recently slammed into this unexpected wall I'll pass along the

RE: dblink problem ( ORA-02019 )

fine. I have compared the entries in init,sqlnet,tnsnmames,listener files on both A & B databases and they are absolutely similar . i was thinking that the domain or globalnames parameters might be diff on A & B , but they are absolutely same . any suggestions are most welcome ... thanks i

RE: dblink problem ( ORA-02019 )

bases and they are absolutely similar . i was thinking that the domain or globalnames parameters might be diff on A & B , but they are absolutely same . any suggestions are most welcome ... thanks in advance ratnesh --- Ratnesh Kumar Singh Sr. Softwar

dblink problem ( ORA-02019 )

s in init,sqlnet,tnsnmames,listener files on both A & B databases and they are absolutely similar . i was thinking that the domain or globalnames parameters might be diff on A & B , but they are absolutely same . any suggestions are most welcome ... thanks in advance ratnesh -------

Re: Optimizer and function based index

al ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet access > / Mailing Lists >