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 Hi, Can you please help me out in solving this weird problem of funcation-based index not being used when I query the table. This is the comand I fired and the result it returned me. 1. SQL create table employees (last_name varchar2(20)); Table created. 2. SQL CREATE INDEX upper_ix ON employees (UPPER(last_name)); Index created. Made the autotrace on and than:- 3. SELECT last_name FROM employees WHERE UPPER(last_name) IS NOT NULL ORDER BY UPPER(last_name); no rows selected. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 10 SORT (ORDER BY) 21 TABLE ACCESS (FULL) OF 'EMPLOYEES' I fired without order by clause also but no use. Now can any body please let tell me why this Oracle is having a full scan of the employee table. TIA, Marul. winmail.dat
RE: Is it correct way of adding two tables without having self-jo
in 'From' clause of view text. This is done generally in case of self join. But there is no self join condition written in 'Where' clause. Conditions for this table are as follows. a. ppa.payroll_id = rppa.payroll_id b. rpaa.assignment_id = paa.assignment_id In above conditions, joining columns are same columns. Hence this is not a Self Join scenario. 2. Table pay_payroll_actions has also been referenced 2 times in 'From' clause of view text. Problem is exactly same as per above point. Condition for this table are as follows. a. paa.payroll_action_id = ppa.payroll_action_id b. ppa.effective_date = rppa.effective_date Here, difference is in condition 'b'. This seems to be inappropriate. This condition will result in Cartesian product. But because of 'distinct' clause in view text, it is not giving duplicate rows. Questions: 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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 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 send the HELP command for other information (like subscribing). winmail.dat
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 thing many times. If I don't want a user to give privs of TAR creation or reading, then I simply remove this privs, and that user not able to see TAR section. Hope this helps. Regards, Sandeep. -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Fri 7/12/2002 8:24 PM To: Multiple recipients of list ORACLE-L Cc: Subject: My TAR button disappeared from MetaLink I clicked on a URL link in an e-mail from Oracle support, and got an error message telling me I have no privs to view the document. I logged into Metalink, and noticed that there is no TAR section in the right pane, as I usually have. There also is no TAR button in the left pane, I remember there being one there but my memory may be wrong... ??? I submitted MetaLink feedback. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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, 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 command for other information (like subscribing). W±ëzØ^¡÷âr¥9,BÅm¶ÿÃ(§Ú©Êëa¢´×¤««, ÑI©ÝyêZjË'{erV +r5ëp¢¹z»âqëçÎwó9ÔPó9ßÎtçT8'è®xæåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq +j)fzËëh.+-êî}«\Ü¢ièµá $ì¥éex(|¸¬´k«¹©Ý{azg¬±¨àØw%¹×)Þríj)â +I@ND º+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ³Ü¢i×è®az¸§~æjبX¤z˱Êân)à
RE: Function based indexes
Hi, I've seen oracle application 11i(11.5.3) setting one parameter _OR_EXPAND_NVL_PREDICATE for queries using nvl(:bind_var, col_name) syntax. Have a look at this parameter on metalink. It is published hidden parameter. It may help you. Regards, Sandeep. -Original Message- Sent: Friday, July 12, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Subject:Re: Function based indexes I don't think that will work. If you need this to work in a SQL statement in SQL*Plus, what you can do is something like this: create or replace package types as type cursorType is ref cursor; end; / create or replace function sp_ListEmp ( col_value_in my_table.my_column.%type default 'My Default Value') return types.cursortype as l_cursortypes.cursorType; begin open l_cursor for select 'x' from my_table where my_column = col_value_in; return l_cursor; end; / REM SQL*Plus commands to use a cursor variable variable c refcursor variable my_bind='testdata' exec :c := sp_ListEmp(:my_bind) print c HTH Jared On Thursday 11 July 2002 15:24, Imma C. Rocco wrote: Hi, I have read that on Oracle 8.1.7 it is possible to create a function based index like the one: Create index ind1 on table (substr(column_name)) tabelspace etc And if Oracle optimizer is in CBO mode and query_rewrite_enabled = true query_rewrite_integrity = trusted compatible = 8.1.0 or greater A statement which has a where clause that involve a substr(colum_name) should use the index. (*)I would like to know if it is also possible to create a function based index on a NVL function that involve a bind variable, because a have a statement like the one that follow: select 'x' from table where col_name = nvl(:p_aa, col_name) This statement perform a full table scan on table ps: if (*) is possible could you please give an sintax example? Thanks Imma _ Supercharge your e-mail with a 25MB Inbox, POP3 Access, No Ads and NoTaglines -- LYCOS MAIL PLUS. http://www.mail.lycos.com/brandPage.shtml?pageId=plus -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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, 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 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 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 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).
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 of tuning these applications. I can see lots of poorly written SQLs. These can be tuned from backend as well as changing SQLs in forms. But what about poorly written logic? As such, I am going thr' each and every line of code and tuning it wherever necessary, but plenty of time will require to complete this process. If there is any tool available which identify the problem, then I've to directly go to the application/code and modify it. If I've to rewrite whole application, then its massive task. Please help. TIA, Regards, Sandeep. æ¬zǶ¨}ø©ND ±@Bm§ÿðà +iöªrºØh§uç©*êå'4DÒjw^z¥²ÉçbÙ\¢fá«BÜzÜ(®D®øzÏ9óüçNuüçÎwó9Õ§' ¥ú+¹¹bpíz¹Þµ§zË?1¨¥xËlND0åDÊ«±é_~º¶¬¨¥x%ËlzwZCY²Æ zÚËFº»j×·'(z-xEÀ + ;)zYb .+-êîjwbØ^ë,j86Énuæ¥w¢{Zx§CRP Ä.í éÚꨥx%Ër¢ìÛhmêÞÞuúè.¬Ê,zwm áÄ,÷(f§uú+¢Ø^®)ߢ¹¶*')²æìr¸x
RE: ORA-01722 Error after DBA changes
Hi, Not sure about exact reason. But I am also having similar condition like yours. One of my customers was running 8.1.5 with Forms5. I upgraded his DB to 8.1.7. And I started facing problem with some reports. I got answer from Oracle saying - this combination is not certified. Oracle has done lots of changes in Timestamp in 8.1.7 DB. Not very sure, but just check whether Forms 6i is certified on 8.1.6 and 7.3.4 or not. Recompilation of all forms and reports can be done by using project builder. But I'll prefer some DOS BATCH script. Create a file with .bat extension and put following line run it FOR %%I IN (*.FMB) DO {YOUR ORACLE HOME}\BIN\ifcmp60 %%I username/password End of script* Same logic you can apply for recompiling reports. HTH, Sandeep. -Original Message- Sent: Monday, May 20, 2002 7:14 PM To: Multiple recipients of list ORACLE-L Subject:ORA-01722 Error after DBA changes I have been getting a FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01722 error. The button calls a procedure in the form. Whenever this happens, I open up the form in Developer, recompile it, generate a new .fmx file and everything works fine. In other words, no changes, just recompilling. Do you have any idea why this might be happening? It seems to have started happening after I made some changes to the database. I was dropping and recreating some tables in order to change size parameters and also change privileges. Could this have had anything do with the ORA-1722 error? Right now, I know the fix but I am curious why I have to recompile everything. This is with Developer 6i (6.0.8.10.3) and Oracle 7.3.4. but it also happens against my Oracle 8.1.6 test database. When I asked this question to Oracle support, they replied that it was because by changing the database objects, the timestamp gets changed. But this does not make sense to me since these forms are not being stored in the database. It also seems to me that of the forms that are dependant of the tables that I changed, some have problems and others do not. Also, I suppose if this is true, I will have to recomplile all of my reports also. Anyone have hints or scripts that I might run to help me narrow down so that I do not have to recompile ALL forms and reports? TIA, Wayne [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: McGill, Wayne L 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, 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 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 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 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).
Steps in db opening from mount stage to open stage????
Dear Guru, I want to know all the internal steps happen during opening database from mount stage. For e.g. SMON cleans temp segment, block corruption check, SCN check.. etc.. etc.. Where can I find these details.. Any suggestion/input? TIA, Best Regards, Sandeep. -- 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 / 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 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: Steps in db opening from mount stage to open stage????
Hi, Oracle document says very generic, and I need detailed steps. I need all information about database internal activity which carries out when db opens from mount stage. Any help/suggestion? Regards, Sandeep. -Original Message- Sent: Monday, May 06, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Subject:RE: Steps in db opening from mount stage to open stage The conecpts guide in the doc explains a lot about the startup mount and open stages... HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Monday, May 06, 2002 10:48 AM To: Multiple recipients of list ORACLE-L Dear Guru, I want to know all the internal steps happen during opening database from mount stage. For e.g. SMON cleans temp segment, block corruption check, SCN check.. etc.. etc.. Where can I find these details.. Any suggestion/input? TIA, Best Regards, Sandeep. -- 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 / 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 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: Ganesh Raja 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, 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 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 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 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).
How to simulate Block Corruption?
Hello Gurus, I am in the process of testing recovery options from block corruptions. So, my setup requires a db which is having block corruption problem. How to simulate block corruption in db? Any help? TIA, Sandeep. -- 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 / 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 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).
VIRUS!!! VIRUS!!! VIRUS!!!!! BE CAREFUL!!!
virus info.html 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 Updates Products Downloads Support Services AVERT Partners About McAfee Virus Alerts Anti-Virus Updates Virus Information Library - Overview - Newly Discovered Viruses - Recently Updated Viruses - Hoaxes - Virus Calendar - White Papers AVERT Research Center AVERT WebImmune Virus Name Risk Assessment W32/Klez.h@MM Medium Virus Information Discovery Date: 04/17/2002 Origin: Unknown Length: approx 90kB Type: Internet Worm SubType: Win32 Minimum Dat: 4182 Minimum Engine: 4.0.70 DAT Release Date: 01/23/2002 Description Added: 04/17/2002 Description Modified: 04/26/2002 8:38 AM (PT) Description Menu Virus Characteristics Symptoms Method Of Infection Removal Instructions Variants / Aliases Rate this page Print This Page Virus Characteristics --- Update 4/18/2002 ---AVERT has raised the risk assessment of this threat to Medium after seeing an increase in prevalence over the past 24 hours. Home users are at a greater risk of infection, as they tend to update their DATs less frequently then corporations. As such, the risk of becoming infected in a corporate environment is lower. This latest W32/Klez variant is already detected as W32/Klez.gen@MM by McAfee products using the 4182 DATs (23 January 2002) or greater. W32/Klez.h@MM has a number of similarities to previous W32/Klez variants, for example: W32/Klez.h@MM makes use of Incorrect MIME Header Can Cause IE to Execute E-mail Attachment vulnerability in Microsoft Internet Explorer (ver 5.01 or 5.5 without SP2). the worm has the ability to spoof the From: field (often set to an address found on the victim machine). the worm attempts to unload several processes (antivirus programs) from memory. Including those containing the following strings: _AVP32 _AVPCC NOD32 NPSSVC NRESQ32 NSCHED32 NSCHEDNT NSPLUGIN NAV NAVAPSVC NAVAPW32 NAVLU32 NAVRUNR NAVW32 _AVPM ALERTSVC AMON AVP32 AVPCC AVPM N32SCANW NAVWNT ANTIVIR AVPUPD AVGCTRL AVWIN95 SCAN32 VSHWIN32 F-STOPW F-PROT95 ACKWIN32 VETTRAY VET95 SWEEP95 PCCWIN98 IOMON98 AVPTC AVE32 AVCONSOL FP-WIN DVP95 F-AGNT95 CLAW95 NVC95 SCAN VIRUS LOCKDOWN2000 Norton Mcafee Antivir The worm is able to propagate over the network by copying itself to network shares (assuming sufficient permissions exist). Target filenames are chosen randomly, and can have single or double file extensions. For example: 350.bak.scr bootlog.jpg user.xls.exe The worm may also copy itself into RAR archives, for example: HREF.mpeg.rar HREF.txt.rar lmbtt.pas.rar The worm mails itself to email addresses in the Windows Address Book, plus addresses extracted from files on the victim machine. It arrives in an email message whose subject and body is composed from a pool of strings carried within the virus (the virus can also add other strings obtained from the local machine). For example:Subject: A very funny website or Subject: 1996 Microsoft Corporation or Subject: Hello,honey or Subject: Initing esdi or Subject: Editor of PC Magazine. or Subject: Some questions or Subject: Telephone number The file attachment name is again generated randomly, and ends with a .exe, .scr, .pif, or .bat extension, for example: ALIGN.pif User.bat line.bat Thanks to the use of the exploit described above, simply opening or previewing the message in a vulnerable mail client can result in infection of the victim machine. W32/Klez.h@MM masquerades as a free immunity tool in at least one of the messages used. Below is the message sent by the virus itself.Subject: Worm Klez.E Immunity Body: Klez.E is the most common world-wide spreading worm. It's very dangerous by corrupting your files. Because of its very smart stealth and anti-anti-virus technic,most common AV software can't detect or clean it.We developed this free immunity tool to defeat the malicious virus. You only need to run this tool once,and then Klez will never come into your PC. NOTE: Because this tool acts as a fake Klez to fool the real worm,some AV monitor maybe cry when you run it. If so,Ignore the warning,and select 'continue'. If you have any question,please mail to me. The worm may send a clean document
RE: AUTOMATIC SHUTDOWN/STARTUP SCRIPT
msg40478/bin0.bin Description: application/pkcs7-mime
RE: 8i and Veritas NetBackup
target sys/pass@PROD1 catalog rman/rman@RCAT1 rman list copy of database archivelog all; rman list backup ; For particular objects : Rman list backup of database ;# all files in the database Rman list copy of Datafile '/u01/oracle/dbs/tbs1.dbf' ; Rman list copy of archivelog all ; Rman list backup of tablespace 'SYSTEM'; Rman list backup of control file ; REPORT - This command is used for getting a detailed information from the catalog like a. Which files need a backup b. Which files haven't been backed up recently c. Which files are listed unrecoverable d. Which backup sets are obsolete and can be deleted e. Which copies are on disk and which are on tape To identify which datafiles need a backup : Rman report need backup days = 7 database ; Rman report need backup days = 30 tablespace system ; Where days = x , is the number of days of archive logs required to recover the database safely . Types of Oracle backups : 1. Full - It backs up all the used datablocks in a Datafile . It's not the same as a Incremental Level 0 backup . 2. Incremental - It backs up only all the data blocks that have changed since the last incremental backup . During a restore we need to have a level 0 backup also . 3. Open - Backup of any part of target database when it's open 4. Closed - When the database is mounted , but closed . 5. Consistent - The database is mounted but not open . The database must have been shutdown cleanly before this step . The checkpoint SCNs in the Datafile must match the Datafile headers in the control file . This backup can be restored without recovery . 6. Inconsistent - The backup of the database when it's open , when it crashed lasttime when it was mounted or when U use a shutdown abort before backup . U need to do a database recovery . Reference: 1. Oracle 8I backup and recovery guide 2. Netbackup 3.2 Administrator's guide 3. Netbackup 3.2 media manager's guide 4. Netbackup for Oracle installation guide . Additional Keywords == Solaris; Configure Netbackup; VOS Note: This document was written by VOS JEC ( Veritas Oracle Sun Joint Escalation Center ) analyst. Hope this helps. Regards, Sandeep. -Original Message- Sent: Friday, February 22, 2002 5:38 PM To: Multiple recipients of list ORACLE-L Subject:8i and Veritas NetBackup Is anyone using this combination? We're having problems getting backups to work with 8i. It works fine with our 8 dbs, but when we try to backup the 8i ones, the control panel says the backup has started, but it doesn't finish and usually has a dead rman process on the db. We've working with Veritas support, but it's been 2 weeks and no answer. The dbs are 8.1.7.3 on Solaris 7 and we did patch the oracle executables. Thank you for any help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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, 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 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 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 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).
Offtopic: www.lonyx.com ????
Hi, Anyone has idea - what happened to website www.lonyx.com I think it is Kevin Lonyx website. I found this website very interesting in past... but when I am trying to access today, I am unable to get in. Thanks in Advance. -- 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 / 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 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). winmail.dat
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 Note:119707.1 on metalink Hope this helps. Sandeep. -Original Message- From: Harvinder Singh [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 9:19 PM To: Multiple recipients of list ORACLE-L Subject: 32 or 64 bit Hi, How to check the database and sun unix system is 32 bit or 64 bit. Thanks --Harvinder
Offtopic: www.lonyx.com ????
Hi, Anyone has idea - what happened to website www.lonyx.com I think it is Kevin Lonyx website. I found this website very interesting in past... but when I am trying to access today, I am unable to get in. Thanks in Advance. -- 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 / 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 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: Dropping user hangs indefnitely
User may be having many tables, and that's why taking lots of time to drop. -Original Message- Sent: Tuesday, February 05, 2002 12:41 PM To: Multiple recipients of list ORACLE-L Subject:Dropping user hangs indefnitely Hi list, Can anybody help me how to identify why the dropping of a particular user hangs indefnitely ?? Database is 8.1.7 on Solaris 7. Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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, 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 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 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 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: Oracle Error - 1467
Not sure, which Oracle version u r using If it is 7.3.4.0.0 then it is a bug and this bug is resolved in 7.3.4.0.5 HTH, -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 4:10 PM To: Multiple recipients of list ORACLE-L Hi Friends, I am having a sql statement where select field1,field2.. field15, sum(fieldx1), sum(fieldx2).. sum(fieldx200) from t1 group by field1,field2.. field15; when i execute this statement , i am getting error - 1467 which says sort key too long Cause Mentioned in the document : A DISTINCT, GROUP BY, ORDER BY, or SET operation requires a sort key longer than that supported by Oracle. Either too many columns or too many group functions were specified in the SELECT statement. Action: Reduce the number of columns or group functions involved in the operation. My question is whether any restrictions on no 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 FAX: (858) 538-5051 San Diego, California-- Public 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 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: ALTER ROLLBACK SEGMENT rbs SHRINK
I don't think - it will work. You won't get any error as well as it won't shrink. Any other inputs from others??? Rgds, -Original Message- Sent: Wednesday, January 30, 2002 9:55 AM To: Multiple recipients of list ORACLE-L Hi, Assume INITIAL * MINEXTENT = 2M and also = OPTIMAL Do you think ALTER ROLLBACK SEGMENT rbs SHRINK TO 1M; will work ? Thanks, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing 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, 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 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 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 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: Query
Yes.. you can have. -Original Message- Sent: Monday, January 28, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Hi all, Can we have the multiple databases on the same m/c running at the same time. thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer 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, 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 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 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 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).