RE: Correlated subquery performance in 8i 9i

2002-09-09 Thread BALA,PRAKASH (Non-HP-USA,ex1)
PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of BALA,PRAKASH (Non-HP-USA,ex1) Sent: Thursday, September 05, 2002 2:12 PM To: Multiple recipients of list ORACLE-L Subject: Correlated subquery performance in 8i 9i Learnt the following from Gaja's seminar last week. So just wanted to pass

RE: couple of questions ???

2002-09-06 Thread BALA,PRAKASH (Non-HP-USA,ex1)
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: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Must Read for Every Developer and DBA

2002-09-06 Thread BALA,PRAKASH (Non-HP-USA,ex1)
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Correlated subquery performance in 8i 9i

2002-09-05 Thread BALA,PRAKASH (Non-HP-USA,ex1)
a correlated subquery. HTH! Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

ORA-01918: user 'SYSTEM' does not exist

2002-09-04 Thread BALA,PRAKASH (Non-HP-USA,ex1)
Title: Message Hello, Oracle 8.1.7.4 on HP-UX 11.0 A colleague of mine upgraded this database from 8.1.6 to 8.1.7.4. Now when I tried to change system's password, I get the aboveerror. To add to it, when I try to do a full export, I get 'Abort(coredump)' I can login as sys but not as

RE: How do I check whether a rollback activity is going on

2002-07-16 Thread BALA,PRAKASH (Non-HP-USA,ex1)
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: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City

RE: 1 Volume of Software RAID 1+0 versus Multiple Volumes of Sof

2002-07-11 Thread BALA,PRAKASH (Non-HP-USA,ex1)
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Oracle Warehouse Builder

2002-07-11 Thread BALA,PRAKASH (Non-HP-USA,ex1)
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Dba_tab_modifications question

2002-05-16 Thread BALA,PRAKASH (Non-HP-USA,ex1)
(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: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services

RE: Dba_tab_modifications question

2002-05-16 Thread BALA,PRAKASH (Non-HP-USA,ex1)
: http://www.orafaq.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Dba_tab_modifications question

2002-05-15 Thread BALA,PRAKASH (Non-HP-USA,ex1)
://www.orafaq.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) 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: Dba_tab_modifications question

2002-05-15 Thread BALA,PRAKASH (Non-HP-USA,ex1)
in dba_tab_modifications. Does this mean that I cannot rely on dba_tab_modifications? TIA Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Accessing tables through synonyms

2002-05-13 Thread BALA,PRAKASH (Non-HP-USA,ex1)
way? Thanks in advance, Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: executing a stored procedure at a certain time

2002-04-19 Thread BALA,PRAKASH (Non-HP-USA,ex1)
Title: executing a stored procedure at a certain time Check out Oracle jobs (dbms_jobs package). It's pretty easy. Prakash -Original Message-From: Nelson Flores [mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 3:53 PMTo: Multiple recipients of list ORACLE-LSubject:

RE: Donald Burleson

2002-04-18 Thread BALA,PRAKASH (Non-HP-USA,ex1)
may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Package/Procedure

2002-04-16 Thread BALA,PRAKASH (Non-HP-USA,ex1)
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: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network