Re: How to check/show long SQL statement?

2002-11-20 Thread Sakthi , Raj
e e-mail viruses. Get 2 months > FREE*. > http://join.msn.com/?page=features/virus > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: dist cash > INET: [EMAIL PROTECTED] > > Fat C

Re: How to check/show long SQL statement?

2002-11-20 Thread Sakthi , Raj
subscribing). ______ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

RE: converting to the cost based optimizer

2002-11-20 Thread Sakthi , Raj
> (like subscribing). > > = > Connor McDonald > http://www.oracledba.co.uk > http://www.oaktable.net > > "GIVE a man a fish and he will eat for a day. But > TEACH him how to fish, and...he will sit in a boat > and drink beer all day" > > _

Re: Partitioning

2002-11-19 Thread Sakthi , Raj
ed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http:

Re: V9.2 & SGA

2002-06-24 Thread Sakthi , Raj
CT 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).

REPLICATION QUESTION - LOng and strange

2002-06-23 Thread Sakthi , Raj
Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Int

Re: Combine 2 fields into single field using sql loader

2002-06-23 Thread Sakthi , Raj
subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Service

Re: SEQ#, DUAL and Oracle literacy

2002-06-23 Thread Sakthi , Raj
g list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the o

Re: Urgent - Query Optimization

2002-06-21 Thread Sakthi , Raj
ailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L

Re: SEQ#, DUAL and Oracle literacy

2002-06-21 Thread Sakthi , Raj
gt; > > > Author: Khedr, Waleed > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- (858) 538-5051 > FAX: > > > > (858) 538-5051 > > > > San Diego, California-- Public > Internet > > >

RE: SEQ#, DUAL and Oracle literacy

2002-06-20 Thread Sakthi , Raj
is mailing list, send an > E-Mail 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 c

Re: so when did you switch from NT to unix for oracle

2002-05-24 Thread Sakthi , Raj
blic Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB >

RE: Currval and buffer gets

2002-04-24 Thread Sakthi , Raj
; > > > Hello Gaja > > > > > > > > > > > > I could not find x$dual. Did select on > > all_objects > > > > > > got zip. > > > > > > Oracle 8.1.6.3.4 on NT. > > > > > > > > > > > &g

Re: WHICH UNIX FOR ORACLE?

2002-04-05 Thread Sakthi , Raj
quot; > > <[EMAIL PROTECTED]> wrote: > > > We are searching about which unix is best ? > > > We will apply 9ias and 8.1.7 DB . plus Oracle > > > Portal. > > > Can you direct me to a link for c

Re: ORA-27072/HP-UX file too large

2002-04-05 Thread Sakthi , Raj
AX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an &

Re: WHICH UNIX FOR ORACLE?

2002-04-04 Thread Sakthi , Raj
ther > > options .. > > Thank you ... > > > > > > Bunyamin K. Karadeniz > > Oracle DBA / Developer > > Civilian IT Department > > Havelsan A.S. Eskisehir yolu > > 7.km Ankara Turkey > > Phone: +90 312 2873565 / 1217 > > Mobile : +90 535 3357729 > > > > The degree of normality i

RE: WHICH UNIX FOR ORACLE?

2002-04-04 Thread Sakthi , Raj
time, and have not had H/w > based difficulties running > them. And still managed 6 Solaris boxes at the same > time and had major > headaches with the H/W... > > YMMV! > > > -Original Message- > > From: Sakthi , Raj [mailto:[EMAIL PROTECTED]] > >

Re: WHICH UNIX FOR ORACLE?

2002-04-04 Thread Sakthi , Raj
__ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5

Re: ORA-27072/HP-UX file too large

2002-04-04 Thread Sakthi , Raj
'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). __

Re: ORA-00600 error

2002-04-03 Thread Sakthi , Raj
s > about this message, contact [EMAIL PROTECTED] > for clarification. > > ATTACHMENT part 4 image/gif name=tech.gif __ Do You Yahoo!? Yahoo! Tax Center - online filing with Turbo

RE: RE: License standby database?

2002-04-03 Thread Sakthi , Raj
- Public Internet > > access / Mailing Lists > > > ---- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTE

RE: RE: License standby database?

2002-04-03 Thread Sakthi , Raj
ODY, 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). _

RE: 32-bit vs. 64-bit on HP-UX 11.0

2002-04-01 Thread Sakthi , Raj
ternet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include

RE: bulk collect in 9i

2002-03-27 Thread Sakthi , Raj
; Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an >

RE: .dbf is a valid name for a datafile name?

2002-03-26 Thread Sakthi , Raj
ee the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: EXPORT FAST?

2002-03-26 Thread Sakthi , Raj
> (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.co

RE: RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-26 Thread Sakthi , Raj
own, then are you expecting > the other sites to share > the >> load or you have the closest site in take in > all the load...? > Yes > __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/

RE: .dbf is a valid name for a datafile name?

2002-03-26 Thread Sakthi , Raj
> 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). __

RE: RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-26 Thread Sakthi , Raj
oreground or > background now, but I > don't think the > database can be open read-only at the same time > while doing managed > recovery, even in > 9i. > __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards

RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread Sakthi , Raj
reeman, Robert > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists >

Re: "undocumented" initSID.ora parameter

2002-03-25 Thread Sakthi , Raj
nt to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: I've got that sinking feeling...

2002-03-25 Thread Sakthi , Raj
RACLE-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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.

Re: Deadlock issues in 8.1.7.2

2002-03-25 Thread Sakthi , Raj
e > 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 sub

RE: Load Testing Help Needed

2002-03-22 Thread Sakthi , Raj
essage > 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

Re: testtttttttttststststst

2002-03-19 Thread Sakthi , Raj
ntaining: 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). __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage

RE: Fav. Urban Legend... Hot vs Cold

2002-03-18 Thread Sakthi , Raj
> > > > (Btw, the previous recovery scenario was on 7.3.4 > - things could have > > changed since, and I have not been able to test > that out...) > > > > > > John Kanagaraj > > Oracle Applications DBA > > DBSoft Inc

Re: Fav. Urban Legend...

2002-03-13 Thread Sakthi , Raj
official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---

Re: NYOUG

2002-03-11 Thread Sakthi , Raj
; Loney, Rich > Niemiec, John Beresniewicz, Douglas Scherer, Gaja > Krishna Vaidyanatha, > Ulka Rodgers, Paul Dorsey (I don't think I've left > anyone out, this is > from memory!) > > check the website... www.nyoug.org > > > --- "Sakthi , Raj" <

NYOUG

2002-03-11 Thread Sakthi , Raj
Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

RE: Unix shell Question

2002-03-05 Thread Sakthi , Raj
://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: max_io_size

2002-01-18 Thread Sakthi , Raj
> 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 subscribi

Re: Exporting thru a pipe

2002-01-10 Thread Sakthi , Raj
also send the HELP command for other information > (like subscribing). ______________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://w

Re: _system_trig_enabled=false question

2002-01-08 Thread Sakthi , Raj
st you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see th

RE: Shared pool wait for library cache pin

2002-01-07 Thread Sakthi , Raj
ease check matastink for bug no. 2155947. This bug seems to be on HP-UX platforms. HTH Cheers, RS __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.oraf

REMOTE USER CREATION

2001-12-07 Thread Sakthi , Raj
eciated. TIA Cheers, RS __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-

REMOTE USER CREATION

2001-12-06 Thread Sakthi , Raj
FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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 th

RE: Next extent problem

2001-11-14 Thread Sakthi , Raj
g 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

RE: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Descrip

2001-11-13 Thread Sakthi , Raj
s.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---

RE: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Descrip

2001-11-13 Thread Sakthi , Raj
up again...and I agree it's > a great place to live. > __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET

RE: Another Oracle DBA gets "The Bullet" in the - Sorry little long winded

2001-11-09 Thread Sakthi , Raj
ob to > a guy. 2. You would be > left free to attend to your production tasks. > > __________ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: S

RE: Another Oracle DBA gets "The Bullet" in the UK - Seeking an O

2001-11-09 Thread Sakthi , Raj
t;duhvelopers" > (even if they are duhveloping with half a brain!) > > Randy Kirkpatrick > > > -Original Message- > From: Sakthi , Raj [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, November 08, 2001 10:25 AM > To: Multiple recipients of list ORACLE-L > Subjec

Re: Base table of materialized views

2001-11-02 Thread Sakthi , Raj
he 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). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com --

RE: EMC BCV Splits and Hot Backup mode.

2001-09-24 Thread Sakthi , Raj
You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.ora

QUESTION ON RESTRICTING BULK COLLECT

2001-09-24 Thread Sakthi , Raj
Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services--

Re: Determining Oracle status

2001-09-18 Thread Sakthi , Raj
[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 subscri

RE: When optimizer reevaluate SQL statement

2001-09-14 Thread Sakthi , Raj
ou may > > also send the HELP command for other information > > (like subscribing). > > > = > Gaja Krishna Vaidyanatha > Director, Storage Management Products, > Quest Software, Inc. > Co-author - Oracle Performance T

RE: Applying Patchsets ? Learn This Parameter _SYSTEM_TRIG_ENABL

2001-08-06 Thread Sakthi , Raj
: http://www.orafaq.com -- Author: Sakthi , Raj 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

Re: Need opinion on storage and backup solutions.

2001-08-03 Thread Sakthi , Raj
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). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Y

RE: OT about to peeve off the vegatarians: RE: OT RE: Largest

2001-08-01 Thread Sakthi , Raj
ernational calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

Re: NOARCHIVELOG, ONLINE redolog corrupted - solved

2001-08-01 Thread Sakthi , Raj
t; 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 th

RE: How to know Oracle Down ?

2001-07-31 Thread Sakthi , Raj
__ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: How to know Oracle Down ?

2001-07-31 Thread Sakthi , Raj
Verify Instance internal state " fi fi rm $CHECK_CONNECT rm $READY *** END *** Hope this helps , Cheers, RS __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.

Re: Semaphores

2001-07-12 Thread Sakthi , Raj
(like subscribing). with sizes __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat Cit

RE: Second RBS in system tablespace

2001-07-12 Thread Sakthi , Raj
> access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message B

Re: Unusable indexes : why ?

2001-07-11 Thread Sakthi , Raj
___ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Califo

Re: Oracle support phone number

2001-07-09 Thread Sakthi , Raj
ses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Sizing a new server

2001-07-09 Thread Sakthi , Raj
eading the message and opening any > attachments, the recipient accepts > > full responsibility for taking protective and > remedial action about > > viruses and other defects. Cendant Corporation or > Affiliates are not > > liable for any loss or damage arising in any way >

Re: shmmax vs. SGA

2001-05-29 Thread Sakthi , Raj
LP command for other information > (like subscribing). ______ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the offici

RE-ENGINEERING OF TABLESPACES

2001-05-24 Thread Sakthi , Raj
trimspool on spool cre_tbs.sql select Text from TSPACE_TEMP order by Tspace_Name, Lineno / spool off set term on prompt OUTPUT SPOOLED TO cre_tbs.sql ** END OF SCRIPT. Regards, RS