RE: Function-Based Index not working

If CBO think - cost of FTS will be less than index scan then it will not use index. HTH. -Original Message- From: Marul Mehta [mailto:[EMAIL PROTECTED]] Sent: Sat 8/31/2002 11:48 To: Multiple recipients of list ORACLE-L Cc: Subject:Function-Based Index not working

RE: Is it correct way of adding two tables without having self-jo

-- 1. Is it correct way of writing query? Imho, there is some mistake done by development team. 2. Not sure whether this view is giving desired result. 3. As data is growing day by day, performance of this view is becoming poor. Can we optimize this view? Any expert comments? Thanks. Sandeep

RE: My TAR button disappeared from MetaLink

Hi, Your - TAR read and create priv has been removed, that is why you are not able to see TAR button in left pane. You contact with your local support and tell them your problem and they will grant you this privs. I am having administrator right on my company CSI, and I have done this t

RE: Function based indexes

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 t

Any tool available for identifying junk code?

Hi Guys, Sorry, if this sounds bit awkward or unrelated to this mailing list. Can any one of you please let me know whether there is any tool available to identify junk code in an application. My applications are written in Oracle Forms and VB. Backend is Oracle. I am in the process o

RE: ORA-01722 Error after DBA changes

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sandeep Kurliye INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public In

RE: Steps in db opening from mount stage to open stage????

-- Author: Sandeep Kurliye 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 mailing list

Steps in db opening from mount stage to open stage????

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

How to simulate Block Corruption?

-- Author: Sandeep Kurliye 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 mailing list

VIRUS!!! VIRUS!!! VIRUS!!!!! BE CAREFUL!!!

<> Sandeep Kurliye Certified Oracle DBA Almoayyed International Group Almoayyed Computers, PO Box 26259, Manama, Bahrain. Ph. 973-700777 Fax.973-701211 Email. [EMAIL PROTECTED] Title: McAfee - AVERT Buy Products   Try Products   Download U

RE: AUTOMATIC SHUTDOWN/STARTUP SCRIPT

msg40478/bin0.bin Description: application/pkcs7-mime

RE: 8i and Veritas NetBackup

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 removed from). You may also

Offtopic: www.lonyx.com ????

-- Author: Sandeep Kurliye 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 mailing list

RE: 32 or 64 bit

Title: Message     There are several ways to know about the oracle S/W installed is 32 or 64-bit 1- check V$VERSION 2- use the UNIX command FILE for oracle 3- invoke server manager pls refer to on metalink   Hope this helps.   Sandeep.   -Original Message- From: Harvinder

Offtopic: www.lonyx.com ????

-- Author: Sandeep Kurliye 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 mailing list

RE: Dropping user hangs indefnitely

27;) 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.com -- Author: Sandeep Kurliye

RE: Oracle Error - 1467

of columns that can be grouped is there or is it depend on any space constraint on temporary tablespace.. Thanks in advance, Shankar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sandeep Kurliye INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: ALTER ROLLBACK SEGMENT rbs SHRINK

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.com -- Author: Sandeep Kurliye INET: [EMAIL PROTECTED]

RE: Query

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