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

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 and web hosting services

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

: 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 and web hosting services - To REMOVE

OT: Solaris: Finding the cause for disk space growth

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 knowwhich files/directories are growing. Is there any way to

RE: another OCP question -- help me guys

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 and web hosting services

RE: Delete vs. truncate to free up spaces.

). _ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://us.rd.yahoo.com/slv/mailtag/*http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen, Nahata (IE10) INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Any known problems using NOT IN ?

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,

Downloading patches

://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 and web hosting services - To REMOVE yourself from

RE: Little competition

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

RE: pattern search

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 -- Author: Naveen, Nahata (IE10) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: ** SQL WHERE clause order

-- 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 and web hosting services

RE: ** SQL WHERE clause order

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. IF select_sen_emp_chk_first =

Oracle Apps: Single Node or Multi-node install?

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-5051 http

RE: exam

: http://www.orafaq.net -- Author: Naveen Nahata 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

RE: SQL AREA and LIBARARY CACHE size?

://www.orafaq.net -- Author: Naveen Nahata 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

RE: guidance

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: SQL HELP.....

"Open the cartons and see!" ;-) By the way can you reframe your question? Do you mean that you table stores data as follows: item carton_no qty weight - --- -- A1 410 A 2 4 10 B 1 5 12 B 3 5 12 C 1 35 and so on? RegardsNaveen -Original Message-From:

RE: display x square

Title: Message When you say you want to display in Oracle do you mean SQL*PLUS??? Or are you using some other front end to display it? Regards Naveen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 3:34 PMTo: Multiple

RE: SGA

Shouldn't time_waited/100 be time_waited*100? Regards Naveen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 11:19 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SGAMitchell, Which portion of the statspack report

RE: SGA

are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Oracle DBA interview for Oracle INDIA Ltd

Hi Raju, I think it is unethical for anyone to reply to points 1-4. As far as point no. 5 is concerned, even though I don't work with Oracle India, I can get the resume forwarded, simply because if forwarded through internal sources the resume doesn't get trashed, but you won't get any

RE: Event 10235

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Event 10235

, Sorry for the misinformation. Regards Naveen -Original Message- From: Naveen Nahata Sent: Tuesday, August 12, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Event 10235 11.0.3 -Original Message- From: Tanel Poder [mailto:[EMAIL PROTECTED] Sent: Tuesday

RE: Referencing other schemas' tables in PL/SQL procedure

not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Event 10235

of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET

RE: Referencing other schemas' tables in PL/SQL procedure

are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Redo Logs Problem

This will reduce the updates and inserts to the Data-Dictionary tables since in LMTs extent information is stored locally and not in Data-Dictionary Regards Naveen -Original Message-From: RAJESH DAYAL [mailto:[EMAIL PROTECTED]Sent: Monday, August 04, 2003 11:59 AMTo:

RE: Redo Logs Problem

ORACLE-L Subject: RE: Redo Logs Problem On Sun, 3 Aug 2003, Naveen Nahata wrote: This will reduce the updates and inserts to the Data-Dictionary tables since in LMTs extent information is stored locally and not in Data-Dictionary I do not believe that there are real practical

RE: Redo Logs Problem

Redo is not effected by database configuration but by database activity. Has the no. of transactions increased significantly? If the activity is the same,a wild guess -Has someone issued a command "ALTER TABLESPACE name BEGIN BACKUP" and forgot to issue the command "ALTER TABLESPACE name

RE: Redo Logs Problem

I've Checked this in both the v$backup table and v$datafile_headers table (fuzzy column). But the v$backup table shows "Not Achive" and Fuzzy is Null. Any Other Advice. Regards Munish Bajaj -Original Message-From: Naveen Nahata [mailto:[EMAIL PROT

RE: Help me to unsubscribe

transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Upgrade of OS and upgrade of Oracle apps (11.0.3 on Windows NT)

not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: ** how to check version and problems

If you know about install.log, you should be easily able to find the version of installation from there. If no problem was reported during the installation then obviously the installation went fine. Regards Naveen -Original Message-From: A Joshi [mailto:[EMAIL

RE: Question on SGA

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle Verison Information

You can see the install log in C:\Program Files\loracle\inventory\logs\appropriate_log Check out the inventory location in solaris for similar files Regards Naveen -Original Message-From: Munish Bajaj [mailto:[EMAIL PROTECTED]Sent: Monday, June 30, 2003 6:13 PMTo: Multiple

Outer join in SQL server - A very simple question

to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Outer join in SQL server - A very simple question

Please read INSERT INTO t4 VALUES ('A', 'DD'); as INSERT INTO t4 VALUES ('', 'DD'); in my previous mail. Regards Naveen -Original Message- From: Naveen Nahata Sent: Wednesday, June 25, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: Outer join in SQL server

RE: Outer join in SQL server - A very simple question

://www.orafaq.net -- Author: Naveen Nahata 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

RE: Re: 9i OCP Details

and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Column level security

-- Author: Naveen Nahata 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 list

Development projects: Multiple databases v/s multiple schemas

and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Development projects: Multiple databases v/s multiple schemas

Title: RE: Development projects: Multiple databases v/s multiple schemas Thanx Raj and Bahar, Raj I think you misunderstood my question. Or I might be misunderstanding a part of your reply :-) I'll try to makemyquestionclearer All the developers of a project work on the same

Anyone from Australia

Sorry for the Off-Topic post. Anyone from australia please contact me personally, I need some information. Regards NaveenDISCLAIMER:This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects.

RE: World premier performance of the BAARF party logo

are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: db file sequential read [WAS:wait event puzzler]

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: db file sequential read [WAS:wait event puzzler]

or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Single Block Read

or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata

RE: db file sequential read [WAS:wait event puzzler]

are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Listener showing 2 service handlers for the same service

, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: db file sequential read [WAS:wait event puzzler]

that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: db file sequential read [WAS:wait event puzzler]

or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata

RE: RE: db file sequential read [WAS:wait event puzzler]

underlying code that you dont know about that assumes a maximum column length = 30 or there is some modelling reason for the limit also. From: Naveen Nahata [EMAIL PROTECTED] Date: 2003/06/12 Thu AM 08:49:22 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE

RE: db file sequential read [WAS:wait event puzzler]

are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: db file sequential read [WAS:wait event puzzler]

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

RE: changing optimizer_mode for a running session

of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET

Urgent: Need Oradim.exe for version 8.1.6

or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen

RE: Urgent: Need Oradim.exe for version 8.1.6

, June 12, 2003 6:09 AM To: Multiple recipients of list ORACLE-L Subject: Re: Urgent: Need Oradim.exe for version 8.1.6 Crud! Sorry, replied twice to the list when I shouldn't have. D'oh! Jared Naveen Nahata [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/11/2003 07:24 AM

RE: procedure/function error

you need to accept the return value of the function in a variable. the correct way to do is SQL var a varchar2(1000) sql execute :a := emp_sel('gali') SQL print a OR SQLdeclare SQLa varchar2(1000); SQLbegin SQLa := emp_sel('gali'); SQLDBMS_OUTPUT.PUT_LINE(a); SQLend; SQL/ Regards Naveen

RE: SQL statement problem - outer join where?

shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: cannot allocate new log -- Problem Solved

or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata

RE: How to Uninstall apps11i

ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: is this DBA's only mailing list?

I'll quote the list manager Jared's comments which he made in a mail long back "This is an Oracle mailing List" So youshould be allowed topost anything related to Oracle. Regards Naveen -Original Message-From: Ajay K. Garg [mailto:[EMAIL PROTECTED]Sent: Thursday, May 29,

RE: RE: Function Based Index - Not Used ???

or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City

RE: Function Based Index - Not Used ???

and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: is this DBA's only mailing list? THANKS

All the very best! -Original Message-From: Ajay K. Garg [mailto:[EMAIL PROTECTED]Sent: Friday, May 30, 2003 12:30 PMTo: Multiple recipients of list ORACLE-LSubject: Re: is this DBA's only mailing list? THANKS Hi Thanks to Dave, Naveen , Dennis Williams , Rich for

RE: Function Based Index - Not Used ???

. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Function Based Index - Not Used ???

Oops! didnot read your full message. try setting OPTIMIZER_INDEX_COST_ADJ with alter session to a lower value Regards Naveen -Original Message- From: Naveen Nahata Sent: Thursday, May 29, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Function Based Index

RE: skip scan index

or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata

Urgent: restore from hot backup w/o archivelogs

of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL

RE: Urgent: restore from hot backup w/o archivelogs

logs he sends over later on (yes Jeremiah I know there is a way to recover through a resetlogs but they will be doing work against the database in the interim!) but if data loss is not a problem, that's the way to go Rachel --- Naveen Nahata [EMAIL PROTECTED] wrote: I have got a set of datafiles

RE: A difficult question :)

Recreate the password file. Login using sys as sysdba with the new password and then change the password of SYSTEM user Regards Naveen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 25, 2003 11:54 AMTo: Multiple recipients of list

RE: A difficult question :)

recreate the password file. look at the orapwd utility Regards Naveen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 25, 2003 11:54 AMTo: Multiple recipients of list ORACLE-LSubject: A difficult question :)Dear All, Sounds quirky.

Restricting the size of a BLOB column

improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Test - Delete me

a small technical mistake :-) delete from "oracle-l" where subscriber = 'Gene Sais'; ^ "-" is not allowed in identifiers ;-) Regards Naveen -Original Message-From: Daniel W. Fink [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 19, 2003 11:57 PMTo: Multiple recipients of

RE: ORacle Applications mailing list

or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City

RE: A SQL Question

or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata

RE: Slow query

, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Purely for your amusement

Title: RE: Purely for your amusement More wonderful is that the users are complaining about poor performance and not of wrong data it is returning. Are the users comfortable with catesian products returned to them with meaningless data? Regards Naveen -Original Message-From:

RE: Number of joins in the query

for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: installation / recovery question

://www.orafaq.net -- Author: Naveen Nahata 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

RE: installation / recovery question

in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat

RE: Urgent - Help ....

prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: transfering data from OLTP DB to Reporting DB

note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Urgent - how to make SYSTEM tbls smaller ?

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle 9.2 installation on Pentium 4, Windows 2000 machine

improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Queries Help

of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET

RE: Queries Help

: http://www.orafaq.net -- Author: Naveen Nahata 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

RE: strange behaviour of sequence

. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: SQL Question

Try select 'insert into XXX (IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION) values ('||(IDU + 1)||','||PEN_ID||',sysdate,'||FK_APPLICATION||');' from app_users where pen_id in (44541,41402,41813); -Original Message-From: Henrik Ekenberg [EMAIL PROTECTED][mailto:[EMAIL PROTECTED]]Sent:

RE: Problem on P4 intel servers

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Slow running query

: http://www.orafaq.net -- Author: Naveen Nahata 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

RE: Dictionary location or initSID.ora and PWDsid.ora

::TieRegistry. Jared On Thursday 23 January 2003 21:43, Naveen Nahata wrote: There are avaialable in the registry with String values 'ORA_SID_PFILE' and 'ORA_SID_PWFILE' From this you can find out the directory of the Password file Regards Naveen -Original Message- Sent: Friday

RE: Date conversion

, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Dictionary location or initSID.ora and PWDsid.ora

. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Re: 100% CPU utilization, urgent

. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: 100% CPU utilization, urgent

Title: 100% CPU utilization, urgent Hussain, We have a similar environment and we also hit 100%CPU utilization at times. But we never face problem because of tht. the DB keeps working fine during 100% CPU utilization also. Are you having a problem of logging into the DB during tht time?

RE: bitmapped indexes

Title: RE: bitmapped indexes But i got the attachment. AFAIK, listguru filters attachments, How did i get it then? Regards Naveen -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 14, 2003 6:24 PMTo: Multiple recipients of list

RE: bitmapped indexes

recipients of list ORACLE-LSubject: Re: bitmapped indexes you sure, you got it? Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Naveen Nahata To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 14, 2003 8:34

RE: Some of you may find this useful

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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata

RE: Some of you may find this useful

Thanx a lot for a very comprehensive answer. More than the result, I learnt the method. thanx a lot Regards Naveen -Original Message- Sent: Sunday, January 12, 2003 9:04 PM To: Multiple recipients of list ORACLE-L Naveen Nahata wrote: And how does one find out more information

RE: RE: FULL TABLE SCAN?

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 -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

  1   2   3   >