RE: OT: Solaris: Finding the cause for disk space growth

2004-01-26 Thread Naveen, Nahata (IE10)
command as well. Regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen, Nahata (IE10) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

OT: Solaris: Finding the cause for disk space growth

2004-01-23 Thread Naveen, Nahata (IE10)
Title: Message Hi All,   Sorry for an OT question, but nowhere else to go. Pretty new to Solaris so might be a naive question. Need a pointer on how to do this.   The disk space in the machine is constantly decreasing. And I want to know which files/directories are growing.   Is there any way

RE: How to find the last execution time of a Procedure.

2004-01-23 Thread Naveen, Nahata (IE10)
t; -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services >

RE: another OCP question -- help me guys

2004-01-07 Thread Naveen, Nahata (IE10)
sters? :) > there are lot of OCP-busters here :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen, Nahata (IE10) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Delete vs. truncate to free up spaces.

2003-12-22 Thread Naveen, Nahata (IE10)
--- > 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 > (or the name of mailing list you want to be re

RE: Any known problems using NOT IN ?

2003-12-17 Thread Naveen, Nahata (IE10)
Doess the column crs.os_id_fk1 contain nulls?   Regards Naveen -Original Message-From: Siddharth Haldankar [mailto:[EMAIL PROTECTED]Sent: Thursday, December 18, 2003 10:54 AMTo: Multiple recipients of list ORACLE-LSubject: Any known problems using NOT IN ? Hi Gurus,

RE: Little competition

2003-12-11 Thread Naveen, Nahata (IE10)
Well, Googling this statement, one can easily find the source of this statement :-)   Naveen -Original Message-From: Richard Foote [mailto:[EMAIL PROTECTED]Sent: Thursday, December 11, 2003 5:09 PMTo: Multiple recipients of list ORACLE-LSubject: Little competition Little c

Downloading patches

2003-12-11 Thread Naveen, Nahata (IE10)
age 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 the official ORACLE-L FAQ: http://www.orafaq.net

RE: pattern search

2003-11-07 Thread Naveen, Nahata (IE10)
MAIL 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). > -- Plea

RE: ** SQL WHERE clause order

2003-11-05 Thread Naveen, Nahata (IE10)
t; :min_sal > UNION > SELECT emp_id FROM emp > WHERE :select_sen_emp_chk_first = 'N' > AND dept != :dept > AND salary < :min_sal > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen, Nahata (IE10) INET: [EMAIL PROTECT

RE: ** SQL WHERE clause order

2003-11-04 Thread Naveen, Nahata (IE10)
If the query is a part of the cursor then you can simply write the cursor query as:   SELECT    emp_id     FROM    emp    WHERE    dept = :dept AND    salary > :min_sal;   and then open the cursor only if the condition "select_sen_emp_chk_first = 'Y'" evaluates to true   e.g.   I

Oracle Apps: Single Node or Multi-node install?

2003-10-30 Thread Naveen, Nahata (IE10)
install? I know the answer is "it depends", but what are the factors I should consider in choosing between the two? Regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen, Nahata (IE10) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Oracle Apps 11i: 2 Node V/s 1 and Hardware Config

2003-10-22 Thread Naveen, Nahata (IE10)
uthor: Naveen, Nahata (IE10) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing