Enqueue tuning
Hi All, I have a batch job that seems to have a lot of enqueue waits (second longest wait time (337156 cs?) from v$session_event). I have read that increasing the enqueue resources does not solve this problem as I have no ORA-52 ORA-53 errors. (I have increased it by a factor ten to try it and no better results.) What can I look at to try and improve this waiting?? THX Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- 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).
Ang: RE: Sqlloader - important
Yes and i should have checked the error more myself but was tired Roland [EMAIL PROTECTED]@fatcity.com den 2001-11-13 15:05 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: I think it's really amazing how many people spotted the error. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Mercadante, Thomas F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ate.ny.us Subject: RE: Sqlloader - important Sent by: [EMAIL PROTECTED] 11/13/2001 10:40 AM Please respond to ORACLE-L You are missing a comma and another single quote: orig== (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), new== (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID), Hope this helps! :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 13, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- 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: Mercadante, Thomas F 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: 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: 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 extract text from LONG field
Title: how to extract text from LONG field Hi! Is there a way that I can extract the source code of a trigger from dba_triggers? The problem is that the information is stored in a LONG colum. SQLWKS desc dba_triggers Column Name Null? Type -- OWNER VARCHAR2(30) TRIGGER_NAME VARCHAR2(30) TRIGGER_TYPE VARCHAR2(16) TRIGGERING_EVENT VARCHAR2(216) TABLE_OWNER VARCHAR2(30) BASE_OBJECT_TYPE VARCHAR2(16) TABLE_NAME VARCHAR2(30) COLUMN_NAME VARCHAR2(4000) REFERENCING_NAMES VARCHAR2(128) WHEN_CLAUSE VARCHAR2(4000) STATUS VARCHAR2(8) DESCRIPTION VARCHAR2(4000) ACTION_TYPE VARCHAR2(11) TRIGGER_BODY LONG select table_owner, table_name from dba_triggers where trigger_body like '%T_JOURNAL%'; does not work, because the LONG field can't be searched with LIKE. to_char conversion doesn't work either. Any ideas? This is 8.1.7 on Sun Solaris. Thanks, Helmut
RE: Sqlloader
What does your data file (sorry infile) look like ?? -Original Message- Sent: 13 November 2001 19:17 To: Multiple recipients of list ORACLE-L Hallo, I am running this sqlloader ctl-file load data infile 'C:\temp\arg\argdwfkt3.txt' TRUNCATE into table argdwfkt_kopia FIELDS TERMINATED BY ';' (BUTIKS_ID, BUT_NAMN, REGION_ID DECODE(:REGION_ID,'!','98','?','97',:REGION_ID), DISTRIKT_ID DECODE(:DISTRIKT_ID,'!','98','?','97',:DISTRICT_ID), ROLL_ID, PROFIL_ID DECODE(:PROFIL_ID,'!','98','?','97',:PROFIL_ID), AR, KVARTAL, MANAD, VECKA, DOKUMENTTEST_ARKFORMAT DECODE(:DOKUMENTTEST_ARKFORMAT,'A4','1','A3','2','E1','3','!','98','?','97' ,'99'), KAMPANJ_TYP, MX_URVAL, POSTBEFODRAN DECODE(:POSTBEFODRAN,'A','1','B','2','!','98','?','97','99'), PRINT_FORETAG_ID DECODE(:PRINT_FORETAG_ID,'1','1','2','2','!','98','?','97','99'), STYCKKOSTNAD, FASTKOSTNAD_BREVMALL, FASTKOSTNAD_ARENDE, TOTAL_KOSTNAD, ANTAL_ÄRENDEN, ANTAL_BREVMALLAR_I_ARENDE, ANTAL_KUNDSEGMENT_I__ARENDE, ANTAL_KUNDER_I_URVAL, DATUM_HOS_KUND, AKTIVITETS_LOPNR, PRODUKTIONSENHET, AKTIVITETSDATUM, BEHANDLINGSGRP) but gets this error message, check the file:What does it mean and how should I fix this: (See attached file: arg.log) Thanks in advance Roland S The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: How do you change default oracle home?
Hi Probably not supported but Backup your oracle registry key edit the default home key in your registry and see what happens. Play around with the registry untill it works. I did something like it a while ago when I tried to install an oracle 7.3.4 version next to 8.0.5, 8.1.7 and the installer only allowed the 7.3.4 in the default home which was obviously already used. Jack Cale, Rick T (Richard) [EMAIL PROTECTED]@fatcity.com on 13-11-2001 17:00:28 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi I have Oracle, 8,8i,9i installed on Win 2k. I want to have 9i as default oracle home. Where can I do that? I have tried using Oracle Home selector which was set to 9i but still defaults to reading service name from 8.0. Oracle help says change path environment, variable to have 9i first. That does not work. I could not find anwwhere is registry to set this. My ultimate goal is to run some Pro*C programs and use Ora9i as the default home. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- 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).
Re: EnCrypting
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 14, 2001 09:00 Hello, what kind of different possibilities there are to encrypt the data inside the database. http://www.cybcon.com/~jkstill/util/encryption/encryption.html hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov 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).
sqlquestion
Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 and I want the select the select to giv e me this: Jimmy Timmy How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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).
Antwort: Re: Failures in creating Oracle database file.
Oracle does not support files larger than 2GB on Linux Doesnt matter if linux itself support it or not. Ivo Byron Pearce bpearce@tenuAn: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] re.com Kopie: Gesendet von:Thema: Re: Failures in creating Oracle database file. root@fatcity. com 11/14/2001 05:40 AM Bitte antworten an ORACLE-L Jesse: It sounds as if you may have run into the 2GB file size limit. Has your filesystem been created and mounted with the largefiles option? An easy way to check would be to try and create the tablepace with a 1GB or 2GB datafile and see if it works. Jesse W. Asher wrote: I'm attempting to create a 3GB file on an XFS filesystem using Oracle 8i running on RedHat 7.1 with a generic 2.4.10 kernel and I'm getting some errors. Here's the command and output I'm getting: CREATE TABLESPACE ALTUSER DATAFILE '/export/4/oracle/oradata/alt/data01.dbf' SIZE 3000M REUSE AUTOEXTEND ON NEXT 1280K MINIMUM EXTENT 128K DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0); CREATE TABLESPACE ALTUSER DATAFILE '/export/4/oracle/oradata/alt/data01.dbf' SIZE 3000M REUSE * ORA-01119: error in creating database file '/export/4/oracle/oradata/alt/data01.dbf' ORA-27037: unable to obtain file status Linux Error: 75: Value too large for defined data type = Any ideas as to what could be causing this? I thought the file size limit is 4GB which is why I made the file 3GB. Is this correct or am I missing something?? Many thanks!! -- Jesse W. Asher [EMAIL PROTECTED] -- Byron Pearce mailto:[EMAIL PROTECTED] Tenure Systems, Inc. Arlington, Texas It's hard to be a ninja when you wear a beeper. -- 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).
[no subject]
hi gurus, wat's the difference of 8i ias standard and enterprise? Best regards, Grace Lim Suy Sing Comm'l Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace 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: sqlquestion
Hi SELECT SUBSTR(column,1,INSTR(column,' ')) from table; There is a space between the two quotes!! Jack [EMAIL PROTECTED]@fatcity.com on 14-11-2001 10:15:19 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 and I want the select the select to giv e me this: Jimmy Timmy How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- 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).
sql-important
Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 No Info and I want the select to give me this: Jimmy Timmy No Info You see It should still be 'No info' after the select statement. How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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).
Re:
More of the 'optional' features are enabled in Enterprise edition (for this you pay a higher licensing cost). Take a look at: http://technet.oracle.com/doc/oracle8i_816/server.816/a76962/ch4.htm#73594 hth connor --- grace [EMAIL PROTECTED] wrote: hi gurus, wat's the difference of 8i ias standard and enterprise? Best regards, Grace Lim Suy Sing Comm'l Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: sqlquestion
SELECT SUBSTR(column,1,INSTR(column,' ') -1 ) from table; JP On Wed 14. November 2001 10:40, you wrote: Hi SELECT SUBSTR(column,1,INSTR(column,' ')) from table; There is a space between the two quotes!! Jack [EMAIL PROTECTED]@fatcity.com on 14-11-2001 10:15:19 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 and I want the select the select to giv e me this: Jimmy Timmy How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: Correction : EMC symetrix - 1M stripe width - Raid 0+1 - Perform
Interestingly you could go back to Oracle support and ask them about the SAME method (as presented by an Oracle employee if I recall correctly at a user conference) - which advocated 1m stripes. You'll tend to face these battles with EMC - their sales people are great at things like you don't need to worry about where things are on the disk, or striping etc - our cache takes care of all of that...Yeah right! As a general guideline, I think you'd be better of with smaller stripe size, but you don't have to limit yourself - you could have fine granined striping for some parts of the system, and larger grains for other parts. hth connor --- [EMAIL PROTECTED] wrote: Hi, Application : OLTP Environment : Solaris 2.6 on a E10K Database : 8.0.5.2.1 We recently migrated from sun a5200 storage to EMC symetrix, and we have been seeing occasional performance problems. When contacted, Oracle support among other things pointed out the stripe width we have used 1M, is very large and also said users will not see an advantage above 64K. When we had Sun storage before we had 64K as the stripe width. Has anyone faced this kind of issue or has any comments..or can someone explain the low level impact of the stripe width on the ORACLE I/O operations? Much appreciated.. Regards Mohammed Ahsanuddin Oracle DBA -- 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Insert script generator
As nobody gave me the script I really wanted to, I had to create one myself :((( Starting part is based on Jared's dump.sql but the rest of course is different. Here is link to it, just in case of need ;))) http://www.itsystems.lv/gints/dba_selects.htm#s21 Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Jared.Still@ra disys.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Insert script generator om 2001.11.08 19:15 Please respond to ORACLE-L Look for dump.sql at www.cybcon.com/~jkstill/util Jared G.Plivna@itsys tems.lv To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Insert script generator om 11/08/01 06:30 AM Please respond to ORACLE-L Hi! I'm sure somebody has already created a script that makes insert scripts for data in a table. I'm too lazy to reinvent wheel, maybe You are so kind to share it with me! TIA Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ -- 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).
Re: lack of memory
(Of course depending on the app), its seems odd that 4G is insufficient for 400 users. Maybe start having a look at the uga/pga stats for connected sessions and seeing what this adds up to. hth connor --- Edward Shevtsov [EMAIL PROTECTED] wrote: Hi List, We use a server with 4Gb memory on Linux kernel 2.2.19, Oracle 8.1.7.0 dedicated mode. It's an OLTP system with about 450 users. About 2 months ago I initiated gradual migration of our sql code to use bind variables instead of literals because we had problems with shared pool's fragmentation and strong contention on shared pool and library cache latches. The 90% of sql is accumulated on the client side (BDE+Delphi). I cut 150M from shared pool and planned cut it down further as we get results from the migration. Despite that now we have lack of memory. It seems now user processes consume more memory. We can't increase memory because of limitations on kernel 2.2. In general Is there any significant difference in terms of memory consumtion between a user process that uses bind variables and another one that uses literals? Does anyone use 8.1.7, MTS mode on Linux for a system with similar loading (400-500 users). Is that stable enough?. I have doubts. Please help. Regards, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: sql-important
Roland, If it is only 'No Info' that you want to keep then the below should do SELECT decode(field1,'No Info','No Info', ltrim(substr(mxurval_namn,instr(mxurval_namn,' ' FROM mxurval; Cheers Iain Nicoll -Original Message- Sent: 14 November 2001 10:00 To: Multiple recipients of list ORACLE-L Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 No Info and I want the select to give me this: Jimmy Timmy No Info You see It should still be 'No info' after the select statement. How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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: Nicoll, Iain (Calanais) 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).
Ang: RE: sql-important
Well in should be the the word 'Test today' to be included in the sql statement Nicoll, Iain (Calanais) [EMAIL PROTECTED]@fatcity.com den 2001-11-14 02:20 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Roland, If it is only 'No Info' that you want to keep then the below should do SELECT decode(field1,'No Info','No Info', ltrim(substr(mxurval_namn,instr(mxurval_namn,' ' FROM mxurval; Cheers Iain Nicoll -Original Message- Sent: 14 November 2001 10:00 To: Multiple recipients of list ORACLE-L Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 No Info and I want the select to give me this: Jimmy Timmy No Info You see It should still be 'No info' after the select statement. How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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: Nicoll, Iain (Calanais) 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: 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).
komplex sql
Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 No Info Missing Info and I want the select to give me this: Jimmy Timmy No Info Missing Info You see It should still be 'No info' and 'Missing Info'after the select statement. How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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).
RE: ok..this is funny.. how do you pronounce tuple
Yeah - kind of like too-you-pull but a lot quicker.. -Original Message- Lee - lerobe Sent: 14 November 2001 08:30 To: Multiple recipients of list ORACLE-L Hmm, dilemma - neither tyu pul Mainly because thats what my Ingres Course Instructor used in class, many, many years ago. Lee -Original Message- Sent: 14 November 2001 04:55 To: Multiple recipients of list ORACLE-L Write out of good old relational theory.. So is it (too pul). or (tuh pall).. Thanks, D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Mark Leith 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).
Antwort: komplex sql
maybe something like this: SELECT DECODE(mxurval_namn,'No Info','No Info','Missing Info','Missing Info',ltrim(substr(mxurval_namn,instr(mxurval_namn,' ' FROM mxurval; I dint try it Ivo Roland.Skoldb [EMAIL PROTECTED] An: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Gesendet von:Kopie: root@fatcity.Thema: komplex sql com 11/14/2001 11:50 AM Bitte antworten an ORACLE-L Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 No Info Missing Info and I want the select to give me this: Jimmy Timmy No Info Missing Info You see It should still be 'No info' and 'Missing Info'after the select statement. How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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: 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: who execute scripts in Win NT like Unix!!
Alex, echo spool output.lis sql_file.sql echo SELECT s.sid, sql_file.sql echos.serial#, sql_file.sql echop.pid, sql_file.sql echop.spid, sql_file.sql echos.osuser,sql_file.sql echos.machine, sql_file.sql echos.programsql_file.sql echo FROM v$session s, v$process p sql_file.sql echo WHERE p.addr = s.paddr sql_file.sql echoAND s.schemaname 'SYS'sql_file.sql echo ORDER BY p.spid,s.sid, p.pid, p.spid; sql_file.sql echo exit sql_file.sql echo spool off sql_file.sql sqlplus dbvision/dbvision@t_nhspint @sql_file.sql Put the above commands into a DOS batch file and then run it...you can add in things like SET LINESIZE etc...just the same way as the spool command is written. Cheers, Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 13 November 2001 23:00 To: Multiple recipients of list ORACLE-L Hi gurus!!! I need execute any scripts in win nt like oracle in unix!!! example: sqlplus user/password fin SELECT s.sid, s.serial#, p.pid, p.spid, s.osuser, s.machine, s.program FROM v\$session s, v\$process p WHERE p.addr = s.paddr AND s.schemaname 'SYS' ORDER BY p.spid,s.sid, p.pid, p.spid; fin @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez 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: Thomas, Kevin 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: komplex sql
I hope I got you right. Anyway here's a not so complex sql SELECT DECODE(mxurval_namn, NULL, 'No Info', ltrim(substr(mxurval_namn,instr(mxurval_namn,' ' FROM mxurval; I'm not sure what do you mean by 'No Info' and 'Missing Info'??? HTH Iulian -Original Message- Sent: Wednesday, November 14, 2001 12:50 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 No Info Missing Info and I want the select to give me this: Jimmy Timmy No Info Missing Info You see It should still be 'No info' and 'Missing Info'after the select statement. How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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). ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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).
RE: ok..this is funny.. how do you pronounce tuple
Kindof like tooyoupull only different...! ;o) -Original Message- Sent: 14 November 2001 11:05 To: Multiple recipients of list ORACLE-L Yeah - kind of like too-you-pull but a lot quicker.. -Original Message- Lee - lerobe Sent: 14 November 2001 08:30 To: Multiple recipients of list ORACLE-L Hmm, dilemma - neither tyu pul Mainly because thats what my Ingres Course Instructor used in class, many, many years ago. Lee -Original Message- Sent: 14 November 2001 04:55 To: Multiple recipients of list ORACLE-L Write out of good old relational theory.. So is it (too pul). or (tuh pall).. Thanks, D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Mark Leith 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: Thomas, Kevin 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: lack of memory
Connor, thanks for the reply. I'd thought about it. Unfortunately, it's quite difficult to catch the difference as number of users is not constant and they do different job (oltp queries, big reports). Thanks, Ed (Of course depending on the app), its seems odd that 4G is insufficient for 400 users. Maybe start having a look at the uga/pga stats for connected sessions and seeing what this adds up to. hth connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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: [OT 9ias] RE: 9i install on Win2K
Read, read, read. Then as you encounter problems, search in MetaLink. I would recommend using 1.0.2.2. at the very least, even with 1.0.2.2. there are quirks to work through. I am applying patchset 8 today... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Khoa Do [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 12:50 AM To: Multiple recipients of list ORACLE-L Subject:[OT 9ias] RE: 9i install on Win2K I know this is probably OT but since people were talking about 9i install I wanted to mention that I have no problems with 9i. It is 9i application server that I seem to be having a problem. I tried to put 9i Application Server Enterprise Edition version 1.0.2.1 on Windows 2000 (which does run on a Pentium 4) and the beast would not completely install. Things like Forms Server were missing. I was wondering if anybody had any experience with the installation of if you know of any pointer that I can follow to fix my problem. Thanks for the help! Sincerely, Khoa Do -Original Message- Sent: Tuesday, November 13, 2001 8:35 AM To: Multiple recipients of list ORACLE-L I have not tried to install 9i on my Win2K partition. Don't need to, right now. Happy with 9i on Suse linux so far. Gerardo ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khoa Do 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: 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).
RE: komplex sql
SELECT DECODE(field1,'No Info','No Info','Missing Info','Missing Info',ltrim(su bstr(field1,1,instr(field1,' ')-1))) FROM mytable This works I have ran it myself. eg. SQL @lee FIELD1 DECODE(FIELD1,'NOINF Jimmy J1000 Jimmy No Info No Info Timmy J1000 Timmy Missing Info Missing Info Roland, I don't mean to be harsh, but can I politely suggest that you get yourself either booked on or self study Oracle Basics. It seems that when someone provides you with a solution to a problem, rather than press ahead and solve the rest of it yourself you merely ask another question. For example, your previous question to this was how to get No info selected. Next you ask how to get Missing Info as well. Logic suggests that you merely repeat the solution you were given for the previous question re. No Info. Sorry if I appear to be giving a lecture here but of late it seems that you are throwing questions to the list without taking anytime to think about them yourself. Regards Lee -Original Message- Sent: 14 November 2001 10:50 To: Multiple recipients of list ORACLE-L Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 No Info Missing Info and I want the select to give me this: Jimmy Timmy No Info Missing Info You see It should still be 'No info' and 'Missing Info'after the select statement. How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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).
IP Address Change
Our network folk have informed me that they are going to have to change the scope of IP addresses at our site and hance the IP addresses of our servers will change. We don't use Oracle names or MTS. We're all NT/W2K servers and use DNS. Are there any gothca's I need to be aware of. Our TNSnames and Listener files use the host name and not specific IP addresses. I've had a browse around MetaLink and have not ID'ed any problems thus far but more experienced feedback would be appreciated. - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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).
Problems with Pro*C
Hello I am a novice to ProC. I have Some problems with compiling a sample file from ProC manual for the code: char userid[12]=scott/tiger; EXEC SQL CONNECT :userid I receive an error that says userid is an undefined variable, could someone help me? Thanks very much E. __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda 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: IP Address Change
we changed serveral times and did'nt encounter any problems, you correctly mentioned the listener en tnsnames files (the hostname doesn't change accidentally?) g.g. kor rdw ict the netherlands -Oorspronkelijk bericht- Van: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 14 november 2001 13:05 Aan: Multiple recipients of list ORACLE-L Onderwerp:IP Address Change Our network folk have informed me that they are going to have to change the scope of IP addresses at our site and hance the IP addresses of our servers will change. We don't use Oracle names or MTS. We're all NT/W2K servers and use DNS. Are there any gothca's I need to be aware of. Our TNSnames and Listener files use the host name and not specific IP addresses. I've had a browse around MetaLink and have not ID'ed any problems thus far but more experienced feedback would be appreciated. - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: 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).
Ang: RE: komplex sql
But if I have this field1 Kenny Jenny A1000 Jenny L1000 No info Missing Info I would have: Kenny Jenny Jenny No info Missing Info How do I solve this: I just want the last word in the field to betaken away in the select statement. Roland Robertson Lee - lerobe [EMAIL PROTECTED]@fatcity.com den 2001-11-14 03:50 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: SELECT DECODE(field1,'No Info','No Info','Missing Info','Missing Info',ltrim(su bstr(field1,1,instr(field1,' ')-1))) FROM mytable This works I have ran it myself. eg. SQL @lee FIELD1 DECODE(FIELD1,'NOINF Jimmy J1000 Jimmy No Info No Info Timmy J1000 Timmy Missing Info Missing Info Roland, I don't mean to be harsh, but can I politely suggest that you get yourself either booked on or self study Oracle Basics. It seems that when someone provides you with a solution to a problem, rather than press ahead and solve the rest of it yourself you merely ask another question. For example, your previous question to this was how to get No info selected. Next you ask how to get Missing Info as well. Logic suggests that you merely repeat the solution you were given for the previous question re. No Info. Sorry if I appear to be giving a lecture here but of late it seems that you are throwing questions to the list without taking anytime to think about them yourself. Regards Lee -Original Message- Sent: 14 November 2001 10:50 To: Multiple recipients of list ORACLE-L Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 No Info Missing Info and I want the select to give me this: Jimmy Timmy No Info Missing Info You see It should still be 'No info' and 'Missing Info'after the select statement. How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: 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: IP Address Change
Title: RE: IP Address Change Sean, I've been there, we use the same sort of enviroment as you do. The only problem I experienced was network resolution were the servers could not resolve the DNS name etc. Unfortunately if the user cannot connect to Oracle! It must be a database problem!:) (Which in my case never was.) Something to watchout for, Clever users who have set their own clients via ip addresses. Tools I used when we did the crossover was ping and tnsping, used together they give you an excelent idea of what is going on. Most importantly, if it is your problem or a network issue. Hope it goes well Regards Denham -Original Message- From: O'Neill, Sean [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 2:05 PM To: Multiple recipients of list ORACLE-L Subject: IP Address Change Our network folk have informed me that they are going to have to change the scope of IP addresses at our site and hance the IP addresses of our servers will change. We don't use Oracle names or MTS. We're all NT/W2K servers and use DNS. Are there any gothca's I need to be aware of. Our TNSnames and Listener files use the host name and not specific IP addresses. I've had a browse around MetaLink and have not ID'ed any problems thus far but more experienced feedback would be appreciated. - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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). This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: how to extract text from LONG field
Title: how to extract text from LONG field Create a procedure and use a cursor to pick the long column. You can now use functions in your code for the variable being populated with the long column. declare cursor c1 is select trigger_name, trigger_body from user_triggers;c1_rec c1%rowtype;begin open c1; loop fetch c1 into c1_rec; exit when c1%notfound; if upper(c1_rec.trigger_body) like '%amar kumar padhi%' then dbms_output.put_line(c1_rec.trigger_name); else -- dbms_output.put_line(c1_rec.trigger_name); null; end if; end loop; close c1;end;/ rgds amar -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 14, 2001 12:15 PMTo: Multiple recipients of list ORACLE-LSubject: how to extract text from LONG field Hi! Is there a way that I can extract the source code of a trigger from dba_triggers? The problem is that the information is stored in a LONG colum. SQLWKS desc dba_triggers Column Name Null? Type -- OWNER VARCHAR2(30) TRIGGER_NAME VARCHAR2(30) TRIGGER_TYPE VARCHAR2(16) TRIGGERING_EVENT VARCHAR2(216) TABLE_OWNER VARCHAR2(30) BASE_OBJECT_TYPE VARCHAR2(16) TABLE_NAME VARCHAR2(30) COLUMN_NAME VARCHAR2(4000) REFERENCING_NAMES VARCHAR2(128) WHEN_CLAUSE VARCHAR2(4000) STATUS VARCHAR2(8) DESCRIPTION VARCHAR2(4000) ACTION_TYPE VARCHAR2(11) TRIGGER_BODY LONG select table_owner, table_name from dba_triggers where trigger_body like '%T_JOURNAL%'; does not work, because the LONG field can't be searched with LIKE. to_char conversion doesn't work either. Any ideas? This is 8.1.7 on Sun Solaris. Thanks, Helmut
Sqlimportante
Hallo, If I have this field1 Kenny Jenny A1000 Jenny L1000 No info Missing Info I would have: Kenny Jenny Jenny No info Missing Info How do I write the select statement to solve this I just want the last word in the field to be taken away in the result from the select statement. Roland S -- 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).
Re: Ang: RE: komplex sql
How do I solve this: I just want the last word in the field to betaken away in the select statement. Read oracle manual about INSTR and SUBSTR functions. JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: Problems with Pro*C
Do you have userid between? All variables used in embedded sql must be declare in this section. EXEC SQL BEGIN DECLARE SECTION; EXEC SQL END DECLARE SECTION; Rick -Original Message- Sent: Wednesday, November 14, 2001 7:16 AM To: Multiple recipients of list ORACLE-L Hello I am a novice to ProC. I have Some problems with compiling a sample file from ProC manual for the code: char userid[12]=scott/tiger; EXEC SQL CONNECT :userid I receive an error that says userid is an undefined variable, could someone help me? Thanks very much E. __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda 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: Cale, Rick T (Richard) 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: Ang: RE: komplex sql
Hi, Lookup the substr, instr, decode etc... functions in the fine manual. Excellent source for this kind of information Jack Go-ahead and start flaming!!! [EMAIL PROTECTED]@fatcity.com on 14-11-2001 13:25:20 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) But if I have this field1 Kenny Jenny A1000 Jenny L1000 No info Missing Info I would have: Kenny Jenny Jenny No info Missing Info How do I solve this: I just want the last word in the field to betaken away in the select statement. Roland Robertson Lee - lerobe [EMAIL PROTECTED]@fatcity.com den 2001-11-14 03:50 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: SELECT DECODE(field1,'No Info','No Info','Missing Info','Missing Info',ltrim(su bstr(field1,1,instr(field1,' ')-1))) FROM mytable This works I have ran it myself. eg. SQL @lee FIELD1 DECODE(FIELD1,'NOINF Jimmy J1000 Jimmy No Info No Info Timmy J1000 Timmy Missing Info Missing Info Roland, I don't mean to be harsh, but can I politely suggest that you get yourself either booked on or self study Oracle Basics. It seems that when someone provides you with a solution to a problem, rather than press ahead and solve the rest of it yourself you merely ask another question. For example, your previous question to this was how to get No info selected. Next you ask how to get Missing Info as well. Logic suggests that you merely repeat the solution you were given for the previous question re. No Info. Sorry if I appear to be giving a lecture here but of late it seems that you are throwing questions to the list without taking anytime to think about them yourself. Regards Lee -Original Message- Sent: 14 November 2001 10:50 To: Multiple recipients of list ORACLE-L Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 No Info Missing Info and I want the select to give me this: Jimmy Timmy No Info Missing Info You see It should still be 'No info' and 'Missing Info'after the select statement. How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: 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: komplex sql
Sorry if I appear to be giving a lecture here but of late it seems that you are throwing questions to the list without taking anytime to think about them yourself. So true. I was thinking the same. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 14, 2001 6:50 AM SELECT DECODE(field1,'No Info','No Info','Missing Info','Missing Info',ltrim(su bstr(field1,1,instr(field1,' ')-1))) FROM mytable This works I have ran it myself. eg. SQL @lee FIELD1 DECODE(FIELD1,'NOINF Jimmy J1000 Jimmy No Info No Info Timmy J1000 Timmy Missing Info Missing Info Roland, I don't mean to be harsh, but can I politely suggest that you get yourself either booked on or self study Oracle Basics. It seems that when someone provides you with a solution to a problem, rather than press ahead and solve the rest of it yourself you merely ask another question. For example, your previous question to this was how to get No info selected. Next you ask how to get Missing Info as well. Logic suggests that you merely repeat the solution you were given for the previous question re. No Info. Sorry if I appear to be giving a lecture here but of late it seems that you are throwing questions to the list without taking anytime to think about them yourself. Regards Lee -Original Message- Sent: 14 November 2001 10:50 To: Multiple recipients of list ORACLE-L Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 No Info Missing Info and I want the select to give me this: Jimmy Timmy No Info Missing Info You see It should still be 'No info' and 'Missing Info'after the select statement. How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Igor Neyman 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: Sqlimportante
You can try something like SELECT SUBSTR(field1,1,INSTR(field1,' ',-1)-1) FROM your_table; This are limitations. This assumes no trailing spaces and words are separated by a single space. If without limitations you could write pl/sql to do the same thing. HTH Rick -Original Message- Sent: Wednesday, November 14, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Hallo, If I have this field1 Kenny Jenny A1000 Jenny L1000 No info Missing Info I would have: Kenny Jenny Jenny No info Missing Info How do I write the select statement to solve this I just want the last word in the field to be taken away in the result from the select statement. Roland S -- 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: Cale, Rick T (Richard) 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: who execute scripts in Win NT like Unix!!
@lex, What I usually do in NT is to create a temporary file containing the sql statement within the NT batch job and then execute it via sqlplus. This, for me, is easier to maintain - less files to open when making changes. echo SELECT s.sid, temp.sql echos.serial#, temp.sql echop.pid, temp.sql echop.spid, temp.sql echos.osuser,temp.sql echos.machine, temp.sql echos.programtemp.sql echo FROM v$session s, v$process p temp.sql echo WHERE p.addr = s.paddr temp.sql echo AND s.schemaname 'SYS' temp.sql echo ORDER BY p.spid,s.sid, p.pid, p.spid; temp.sql echo exit temp.sql sqlplus user/password @temp.sql hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 13, 2001 6:00 PM To: Multiple recipients of list ORACLE-L Hi gurus!!! I need execute any scripts in win nt like oracle in unix!!! example: sqlplus user/password fin SELECT s.sid, s.serial#, p.pid, p.spid, s.osuser, s.machine, s.program FROM v\$session s, v\$process p WHERE p.addr = s.paddr AND s.schemaname 'SYS' ORDER BY p.spid,s.sid, p.pid, p.spid; fin @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez 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: Mercadante, Thomas F 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: Sqlimportante
Read oracle manual about INSTR and SUBSTR functions. JP On Wed 14. November 2001 13:35, you wrote: Hallo, If I have this field1 Kenny Jenny A1000 Jenny L1000 No info Missing Info I would have: Kenny Jenny Jenny No info Missing Info How do I write the select statement to solve this I just want the last word in the field to be taken away in the result from the select statement. Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: IP Address Change
Another idea: 1) Add db dns alias for each db. For example, db name=qodp, db dns alias=qodpdb for db server that qodp resides on. 2) On unix db servers and client machines, put db dns alias for host in tnsnames.ora. This allows you to change the location of the db to a different server w/ only a dns change. 3) On unix db servers, put localhost in listener.ora. Gene [EMAIL PROTECTED] 11/14/01 07:05AM Our network folk have informed me that they are going to have to change the scope of IP addresses at our site and hance the IP addresses of our servers will change. We don't use Oracle names or MTS. We're all NT/W2K servers and use DNS. Are there any gothca's I need to be aware of. Our TNSnames and Listener files use the host name and not specific IP addresses. I've had a browse around MetaLink and have not ID'ed any problems thus far but more experienced feedback would be appreciated. - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: Gene Sais 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).
Data integration script using PERL
Is there someone who wrote a script in a PERL language designed to insert data in Oracle tables by reading data from a text data file ? If so, is it possible to have just an example of it so that I can adapt it for my need. Just not to reinvent the wheel Thanx
Re: Sqlimportante
Roland, First, if you want the last word in the field to be taken away, then the result will be this: Kenny Jenny Jenny No Missing not that: Kenny Jenny Jenny No info Missing Info Second, as many listers already suggested, start reading oracle manuals. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 14, 2001 7:35 AM Hallo, If I have this field1 Kenny Jenny A1000 Jenny L1000 No info Missing Info I would have: Kenny Jenny Jenny No info Missing Info How do I write the select statement to solve this I just want the last word in the field to be taken away in the result from the select statement. Roland S -- 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: Igor Neyman 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).
real newbie question (i think)
Title: how to extract text from LONG field hey all, i'm in your typical situation of "we don't need a dba...oracle is an app so the bizapps guy can handle it"right...now to reality. there is a column in our database (oracle isthe back end of our crm package) that is defined as a long and they want to do keyword searches on it. i've found out that you can't use type long in a where clause. i guess i have a few questions and i'm going to assume the answers (if anyone answers...please oh please do) will be a matter of opinion. am i better off creating a new column in the existing table of the type clob or blob? should i create a new table to store this data? and what would be my best way to keep these columns in sync...every time someone updated the long column i would want my new column updated to reflect the change. right now we're on 8.0.6/win 2k...but could upgrade to 8.1.7 (means upgrading our crm package too) if it makes this process easier. thanks in advance for the help and not being a dba i hope what i wrote makes sense! *:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-: rich davidson dynamicsoft Inc. east hanover, nj [EMAIL PROTECTED] t. +1-973-503-6169 f. +1-973-952-5050
IDL_UB1$
Hello All I found in our database, that some of the sys tables have many extents (up to 700). These are IDL_* tables and some other tables related to our heavy use of plsql packages (like sources$, dependency$ etc). On metalink I found that it is possible to change the next parameter of the table, but I would like to ask you if you know about a way how to recreate the existing fragmented tables? What option would be possible? (sorted by preference) 1.rebuild the table online without need to do anything else 2.rebuild the table online with a need to disconnect users 3.drop all packages/functions ..., truncate the tables (idl_ub1$ etc.) and load all sources from export (+catalog etc.) 4.recreate database + change next extent on the tables + load everything from export Or is there other posibility? The database is 8.1.7 on Linux Kind regards Ivo Libal -- 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).
seouc in Feb.
Title: seouc in Feb. I know it's a little far in advance, but is anyone planning on going to the SEOUC in Feb. in Charlotte, North Carolina? It looks like I'll be presenting at it. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl)
RE: RE: komplex sql
Not on my data it doesn't. SQL select * from mytable; FIELD1 Jimmy J1000 No Info Timmy Jimmy J1000 Missing Info SQL @lee FIELD1 DECODE(FIELD1,'NOINF Jimmy J1000 Jimmy No Info No Info Timmy Jimmy J1000Timmy Missing Info Missing Info It may have helped if you had told us all EXACTLY what you wanted at the very start of this ever expanding list of questions. I personally cannot donate any more time to this thread. Lee -Original Message- Sent: 14 November 2001 12:25 To: Multiple recipients of list ORACLE-L But if I have this field1 Kenny Jenny A1000 Jenny L1000 No info Missing Info I would have: Kenny Jenny Jenny No info Missing Info How do I solve this: I just want the last word in the field to betaken away in the select statement. Roland Robertson Lee - lerobe [EMAIL PROTECTED]@fatcity.com den 2001-11-14 03:50 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: SELECT DECODE(field1,'No Info','No Info','Missing Info','Missing Info',ltrim(su bstr(field1,1,instr(field1,' ')-1))) FROM mytable This works I have ran it myself. eg. SQL @lee FIELD1 DECODE(FIELD1,'NOINF Jimmy J1000 Jimmy No Info No Info Timmy J1000 Timmy Missing Info Missing Info Roland, I don't mean to be harsh, but can I politely suggest that you get yourself either booked on or self study Oracle Basics. It seems that when someone provides you with a solution to a problem, rather than press ahead and solve the rest of it yourself you merely ask another question. For example, your previous question to this was how to get No info selected. Next you ask how to get Missing Info as well. Logic suggests that you merely repeat the solution you were given for the previous question re. No Info. Sorry if I appear to be giving a lecture here but of late it seems that you are throwing questions to the list without taking anytime to think about them yourself. Regards Lee -Original Message- Sent: 14 November 2001 10:50 To: Multiple recipients of list ORACLE-L Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 No Info Missing Info and I want the select to give me this: Jimmy Timmy No Info Missing Info You see It should still be 'No info' and 'Missing Info'after the select statement. How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in advance Roland S -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: 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,
RE: Next extent problem
Dennis, I'm not even sure what is the uniform extents (are you talking about the LMTS?). So I think the answer is no Gene --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Gene - Are you using uniform extents by any chance? Just thought it wouldn't hurt to ask. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 12, 2001 3:51 PM To: Multiple recipients of list ORACLE-L Deepak, thanks for the input. I have double-checked the pctincrease and it is set to 0 on all tables in my schema. Regarding the rounding up of the number of blocks, that would have explained if the extents were larger than my next extents size. As it now, my block size is 8K. The next extent - 512K - is 64blocks. The extents size are either 2 or 3 blocks only. Gene --- Deepak Thapliyal [EMAIL PROTECTED] wrote: check the value of pctincrease for your table from user_tables/dba_tables. note that the default pctincrease for tablespace is 50. my guess pctincrease value fo your table is non-zero alternatively, the size might be attributed to the fact that oracle rounds the number of blocks that make up the extent. i forget what that is .. my tired brain cells tell me that its something like 5 blocks or so . Deepak --- Gene Gurevich [EMAIL PROTECTED] wrote: Hi. I have two tables in my database. They both have the NEXT_EXTENT set to 512K for a long time. Yet all the extents for these tables are either 16 or 24K. I have checked the next extent sessing once and again and it has always shown 512K. The tables are not being truncated. Why would Oracle create the new extents with different size? Is there any other place I need to check? thanks for any input Gene = __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich 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). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal 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). = __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich 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: DENNIS WILLIAMS 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
RE: Power outage
Congrats on pulling yer A** out of the fire.. Amazing that it was a control file...given that L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF was showing as being unwriteable. Nice work -Original Message- Sent: Tuesday, November 13, 2001 7:35 PM To: Multiple recipients of list ORACLE-L I ran dbverify on the control files and found one that was corrupt. I edited the init.ora and took out the bad control file(I use two control files). Then I started up the database and it came up just fine. Made a new control file and I'm back up and running. Dave -Original Message- Sent: Tuesday, November 13, 2001 6:16 PM To: Multiple recipients of list ORACLE-L Hmm...well...yikesif you can place that file back, you might have a chance if what you need is in the online redo.. if you can't, and you need to go to a backup...it'll be a cold one scratching head -Original Message- Sent: Tuesday, November 13, 2001 6:55 PM To: Multiple recipients of list ORACLE-L That is correct -Original Message- Sent: Tuesday, November 13, 2001 5:20 PM To: Multiple recipients of list ORACLE-L I think you are in NOARCHIVELOG mode? Can you *see* L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF in Explorer? -Original Message- Sent: Tuesday, November 13, 2001 4:45 PM To: Multiple recipients of list ORACLE-L We had a power outage and the network admins found out that the UPS sucks. I have an Oracle 8.0.5 on NT 4.0 that got rudely bounced a couple of times due to loss of power. Now I have a problem in bringing it back up. Here is what I get in my SIDLGWR file. *** SESSION ID:(3.1) 2001.01.05.21.32.37.250 ORA-01110: data file 12: 'L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF' ORA-01114: IO error writing block to file 12 (block # 1) ORA-27072: skgfdisp: I/O error OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied. error 1242 detected in background process Dump file J:\ORA805\ADMIN\LV54\BDUMP\lv54LGWR.TRC Tue Nov 13 13:55:57 2001 ORACLE V8.0.5.0.0 - Production vsnsta=0 vsnsql=c vsnxtr=3 Windows NT V4.0, OS V5.101, CPU type 586 Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production Windows NT V4.0, OS V5.101, CPU type 586 Instance name: lv54 Redo thread mounted by this instance: 0 none Oracle process number: 4 pid: db I cannot get the database to mount. Any ideas!! Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: Mohan, Ross 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: Farnsworth, Dave 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: Mohan, Ross 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
Bug 1367773
Hi List, does anyone have description (body) of bug # 1367773 Thanks in advance, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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: seouc in Feb.
Title: seouc in Feb. Going to try, since it's only 30 min from the house. --Chris [EMAIL PROTECTED] -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 14, 2001 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: seouc in Feb. I know it's a little far in advance, but is anyone planning on going to the SEOUC in Feb. in Charlotte, North Carolina? It looks like I'll be presenting at it. Matt Adams - GE Appliances - [EMAIL PROTECTED] "Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi." - Larry Wall (creator of Perl)
RE: IDL_UB1$
Pl take a look at Note # 1021102.6 on Metalink. It may help you fix this problem.. HTH, Regards. - Kirti -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 7:51 AM To: Multiple recipients of list ORACLE-L Subject: IDL_UB1$ Hello All I found in our database, that some of the sys tables have many extents (up to 700). These are IDL_* tables and some other tables related to our heavy use of plsql packages (like sources$, dependency$ etc). On metalink I found that it is possible to change the next parameter of the table, but I would like to ask you if you know about a way how to recreate the existing fragmented tables? What option would be possible? (sorted by preference) 1.rebuild the table online without need to do anything else 2.rebuild the table online with a need to disconnect users 3.drop all packages/functions ..., truncate the tables (idl_ub1$ etc.) and load all sources from export (+catalog etc.) 4.recreate database + change next extent on the tables + load everything from export Or is there other posibility? The database is 8.1.7 on Linux Kind regards Ivo Libal -- 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: Deshpande, Kirti 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: Next extent problem
Gene, a shot-in-the-darkis your 'minimum extent' size set to 24K..? That is the only other thing that comes to my mind Cheers, RS --- Gene Gurevich [EMAIL PROTECTED] wrote: Dennis, I'm not even sure what is the uniform extents (are you talking about the LMTS?). So I think the answer is no Gene --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Gene - Are you using uniform extents by any chance? Just thought it wouldn't hurt to ask. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 12, 2001 3:51 PM To: Multiple recipients of list ORACLE-L Deepak, thanks for the input. I have double-checked the pctincrease and it is set to 0 on all tables in my schema. Regarding the rounding up of the number of blocks, that would have explained if the extents were larger than my next extents size. As it now, my block size is 8K. The next extent - 512K - is 64blocks. The extents size are either 2 or 3 blocks only. Gene --- Deepak Thapliyal [EMAIL PROTECTED] wrote: check the value of pctincrease for your table from user_tables/dba_tables. note that the default pctincrease for tablespace is 50. my guess pctincrease value fo your table is non-zero alternatively, the size might be attributed to the fact that oracle rounds the number of blocks that make up the extent. i forget what that is .. my tired brain cells tell me that its something like 5 blocks or so . Deepak --- Gene Gurevich [EMAIL PROTECTED] wrote: Hi. I have two tables in my database. They both have the NEXT_EXTENT set to 512K for a long time. Yet all the extents for these tables are either 16 or 24K. I have checked the next extent sessing once and again and it has always shown 512K. The tables are not being truncated. Why would Oracle create the new extents with different size? Is there any other place I need to check? thanks for any input Gene = __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich 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). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal 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). = __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich 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: === message truncated === __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ:
Re: STATSPACK Info
Raj, I think there is a book devoted to Statspack if you search Amazon or Bookpool. Scott Shafer San Antonio, TX Jamadagni, Rajendra wrote: Hope the list is up ... this message just returned to me about half hour ago ... Are there any docs available on interpreting statspack output other than the report itself? I checked Metalink but couldn't find much. Thanks in advance Raj _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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).
Personal Oracle tools on WIN98
Hi, I just installed Personal Oracle 8.1.7 on a win98 machine, this seems ok Now i want to installdeveloper 6i-rel 2 on this machine. But after starting the Oracle installer and fill in the company name I get the followingerror message The location specified "C:\Oracle\Ora81", is already used as an Oracle home for "Oracle 815 Production" It cannot be used as an Oracle Home for "Win95" What is wrong ? Regards Patrick
Re: seouc in Feb.
Hi, when exactly will it be ? cheers, Stefan Bowes, Chris schrieb: Going to try, since it's only 30 min from the house. --Chris [EMAIL PROTECTED] -Original Message- From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 8:59 AM To: Multiple recipients of list ORACLE-L Subject: seouc in Feb. I know it's a little far in advance, but is anyone planning on going to the SEOUC in Feb. in Charlotte, North Carolina? It looks like I'll be presenting at it. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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: ok..this is funny.. how do you pronounce tuple
Hi, it's just like Tulip, just kind of different... cheers, Stefan Thomas, Kevin schrieb: Kindof like tooyoupull only different...! ;o) -Original Message- Sent: 14 November 2001 11:05 To: Multiple recipients of list ORACLE-L Yeah - kind of like too-you-pull but a lot quicker.. -Original Message- Lee - lerobe Sent: 14 November 2001 08:30 To: Multiple recipients of list ORACLE-L Hmm, dilemma - neither tyu pul Mainly because thats what my Ingres Course Instructor used in class, many, many years ago. Lee -Original Message- Sent: 14 November 2001 04:55 To: Multiple recipients of list ORACLE-L Write out of good old relational theory.. So is it (too pul). or (tuh pall).. Thanks, D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Mark Leith 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: Thomas, Kevin 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). - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
Sorry, I wasn't paying attention to the headers. I thought it _WAS_ on the OT list... I will make sure Rachel flogs me with wet spaghetti as penance. --S Rachel Carmichael wrote: at this point guys move this to the ot list before Jared gets annoyed... but while I have your attention: I've SEEN Scott and Jeff in the same room. Ladies, find those chastity belts -;) --- Scott Shafer [EMAIL PROTECTED] wrote: Doh! Sorry for the oversite - lots on my mind lately. You're definitely invited, Jeff. We'll work sumthin' out. --S Jeffery Stevenson wrote: Bail money??? Why wasn't I invited? :) Yeah, like was mentioned, there's some positions available in Austin, but not as prevalent as it used to be. VC money has been tightened up so a lot of these companies looking to grow have been hit hard (and the bigger companies are just cutting back to save money). The problem I see though is that companies seem to be trimming back too much. I'm starting to hear little rumours here and there of companies going, Maybe we shouldn't have gotten rid of most of our support/operations people? It's not bad here though...it'll pick back up again...and I agree it's a great place to live. Guvm'nt jobs? Eep! Yeah Scott, I noticed that SA had about 4 times as many Oracle/DBA positions listed than Austin when I scouting the market for a friend who's looking at this area. That scared me... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Monday, November 12, 2001 9:30 PM To: Multiple recipients of list ORACLE-L Description for David, Yes you should drive down/me drive up to meet. Just let me get past some current difficulties. We could leave bail money with the wives! Hehehe... San Antonio (SA) has been hit, but definitely not as hard as Austin/Dallas/Houston. I'll probably regret this (if I end up competing for a job), but anyone looking for a job could do a lot worse than looking in SA. Most of the tech jobs here are government, gov/private consulting, or big company IT (USAA, MCI, SBC, etc). The largest industry however is tourism, which has been hammered. This doesn't affect techies much though. If one has no qualms about managing databases of bigger and better ways to break things and kill people, then DOD contracting is the way to go in Central Texas. Cost of living is very low, and SA is the 8th largest city in the US. Upsides: steady work, excellent food, mild winters, lots of recreational activities. Downsides: Inept city government, yearly drought, HOT for 9 months of the year. --Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 12, 2001 7:05 PM Description for Thanks folks for the replies I got. Compiled them into a sort of superDeveloper/Data Architect/All-Around wonderful human being job description. The job market in Austin is really poor for us high-tech types right now. This was the home or a principal branch office of a large number of failed dot coms and Internet business ventures. A partial list of Austin failures includes (but is by no means limited to): Netpliance Hand Technologies ConnectSouth (my alma mater) DrKoop.Com Garden.Com Furniture.Com carOrder.Com Layoffs in many (most?) surviving companies have further added to the glut of talent out on the streets. Other large Austin employers reducing staff in the tech area include AMD, Motorola, SamSung, IBM, Perficient and CSC. Non-tech companies such as law firms, travel agencies (they're pretty much toast right now anyway), and advertising agencies have been really hurt by the abrupt cessation of money which used to flow from the startups. It's still a great place to live, but a month or two ago, even the Austin American-Statesman noted that the area was experiencing a brain-drain as the job-seeker/jobs ratio climbed ever higher. Last week, they posited the major reason for the area not experiencing a total employment tragedy was the abundance of State and Local jobs, which, until about 9 months ago, went begging as private industry vacuumed anybody who could spell PC off the street (if you could spell DBA you had it made). The Sunday help-wanted ads have gone from 4 full pages of Computer Jobs to less than two columns, and there are very few senior positions available. We even used to have out-of-town companies advertise, but that trend has dried up as well. It anin't pretty folks. Maybe Scott (I still think I ought to drive down just to meet the guy)
Re[2]: Correction : EMC symetrix - 1M stripe width - Raid 0+
We're using the Symetrix storage system as well, but we did not use stripping, but full mirroring instead. Performance has been more than acceptable, but we really haven't pushed it I think. As far as the SAME (Stripe And Mirror Everything) idea from Oracle, that's great if you have the funds and space for all of those disk systems. Otherwise it's 'pie in the sky'. BTW, you SHOULD look into EMC's PowerPath software (if available on your system). This one allows the computer to balance IO across all of the ports available into the Symetrix. It really does improve matters. Dick Goulet Reply Separator Author: =?iso-8859-1?q?Connor=20McDonald?= [EMAIL PROTECTED] Date: 11/14/2001 2:10 AM Interestingly you could go back to Oracle support and ask them about the SAME method (as presented by an Oracle employee if I recall correctly at a user conference) - which advocated 1m stripes. You'll tend to face these battles with EMC - their sales people are great at things like you don't need to worry about where things are on the disk, or striping etc - our cache takes care of all of that...Yeah right! As a general guideline, I think you'd be better of with smaller stripe size, but you don't have to limit yourself - you could have fine granined striping for some parts of the system, and larger grains for other parts. hth connor --- [EMAIL PROTECTED] wrote: Hi, Application : OLTP Environment : Solaris 2.6 on a E10K Database : 8.0.5.2.1 We recently migrated from sun a5200 storage to EMC symetrix, and we have been seeing occasional performance problems. When contacted, Oracle support among other things pointed out the stripe width we have used 1M, is very large and also said users will not see an advantage above 64K. When we had Sun storage before we had 64K as the stripe width. Has anyone faced this kind of issue or has any comments..or can someone explain the low level impact of the stripe width on the ORACLE I/O operations? Much appreciated.. Regards Mohammed Ahsanuddin Oracle DBA -- 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: 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 Text (ConText/InterMedia) and realtime updates
Hey Tony, From my understanding of an Autonomous Transaction (which admittedly isn't much), the sync would always be one update behind, correct? Because the auto-trans would execute the sync in the trigger body, the current update/insert of the indexed column that caused the trigger to fire would not be committed at the time of sync. Or am I missing something here? I glanced at the Catalog Index feature and methinks it deserves smore investigation. Thanks! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, November 13, 2001 17:00 To: Multiple recipients of list ORACLE-L I would suggest researching an Autonomous Transaction fired from the trigger to get around the commit executed by CTX_DDL.SYNC_INDEX. Another approach I would pursue is to evaluate the use of Catalog Indexes (8.1.7). If your requirements fit within the catalog index limitations (more like an Intermedia Text-lite) then you are in luck since they are transactional, hence no need for periodic synchronization. HTH Tony Aponte -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: real newbie question (i think)
From 8.1.x upwards, there is a TO_LOB function to convert from longs. The best way would be for the app to understand CLOB's - but I guess thats not an option. If the longs are less than 32k, then you can use PL/SQL to search them - PL/SQL will support a varchar2(32767). hth connor --- Rich Davidson [EMAIL PROTECTED] wrote: hey all, i'm in your typical situation of we don't need a dba...oracle is an app so the bizapps guy can handle itright...now to reality. there is a column in our database (oracle is the back end of our crm package) that is defined as a long and they want to do keyword searches on it. i've found out that you can't use type long in a where clause. i guess i have a few questions and i'm going to assume the answers (if anyone answers...please oh please do) will be a matter of opinion. am i better off creating a new column in the existing table of the type clob or blob? should i create a new table to store this data? and what would be my best way to keep these columns in sync...every time someone updated the long column i would want my new column updated to reflect the change. right now we're on 8.0.6/win 2k...but could upgrade to 8.1.7 (means upgrading our crm package too) if it makes this process easier. thanks in advance for the help and not being a dba i hope what i wrote makes sense! *:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-: rich davidson dynamicsoft Inc. east hanover, nj [EMAIL PROTECTED] t. +1-973-503-6169 f. +1-973-952-5050 = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Personal Oracle tools on WIN98
Patrick, I had the same problem and round robin difficulties when I tried to install the WebDB 2.2 on a machine that had the 8.1.7 client. If you choose another location as the home it will fail and say it has to use the original Oracle home. I installed the developer 6i-rel 2 in a different directory on my client pc but I only have the client software installed for the database not the personal Oracle. My client software was installed before the 6i-rel 2 software and they both work. I access my Linux 8.1.7 database okay. Try picking a different load directory for the 6i. ROR mª¿ªm [EMAIL PROTECTED] 11/14/01 10:40AM Hi, I just installed Personal Oracle 8.1.7 on a win98 machine, this seems ok Now i want to install developer 6i-rel 2 on this machine. But after starting the Oracle installer and fill in the company name I get the following error message The location specified C:\Oracle\Ora81, is already used as an Oracle home for Oracle 815 Production It cannot be used as an Oracle Home for Win95 What is wrong ? Regards Patrick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: STATSPACK Info
Raj, http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html http://www.oracle.com/oramag/oracle/00-sep/index.html?o50tun.html http://www.oracle.com/oramag/oracle/00-nov/index.html?o60tun.html This was a 3 part series from the Oracle magazine. HTH Lee -Original Message- Sent: 14 November 2001 15:45 To: Multiple recipients of list ORACLE-L Raj, I think there is a book devoted to Statspack if you search Amazon or Bookpool. Scott Shafer San Antonio, TX Jamadagni, Rajendra wrote: Hope the list is up ... this message just returned to me about half hour ago ... Are there any docs available on interpreting statspack output other than the report itself? I checked Metalink but couldn't find much. Thanks in advance Raj _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: ok..this is funny.. how do you pronounce tuple
Tuple. Like Tupplewear. Bambi. -Original Message- Sent: Wednesday, November 14, 2001 10:15 AM To: Multiple recipients of list ORACLE-L Hi, it's just like Tulip, just kind of different... cheers, Stefan Thomas, Kevin schrieb: Kindof like tooyoupull only different...! ;o) -Original Message- Sent: 14 November 2001 11:05 To: Multiple recipients of list ORACLE-L Yeah - kind of like too-you-pull but a lot quicker.. -Original Message- Lee - lerobe Sent: 14 November 2001 08:30 To: Multiple recipients of list ORACLE-L Hmm, dilemma - neither tyu pul Mainly because thats what my Ingres Course Instructor used in class, many, many years ago. Lee -Original Message- Sent: 14 November 2001 04:55 To: Multiple recipients of list ORACLE-L Write out of good old relational theory.. So is it (too pul). or (tuh pall).. Thanks, D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Mark Leith 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: Thomas, Kevin 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). - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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
Enterprise Versus Standard
Does anyone have a good Oracle Standard to Oracle Enterprise comparison Chart ?? I am looking on the various Oracle ran sites and most of the docs seem to try and steer you to Enterprise. Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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: IDL_UB1$
Why do you think 700 extents is causing you a problem ? Just about every read to these tables will always be an indexed one (since the dictionary is rule-based), so its not going to matter too much how 'fragmented' things are. hth connor --- [EMAIL PROTECTED] wrote: Hello All I found in our database, that some of the sys tables have many extents (up to 700). These are IDL_* tables and some other tables related to our heavy use of plsql packages (like sources$, dependency$ etc). On metalink I found that it is possible to change the next parameter of the table, but I would like to ask you if you know about a way how to recreate the existing fragmented tables? What option would be possible? (sorted by preference) 1.rebuild the table online without need to do anything else 2.rebuild the table online with a need to disconnect users 3.drop all packages/functions ..., truncate the tables (idl_ub1$ etc.) and load all sources from export (+catalog etc.) 4.recreate database + change next extent on the tables + load everything from export Or is there other posibility? The database is 8.1.7 on Linux Kind regards Ivo Libal -- 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: seouc in Feb.
Stefan See http://seouc.orgFeb 21,22 2002 ROR mª¿ªm [EMAIL PROTECTED] 11/14/01 10:50AM Hi, when exactly will it be ? cheers, Stefan Bowes, Chris schrieb: Going to try, since it's only 30 min from the house. --Chris [EMAIL PROTECTED] -Original Message- From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 8:59 AM To: Multiple recipients of list ORACLE-L Subject: seouc in Feb. I know it's a little far in advance, but is anyone planning on going to the SEOUC in Feb. in Charlotte, North Carolina? It looks like I'll be presenting at it. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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: Ron Rogers 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: seouc in Feb.
Title: RE: seouc in Feb. SouthEastern Oracle Users Conference Feb 21-22, 2002 Charlotte, NC Sketchy details are available at www.seouc.org Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From: Stefan Jahnke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 10:50 AM To: Multiple recipients of list ORACLE-L Subject: Re: seouc in Feb. Hi, when exactly will it be ? cheers, Stefan Bowes, Chris schrieb: Going to try, since it's only 30 min from the house. --Chris [EMAIL PROTECTED] -Original Message- From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 8:59 AM To: Multiple recipients of list ORACLE-L Subject: seouc in Feb. I know it's a little far in advance, but is anyone planning on going to the SEOUC in Feb. in Charlotte, North Carolina? It looks like I'll be presenting at it. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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).
import/export problem in oem
hi,gurus help me ,in this problem through command prompt i got export/import facility .but with same user (with all permissions),i am not able to do same job. error is: The following error has occurred while trying to make the connection to the target database using preferential credentials ora-01031:insufficient previleges. thanks to all babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: hari babu gottipati 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).
Operating Systems
Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so aside from that, would anyone care to weigh in with opinions on what OS is most stable with Oracle? AAnd will run on an intel based box? Ours is not a high transaction system, mostly reads, maybe 100 users a day. Thanks for your opinions, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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: Enterprise Versus Standard
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 14, 2001 19:05 Does anyone have a good Oracle Standard to Oracle Enterprise comparison Chart ?? I am looking on the various Oracle ran sites and most of the docs seem to try and steer you to Enterprise. For 8i take a look at http://technet.oracle.com/products/oracle8i/pdf/8i_fam.pdf for 9i - http://technet.oracle.com/products/oracle9i/pdf/o9i_family_features.pdf hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov 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: Operating Systems
We're really happy w/ linux. We can't stand the notion of having our OS being rebooted every so often just so it can be run optimally. --Yohans On Wed, 14 Nov 2001, Regina Harter wrote: Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so aside from that, would anyone care to weigh in with opinions on what OS is most stable with Oracle? AAnd will run on an intel based box? Ours is not a high transaction system, mostly reads, maybe 100 users a day. Thanks for your opinions, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yohans Mendoza 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: Operating Systems
Linux or Solaris Intel. And maybe (gods help me! gulp) NT? Scott Shafer San Antonio, TX Regina Harter wrote: Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so aside from that, would anyone care to weigh in with opinions on what OS is most stable with Oracle? AAnd will run on an intel based box? Ours is not a high transaction system, mostly reads, maybe 100 users a day. Thanks for your opinions, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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: Operating Systems
This one is quite obvious: linux. The question is which flavor :). [EMAIL PROTECTED] 11/14/01 12:45PM Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so aside from that, would anyone care to weigh in with opinions on what OS is most stable with Oracle? AAnd will run on an intel based box? Ours is not a high transaction system, mostly reads, maybe 100 users a day. Thanks for your opinions, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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: Gene Sais 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: import/export problem in oem
Do you have sysdba or sysoper privs and are you connecting to OEM with sysdba/ Rick -Original Message- Sent: Wednesday, November 14, 2001 12:31 PM To: Multiple recipients of list ORACLE-L hi,gurus help me ,in this problem through command prompt i got export/import facility .but with same user (with all permissions),i am not able to do same job. error is: The following error has occurred while trying to make the connection to the target database using preferential credentials ora-01031:insufficient previleges. thanks to all babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: hari babu gottipati 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: Cale, Rick T (Richard) 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: ok..this is funny.. how do you pronounce tuple
I say to-may-to, You say to-mah-to; I say po-tay-to, You say po-tah-to; I say too-pul, You say tuh-pul There are N-1 ways to pronounce it. :^) -Original Message- Sent: Wednesday, November 14, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Tuple. Like Tupplewear. Bambi. -Original Message- Sent: Wednesday, November 14, 2001 10:15 AM To: Multiple recipients of list ORACLE-L Hi, it's just like Tulip, just kind of different... cheers, Stefan Thomas, Kevin schrieb: Kindof like tooyoupull only different...! ;o) -Original Message- Sent: 14 November 2001 11:05 To: Multiple recipients of list ORACLE-L Yeah - kind of like too-you-pull but a lot quicker.. -Original Message- Lee - lerobe Sent: 14 November 2001 08:30 To: Multiple recipients of list ORACLE-L Hmm, dilemma - neither tyu pul Mainly because thats what my Ingres Course Instructor used in class, many, many years ago. Lee -Original Message- Sent: 14 November 2001 04:55 To: Multiple recipients of list ORACLE-L Write out of good old relational theory.. So is it (too pul). or (tuh pall).. Thanks, D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Mark Leith 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: Thomas, Kevin 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). - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE
Re: Operating Systems
I chose Linux over Solaris for Intel because the Solaris did not support the hardware configuration I had to work with. The corporate bean-counters would prefer to pay for something rather than use a free and supported product. Very happy with the ease of admin and speed. ROR mª¿ªm [EMAIL PROTECTED] 11/14/01 01:12PM Linux or Solaris Intel. And maybe (gods help me! gulp) NT? Scott Shafer San Antonio, TX Regina Harter wrote: Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so aside from that, would anyone care to weigh in with opinions on what OS is most stable with Oracle? AAnd will run on an intel based box? Ours is not a high transaction system, mostly reads, maybe 100 users a day. Thanks for your opinions, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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: Ron Rogers 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: Operating Systems
Scott, NT? I think the habaneros and tequila have finally taken over... ;) Seriously, stay away from NT. I have the unfortunate task of monitoring a few minor databases on NT in addition to my Unix ones, and I hate every minute of it. The locks it places on open files prevent you from doing a lot of things with the database up, it has to be rebooted every month, and it is a nightmare to administer remotely. We use pcAnywhere which only allows one user in at a time. I curse NT and Gates every day... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 14, 2001 12:13 PM To: Multiple recipients of list ORACLE-L Linux or Solaris Intel. And maybe (gods help me! gulp) NT? Scott Shafer San Antonio, TX Regina Harter wrote: Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so aside from that, would anyone care to weigh in with opinions on what OS is most stable with Oracle? AAnd will run on an intel based box? Ours is not a high transaction system, mostly reads, maybe 100 users a day. Thanks for your opinions, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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: HAWKINS, JAMES W [IT/1000] 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: Operating Systems
Regina Harter wrote: Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so aside from that, would anyone care to weigh in with opinions on what OS is most stable with Oracle? AAnd will run on an intel based box? Ours is not a high transaction system, mostly reads, maybe 100 users a day. Thanks for your opinions, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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). Look at Linux. Many flavors are certified now. -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 begin:vcard n:Holman;Rodd tel;cell:(605) 201-3562 tel;fax:(605) 988-1599 tel;work:(605) 988-1373 x-mozilla-html:TRUE url:www.splitrocktel.net/~roddty org:LodgeNet Entertainment Corporation;IS/Enterprise Operations adr:;;3900 W. Innovation St.;Sioux Falls;SD;57107;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Enterprise Data Systems Engineer x-mozilla-cpt:;-16352 fn:Rodd Holman end:vcard
Re: real newbie question (i think)
Hi Rich am i better off creating a new column in the existing table of the type clob or blob? should i create a new table to store this data? This depends on what kind of queries hit this table. If most of your queries hit columns other than the lob then you are justified in creating new table for the lob so you have a 1-to-1 relationship between your original and lob table. obviously in order to tie your records of the lob table with the original table, include the pk of ur original table in the lob table and make it a FK pointing to the original table. having said that, note that clob/blob is inline storage for data less than 250K (or some thing). Beyond that # the data will get stored outside in the lob tablespace you specified. and what would be my best way to keep these columns in sync...every time someone updated the long column i would want my new column updated to reflect the change Does the foreign key creation stuff i wrote above answer this question. If not, please elaborate by what you mean by the new column should reflect change Deepak --- Rich Davidson [EMAIL PROTECTED] wrote: hey all, i'm in your typical situation of we don't need a dba...oracle is an app so the bizapps guy can handle itright...now to reality. there is a column in our database (oracle is the back end of our crm package) that is defined as a long and they want to do keyword searches on it. i've found out that you can't use type long in a where clause. i guess i have a few questions and i'm going to assume the answers (if anyone answers...please oh please do) will be a matter of opinion. am i better off creating a new column in the existing table of the type clob or blob? should i create a new table to store this data? and what would be my best way to keep these columns in sync...every time someone updated the long column i would want my new column updated to reflect the change. right now we're on 8.0.6/win 2k...but could upgrade to 8.1.7 (means upgrading our crm package too) if it makes this process easier. thanks in advance for the help and not being a dba i hope what i wrote makes sense! *:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-: rich davidson dynamicsoft Inc. east hanover, nj [EMAIL PROTECTED] t. +1-973-503-6169 f. +1-973-952-5050 __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal 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:
money for one; Deepak PS: enterprize has bunch of more features than standard including tspitr support and partitions.. for more check out technet.oracle.com --- grace [EMAIL PROTECTED] wrote: hi gurus, wat's the difference of 8i ias standard and enterprise? Best regards, Grace Lim Suy Sing Comm'l Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace 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). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal 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: lack of memory
Edward, how about checking your processes parameter and then multiplying that # with your sort area size .. thats would give you a good idea about the size of your PGA .. also i guess there is a 250 K overhead per connection so you need to add that as well. for more accurate information, yopu could run a pmap for all local connections (connection coming from app) and then grep for the value besides the stack label to get exact PGA on a per connection basis. This assumes you are on unix..how big is your SGA? Deepak --- Edward Shevtsov [EMAIL PROTECTED] wrote: Connor, thanks for the reply. I'd thought about it. Unfortunately, it's quite difficult to catch the difference as number of users is not constant and they do different job (oltp queries, big reports). Thanks, Ed (Of course depending on the app), its seems odd that 4G is insufficient for 400 users. Maybe start having a look at the uga/pga stats for connected sessions and seeing what this adds up to. hth connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal 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: lack of memory
Edward, why you thinking of going MTS route to support just 400-500 users. On 4GB like you have, i can support 2000+ users (non-mts) with no problems .. most of the boxes are E-450's, 4500's Deepak --- Connor McDonald [EMAIL PROTECTED] wrote: (Of course depending on the app), its seems odd that 4G is insufficient for 400 users. Maybe start having a look at the uga/pga stats for connected sessions and seeing what this adds up to. hth connor --- Edward Shevtsov [EMAIL PROTECTED] wrote: Hi List, We use a server with 4Gb memory on Linux kernel 2.2.19, Oracle 8.1.7.0 dedicated mode. It's an OLTP system with about 450 users. About 2 months ago I initiated gradual migration of our sql code to use bind variables instead of literals because we had problems with shared pool's fragmentation and strong contention on shared pool and library cache latches. The 90% of sql is accumulated on the client side (BDE+Delphi). I cut 150M from shared pool and planned cut it down further as we get results from the migration. Despite that now we have lack of memory. It seems now user processes consume more memory. We can't increase memory because of limitations on kernel 2.2. In general Is there any significant difference in terms of memory consumtion between a user process that uses bind variables and another one that uses literals? Does anyone use 8.1.7, MTS mode on Linux for a system with similar loading (400-500 users). Is that stable enough?. I have doubts. Please help. Regards, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal 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: Re[2]: Correction : EMC symetrix - 1M stripe width - Raid 0+
I have used the Symmetrix with hardware mirroring and software (Veritas Volume Manager) striping and seen significant performance gains over just mirroring in the Sym. It is going to depend a lot on your I/O patterns and volume though. I have used SAME, but in general wouldn't really recommend it for most systems (based on the concept though, not the stripe size). Sure it is easy, but it isn't usually optimal. (If this is the same SAME I am thinking of - stripe and mirror everything across everything.) The EMC cache will buy a lot, but in the most demanding systems it is still important to segregate some physical I/O to distinct disks/disksets to reduce contention - and in the case of EMC, to better utilize the cache. I agree whole-heartedly on PowerPath! As always, I would recommend reading Gaja's paper at http://www.quest.com/whitepapers/Raid1.pdf -Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 14, 2001 10:15 AM We're using the Symetrix storage system as well, but we did not use stripping, but full mirroring instead. Performance has been more than acceptable, but we really haven't pushed it I think. As far as the SAME (Stripe And Mirror Everything) idea from Oracle, that's great if you have the funds and space for all of those disk systems. Otherwise it's 'pie in the sky'. BTW, you SHOULD look into EMC's PowerPath software (if available on your system). This one allows the computer to balance IO across all of the ports available into the Symetrix. It really does improve matters. Dick Goulet Reply Separator Author: =?iso-8859-1?q?Connor=20McDonald?= [EMAIL PROTECTED] Date: 11/14/2001 2:10 AM Interestingly you could go back to Oracle support and ask them about the SAME method (as presented by an Oracle employee if I recall correctly at a user conference) - which advocated 1m stripes. You'll tend to face these battles with EMC - their sales people are great at things like you don't need to worry about where things are on the disk, or striping etc - our cache takes care of all of that...Yeah right! As a general guideline, I think you'd be better of with smaller stripe size, but you don't have to limit yourself - you could have fine granined striping for some parts of the system, and larger grains for other parts. hth connor --- [EMAIL PROTECTED] wrote: Hi, Application : OLTP Environment : Solaris 2.6 on a E10K Database : 8.0.5.2.1 We recently migrated from sun a5200 storage to EMC symetrix, and we have been seeing occasional performance problems. When contacted, Oracle support among other things pointed out the stripe width we have used 1M, is very large and also said users will not see an advantage above 64K. When we had Sun storage before we had 64K as the stripe width. Has anyone faced this kind of issue or has any comments..or can someone explain the low level impact of the stripe width on the ORACLE I/O operations? Much appreciated.. Regards Mohammed Ahsanuddin Oracle DBA -- 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: INET: [EMAIL
Re:real newbie question (i think)
Rich, Since no one has yet posted an answer, here is my opinion/questions. 1) Why do you want the 'new column'? What it looks like it that you just need to query the table for the keywords your interested in. The 'like' operator shoudl work just fine. 2) A long can contain 2GB worth of data, why on earth would you want to use a CLOB or BLOB? Dick Goulet Reply Separator Author: Rich Davidson [EMAIL PROTECTED] Date: 11/14/2001 5:30 AM hey all, i'm in your typical situation of we don't need a dba...oracle is an app so the bizapps guy can handle itright...now to reality. there is a column in our database (oracle is the back end of our crm package) that is defined as a long and they want to do keyword searches on it. i've found out that you can't use type long in a where clause. i guess i have a few questions and i'm going to assume the answers (if anyone answers...please oh please do) will be a matter of opinion. am i better off creating a new column in the existing table of the type clob or blob? should i create a new table to store this data? and what would be my best way to keep these columns in sync...every time someone updated the long column i would want my new column updated to reflect the change. right now we're on 8.0.6/win 2k...but could upgrade to 8.1.7 (means upgrading our crm package too) if it makes this process easier. thanks in advance for the help and not being a dba i hope what i wrote makes sense! *:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-: rich davidson dynamicsoft Inc. east hanover, nj [EMAIL PROTECTED] t. +1-973-503-6169 f. +1-973-952-5050 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 TITLEhow to extract text from LONG field/TITLE META content=MSHTML 6.00.2600.0 name=GENERATOR/HEAD BODY DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2hey allSPAN class=540272013-14112001,/SPAN/FONT/FONT/FONT/SPAN/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001/SPAN/FONT/FONT/FONT/SPANnbsp;/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001i'm in your typical situation of we don't need a dba...oracle is an app so the bizapps guy can handle itright...now to reality.nbsp; there is a column in our database (oracle isnbsp;the back end of our crm package) that is defined as a long and they want to do keyword searches on it.nbsp; i've found out that you can't use type long in a where clause./SPAN/FONT/FONT/FONT/SPAN/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001/SPAN/FONT/FONT/FONT/SPANnbsp;/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001i guess i have a few questions and i'm going to assume the answers (if anyone answers...please oh please do) will be a matter of opinion.nbsp; am i better off creating a new column in the existing table of the type clob or blob?nbsp; should i create a new table to store this data?nbsp; and what would be my best way to keep these columns in sync...every time someone updated the long column i would want my new column updated to reflect the change./SPAN/FONT/FONT/FONT/SPAN/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001/SPAN/FONT/FONT/FONT/SPANnbsp;/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001right now we're on 8.0.6/win 2k...but could upgrade to 8.1.7 (means upgrading our crm package too) if it makes this process easier./SPAN/FONT/FONT/FONT/SPAN/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001/SPAN/FONT/FONT/FONT/SPANnbsp;/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001thanks in advance for the help and not being a dba i hope what i wrote makes sense!/SPAN/FONT/FONT/FONT/SPAN/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001 PFONT face=Courier New size=2*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:/FONT BRFONT face=Arial size=2rich davidson/FONT BRFONT face=Arial size=2dynamicsoft Inc./FONT BRFONT face=Arial size=2east hanover, nj/FONT /P PFONT face=Arial size=2[EMAIL PROTECTED]/FONT BRFONT face=Arial size=2t. +1-973-503-6169/FONT BRFONT face=Arial size=2f. +1-973-952-5050/FONT /P/SPAN/FONT/FONT/FONT/SPAN/DIV/BODY/HTML -- 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
Re:Operating Systems
Red Hat Linux. Dick Goulet Reply Separator Author: Regina Harter [EMAIL PROTECTED] Date: 11/14/2001 9:45 AM Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so aside from that, would anyone care to weigh in with opinions on what OS is most stable with Oracle? AAnd will run on an intel based box? Ours is not a high transaction system, mostly reads, maybe 100 users a day. Thanks for your opinions, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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: 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).
Online index rebuilds
Compressed indexes: The docs don't say that compressed indexes cannot be rebuilt online but it doesn't work for me. I can rebuild normal indexes online, I can rebuild an index and compress it but I can't do both. Compute statistics: SQL alter index name rebuild online compute statistics nologging; Online rebuilds with compute statistics don't work either and the docs don't say there's a restriction on this. Are these documentation bugs or software bugs? (O8172/RedHat6.2) Steve Orr Bozeman, MT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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 Text (ConText/InterMedia) and realtime updates
So, I fire up a Catalog Index on a column with an associated column in the index set (for ordering the results) and it comes back 10-12 times faster than the Context Index. The problem is that the result sets weren't the same. Upon investigating, I found out that catalog index searching (catsearch) doesn't support wildcards, which we need. Bummer! Oh well, back to contexts. Thanks for your input! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, November 13, 2001 17:00 To: Multiple recipients of list ORACLE-L I would suggest researching an Autonomous Transaction fired from the trigger to get around the commit executed by CTX_DDL.SYNC_INDEX. Another approach I would pursue is to evaluate the use of Catalog Indexes (8.1.7). If your requirements fit within the catalog index limitations (more like an Intermedia Text-lite) then you are in luck since they are transactional, hence no need for periodic synchronization. HTH Tony Aponte -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Operating Systems
Does Oracle sell a version for Solaris on Intel? I thought they only offered Oracle for SPARC Solaris. Mind you it wouldn't be a bad thing if they did offer Oracle for Solaris on Intel, esp. now that the Alphas are owned by the people developing the Itanium platform. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Subject:Re: Operating Systems I chose Linux over Solaris for Intel because the Solaris did not support the hardware configuration I had to work with. The corporate bean-counters would prefer to pay for something rather than use a free and supported product. Very happy with the ease of admin and speed. ROR mª¿ªm [EMAIL PROTECTED] 11/14/01 01:12PM Linux or Solaris Intel. And maybe (gods help me! gulp) NT? Scott Shafer San Antonio, TX Regina Harter wrote: Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so aside from that, would anyone care to weigh in with opinions on what OS is most stable with Oracle? AAnd will run on an intel based box? Ours is not a high transaction system, mostly reads, maybe 100 users a day. Thanks for your opinions, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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: Ron Rogers 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: 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).
RE: real newbie question (i think)
Hi Dick... Here are some thoughts... 1) You can't use the like operator on the LONG datatype... You will get an inconsistent datatype error... 2) A bunch of reasons... a) LONG are going away someday b) You can store LOB data out of line with the table to improve performance c) You can more than one LOB per table d) You can partition a table with LOB's but not one with a LONG e) LOB's support random access to the data f) There a bunch of built in functions to access LOB's ( check out the DBMS_LOB package ) Tim -Original Message- Sent: Wednesday, November 14, 2001 2:23 PM To: Multiple recipients of list ORACLE-L Rich, Since no one has yet posted an answer, here is my opinion/questions. 1) Why do you want the 'new column'? What it looks like it that you just need to query the table for the keywords your interested in. The 'like' operator shoudl work just fine. 2) A long can contain 2GB worth of data, why on earth would you want to use a CLOB or BLOB? Dick Goulet Reply Separator Author: Rich Davidson [EMAIL PROTECTED] Date: 11/14/2001 5:30 AM hey all, i'm in your typical situation of we don't need a dba...oracle is an app so the bizapps guy can handle itright...now to reality. there is a column in our database (oracle is the back end of our crm package) that is defined as a long and they want to do keyword searches on it. i've found out that you can't use type long in a where clause. i guess i have a few questions and i'm going to assume the answers (if anyone answers...please oh please do) will be a matter of opinion. am i better off creating a new column in the existing table of the type clob or blob? should i create a new table to store this data? and what would be my best way to keep these columns in sync...every time someone updated the long column i would want my new column updated to reflect the change. right now we're on 8.0.6/win 2k...but could upgrade to 8.1.7 (means upgrading our crm package too) if it makes this process easier. thanks in advance for the help and not being a dba i hope what i wrote makes sense! *:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-: rich davidson dynamicsoft Inc. east hanover, nj [EMAIL PROTECTED] t. +1-973-503-6169 f. +1-973-952-5050 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 TITLEhow to extract text from LONG field/TITLE META content=MSHTML 6.00.2600.0 name=GENERATOR/HEAD BODY DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2hey allSPAN class=540272013-14112001,/SPAN/FONT/FONT/FONT/SPAN/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001/SPAN/FONT/FONT/FONT/SPANnbsp;/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001i'm in your typical situation of we don't need a dba...oracle is an app so the bizapps guy can handle itright...now to reality.nbsp; there is a column in our database (oracle isnbsp;the back end of our crm package) that is defined as a long and they want to do keyword searches on it.nbsp; i've found out that you can't use type long in a where clause./SPAN/FONT/FONT/FONT/SPAN/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001/SPAN/FONT/FONT/FONT/SPANnbsp;/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001i guess i have a few questions and i'm going to assume the answers (if anyone answers...please oh please do) will be a matter of opinion.nbsp; am i better off creating a new column in the existing table of the type clob or blob?nbsp; should i create a new table to store this data?nbsp; and what would be my best way to keep these columns in sync...every time someone updated the long column i would want my new column updated to reflect the change./SPAN/FONT/FONT/FONT/SPAN/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001/SPAN/FONT/FONT/FONT/SPANnbsp;/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001right now we're on 8.0.6/win 2k...but could upgrade to 8.1.7 (means upgrading our crm package too) if it makes this process easier./SPAN/FONT/FONT/FONT/SPAN/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001/SPAN/FONT/FONT/FONT/SPANnbsp;/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001thanks in advance for the help and not being a dba i hope what i wrote makes sense!/SPAN/FONT/FONT/FONT/SPAN/DIV DIVSPAN class=540272013-14112001FONT face=ArialFONT color=#ffFONT size=2SPAN class=540272013-14112001
ORA-1410
Title: ORA-1410 Hi, I am running the following command analyze table BLOB compute statistics and I am getting the following error. * ERROR at line 1: ORA-01410: invalid ROWID Metal link tell me to export,drop,import the table. Does anyone know of a way to fix the table without dropping it ?? TIA Yuval.
Re: ORACLE-L Digest -- Volume 2001, Number 318
And the SAs *are* going to run weekly/monthly UPS tests from now on, right? :) regards, ep ORACLE-L Digest -- Volume 2001, Number 318 -- From: Farnsworth, Dave [EMAIL PROTECTED] Date: Tue, 13 Nov 2001 18:32:16 -0600 Subject: RE: Power outage I ran dbverify on the control files and found one that was corrupt. I edited the init.ora and took out the bad control file(I use two control files). Then I started up the database and it came up just fine. Made a new control file and I'm back up and running. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: Operating Systems
Patrice: Oracle for Solaris x86 has been out for a while. I am running it on one of my machines at home. It's Oracle! It's Solaris! It's Intel (AMD in my case)! It's a 3-in-1 wonder toy! ;-) Seriously, take a look at http://store.oracle.com under the CD Packs area. There will be one for Sun Solaris Intel. Boivin, Patrice J wrote: Does Oracle sell a version for Solaris on Intel? I thought they only offered Oracle for SPARC Solaris. Mind you it wouldn't be a bad thing if they did offer Oracle for Solaris on Intel, esp. now that the Alphas are owned by the people developing the Itanium platform. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Subject:Re: Operating Systems I chose Linux over Solaris for Intel because the Solaris did not support the hardware configuration I had to work with. The corporate bean-counters would prefer to pay for something rather than use a free and supported product. Very happy with the ease of admin and speed. ROR mª¿ªm [EMAIL PROTECTED] 11/14/01 01:12PM Linux or Solaris Intel. And maybe (gods help me! gulp) NT? Scott Shafer San Antonio, TX Regina Harter wrote: Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so aside from that, would anyone care to weigh in with opinions on what OS is most stable with Oracle? AAnd will run on an intel based box? Ours is not a high transaction system, mostly reads, maybe 100 users a day. Thanks for your opinions, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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: Ron Rogers 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: 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
Re: Correction : EMC symetrix - 1M stripe width - Raid 0+
I agree with Don. We have always found it better to mirror at the EMC Symmetrix level and then handle striping requirements via the volume manager (such as Veritas Volume Manager). In fact, I presented a paper on this at IOUG-A last year. The bottom line is to make sure that you properly design it. Just because it's on an EMC doesn't mean that you shouldn't build the system as optimally as possible. If you optimize the system and use the EMC intelligence and caching to enhance your performance, you'll get much better results than resoring to cache-based tuning. If you tune based on cache, then the only way you'll ever be able to optimize is to buy more and more cache . . .which, of course, costs you cash. :-) Don Granaman wrote: I have used the Symmetrix with hardware mirroring and software (Veritas Volume Manager) striping and seen significant performance gains over just mirroring in the Sym. It is going to depend a lot on your I/O patterns and volume though. I have used SAME, but in general wouldn't really recommend it for most systems (based on the concept though, not the stripe size). Sure it is easy, but it isn't usually optimal. (If this is the same SAME I am thinking of - stripe and mirror everything across everything.) The EMC cache will buy a lot, but in the most demanding systems it is still important to segregate some physical I/O to distinct disks/disksets to reduce contention - and in the case of EMC, to better utilize the cache. I agree whole-heartedly on PowerPath! As always, I would recommend reading Gaja's paper at http://www.quest.com/whitepapers/Raid1.pdf -Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 14, 2001 10:15 AM We're using the Symetrix storage system as well, but we did not use stripping, but full mirroring instead. Performance has been more than acceptable, but we really haven't pushed it I think. As far as the SAME (Stripe And Mirror Everything) idea from Oracle, that's great if you have the funds and space for all of those disk systems. Otherwise it's 'pie in the sky'. BTW, you SHOULD look into EMC's PowerPath software (if available on your system). This one allows the computer to balance IO across all of the ports available into the Symetrix. It really does improve matters. Dick Goulet Reply Separator Author: =?iso-8859-1?q?Connor=20McDonald?= [EMAIL PROTECTED] Date: 11/14/2001 2:10 AM Interestingly you could go back to Oracle support and ask them about the SAME method (as presented by an Oracle employee if I recall correctly at a user conference) - which advocated 1m stripes. You'll tend to face these battles with EMC - their sales people are great at things like you don't need to worry about where things are on the disk, or striping etc - our cache takes care of all of that...Yeah right! As a general guideline, I think you'd be better of with smaller stripe size, but you don't have to limit yourself - you could have fine granined striping for some parts of the system, and larger grains for other parts. hth connor --- [EMAIL PROTECTED] wrote: Hi, Application : OLTP Environment : Solaris 2.6 on a E10K Database : 8.0.5.2.1 We recently migrated from sun a5200 storage to EMC symetrix, and we have been seeing occasional performance problems. When contacted, Oracle support among other things pointed out the stripe width we have used 1M, is very large and also said users will not see an advantage above 64K. When we had Sun storage before we had 64K as the stripe width. Has anyone faced this kind of issue or has any comments..or can someone explain the low level impact of the stripe width on the ORACLE I/O operations? Much appreciated.. Regards Mohammed Ahsanuddin Oracle DBA -- 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need
RE: Operating Systems
Patrice, Oracle Database 8i Release 3 (8.1.7 cd pack for Solaris Intel Apr-01 release Part # CDP No. A89290-01 v2 contains: 8i rel3 8.1.7 Enterprise Edition 8i rel3 8.1.7 Standard Edition 8i rel3 8.1.7. Client for MSWIN95/98/2000/NT Oracle Internet File System rel 1.1.9 for MS2000/nt OEM rel 2.2 w/tuning,mgmt,diag packs OEM rel2.2 For Oracle Standard Management Pack Oracle Management Pack rel 2.2 for Oracle Applications Oracle Management Pack rel 2.2 for SAP R/3 Oracle Workflow Server rel2.6 for MSNT and Sun SPARC Solaris Oracle Workflow Client rel2.6 for MSNT Oracle Message Broker rel2.0.1 for MSNT Oracle Applications InterConnect rel4.0 for MSNT Oracle Visual Workbench for Oracle Procedural Gateway for IBM MQSeries rel 8.0.4.1.0 for MSNT Plus the usual DOC CD'S Ron ROR mª¿ªm [EMAIL PROTECTED] 11/14/01 02:40PM Does Oracle sell a version for Solaris on Intel? I thought they only offered Oracle for SPARC Solaris. Mind you it wouldn't be a bad thing if they did offer Oracle for Solaris on Intel, esp. now that the Alphas are owned by the people developing the Itanium platform. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Subject:Re: Operating Systems I chose Linux over Solaris for Intel because the Solaris did not support the hardware configuration I had to work with. The corporate bean-counters would prefer to pay for something rather than use a free and supported product. Very happy with the ease of admin and speed. ROR mª¿ªm [EMAIL PROTECTED] 11/14/01 01:12PM Linux or Solaris Intel. And maybe (gods help me! gulp) NT? Scott Shafer San Antonio, TX Regina Harter wrote: Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so aside from that, would anyone care to weigh in with opinions on what OS is most stable with Oracle? AAnd will run on an intel based box? Ours is not a high transaction system, mostly reads, maybe 100 users a day. Thanks for your opinions, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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: Ron Rogers 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:
Disk Layout Document
Listers, Okay, I've been googling for about an hour now and can't find it. It seems like I remember seeing a white paper, note, or some sort of reference detailing preferred file layouts based on different number of disks -- e.g. 4 disks try this, with 5 disks try that. Does that ring a bell? And if so, can anyone send me the link? In the meantime, back to my google gun. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins 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).
Internal Benchmarking
Howdy All, I want to create some database-only benchmarking scripts to reflect a typical day in the life of a custom application. I'm thinking about using LogMiner to get the redo and v$sqlarea to derive a representative mix of queries. Maybe we can also sniff/parse the network traffic to the DB server. Since I'm looking only at database activity I'm not too keen on applications which merely record and replay end-user keystrokes and mouse clicks but I would like to mimic delays in transaction commits due to network latency and user indecision or whatever. I'd also like to be able to increase the load intensity by factors of 10 to 1000. Has anyone created any application specific benchmark routines and can you share some tips on how to do this? Any good tools that you have used? Any comments on Mercury Interactive stuff? Other ideas? AtDhVaAnNkCsE, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: Operating Systems
If there are no issues with Solaris on Intel, I would be enclined to prefer that to LINUX or NT. Just an opinion, and I haven't worked with Oracle on Solaris for Intel, but it sounds good to me! Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Byron Pearce [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 4:07 PM To: Multiple recipients of list ORACLE-L Subject:Re: Operating Systems Patrice: Oracle for Solaris x86 has been out for a while. I am running it on one of my machines at home. It's Oracle! It's Solaris! It's Intel (AMD in my case)! It's a 3-in-1 wonder toy! ;-) Seriously, take a look at http://store.oracle.com under the CD Packs area. There will be one for Sun Solaris Intel. Boivin, Patrice J wrote: Does Oracle sell a version for Solaris on Intel? I thought they only offered Oracle for SPARC Solaris. Mind you it wouldn't be a bad thing if they did offer Oracle for Solaris on Intel, esp. now that the Alphas are owned by the people developing the Itanium platform. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Subject:Re: Operating Systems I chose Linux over Solaris for Intel because the Solaris did not support the hardware configuration I had to work with. The corporate bean-counters would prefer to pay for something rather than use a free and supported product. Very happy with the ease of admin and speed. ROR mª¿ªm [EMAIL PROTECTED] 11/14/01 01:12PM Linux or Solaris Intel. And maybe (gods help me! gulp) NT? Scott Shafer San Antonio, TX Regina Harter wrote: Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so aside from that, would anyone care to weigh in with opinions on what OS is most stable with Oracle? AAnd will run on an intel based box? Ours is not a high transaction system, mostly reads, maybe 100 users a day. Thanks for your opinions, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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: Disk Layout Document
I believe the Oracle DBA Handbook by Kevin Loney has that... -Original Message- Sent: Wednesday, November 14, 2001 3:45 PM To: Multiple recipients of list ORACLE-L Listers, Okay, I've been googling for about an hour now and can't find it. It seems like I remember seeing a white paper, note, or some sort of reference detailing preferred file layouts based on different number of disks -- e.g. 4 disks try this, with 5 disks try that. Does that ring a bell? And if so, can anyone send me the link? In the meantime, back to my google gun. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins 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: Grabowy, Chris 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).