how is this possible??
hello... i am faced with an enigma. SQL select * from p_sku@shopowner_lnk where sku_cd not in 2 (select sku_cd from p_sku); no rows selected SQL delete from p_sku@shopowner_lnk where sku_cd not in ( 2 select sku_cd from p_sku); 2 rows deleted. there are no triggers on any of these objects. SQL select * from dba_triggers where table_name like '%SKU%'; no rows selected this 8.1.6 db lives on sun-ultra 60 (solaris). if there are no rows returned for the select statement, how can there be a delete? i'm trying to solve a problem for progammers. any feedback would be most appreciated. thanks, kris austin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kris Austin 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).
Fast Refresh of Snaphots Locking?
When we do a fast refresh of a snapshot and the number of entries in the log are high (750,000+) our users complain about poor performance for approximately a 5 - 10 minute period. (This occurs in the database where the master resides) As of yet I have not been notified in a timely manner to investigate as it is occuring. I thought there was no locking on the master site, so my initial reaction is that this is not the issue. It is also strange that it is a short period of time. I believe much shorter than the time it takes to refresh the snapshot. Also, only appears to be an issue with a large (in our shop) number of transactions in the snapshot log. No complaints any other time. Has anybody seen any threshold limit for refreshing incrementally (fast)? Is there locking occuring on dictionary tables which is extended in length due to the number of transactions? Any thoughts? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow 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: Snapshot performance issue
I forgot to tell you that I'm working on release 8.1.7 and if I'm not mistaken indexes like 'SNAP_$' do no more exist. Please, correct me if I'm mistaken. -Message d'origine- De : Mike J Kurth [mailto:[EMAIL PROTECTED]] Envoyé : mardi 11 septembre 2001 08:25 À : Multiple recipients of list ORACLE-L Objet : Re: Snapshot performance issue It may be that the name of your index has changed. It is probably something like I_snap$_E I_REF_EMETTEUR. You will need to change the hint to reflect the change. 01 01:40 AM PST Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I have a view based on the query below which is executed in a reasonable way on the master site but this same view takes hours on the snapshot site. Any idea CREATE OR REPLACE VIEW V_ENTITE_EMETTEUR2 AS select /*+ ORDERED USE_NL(E A SI SY O LF MO AM MR ST) INDEX(E I_REF_EMETTEUR) */ E.COMP_EMETTEUR, E.NOM_STATION, E.REF_EMETTEUR, E.PIRE, E.PIRE_CALCULEE, E.HAUT_SOL_ANT, E.AZIMUT, E.ELEVATION, E.OWNER, E.CODE_INTERNE_TS, E.CODE_INTERNE_TC, E.DEP_CODE_GESTION, SY.COMP_SYSTEME, SY.NOM_SYSTEME, O.COMP_OPERATEUR, O.CODE_OPERATEUR, SI.COMP_SITE, SI.REF_SITE, SI.NOM_SITE, A.COMP_ANTENNE, A.NOM_ANT, MO.REF_MODU, AM.REF_AMPLI, MR.REF_MAT_RECEPT, LF.CODE_ETAT, ST.CODE from t_station E, t_antena A, t_site SI, t_system SY, t_operator O, t_lf_states LF, v_station_modu MO, v_station_ampli AM, v_station_recept MR, t_status ST where E.COMP_SYSTEME = SY.COMP_SYSTEME and E.COMP_OPERATEUR = O.COMP_OPERATEUR and E.COMP_SYSTEME = O.COMP_SYSTEME and E.COMP_SITE = SI.COMP_SITE and E.COMP_ANTENNE = A.COMP_ANTENNE and E.COMP_EMETTEUR = MO.COMP_EMETTEUR (+) and E.COMP_EMETTEUR = AM.COMP_EMETTEUR(+) and E.COMP_EMETTEUR = MR.COMP_EMETTEUR(+) and not (E.SUPPR_A_ANALYSER_FAE is not null and E.SUPPR_A_ANALYSER_FAE = 'O') and E.TYPE_STATION = LF.COMP_ETATS and E.COMP_STATUS = ST.COMP_STATUS(+) and exists (select 1 from v_mygroup_users where E.owner=user_name and rownum=1); - Abiy Alemu Phone: (+33) 1-58 17 04 56 Fax: (+33) 1-58 17 04 54 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth 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: ALEMU Abiy 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).
Query from access to oracle
Hallo, Anyone who can help me, I have this query in Ms Access: How should I write this sql statement in oracle. SELECT RIK2.LEV.LEVNR, RIK2.VARE.EAN_NR, RIK2.VARE.VARENAVN, RIK2.AVD.KJEDE, Sum(BRT.BRTOMS_DAG.ANT) AS ANT, Sum(BRT.BRTOMS_DAG.UTVERDI) AS UTVERDI, BRT.BRTOMS_DAG.DATO, Left([RIK2.VARE].[HYLLETXT2],12) AS VARUMARKE, RIK2_VARE.STR FROM ((RIK2.LEV INNER JOIN RIK2.VARE ON RIK2.LEV.LEVNR = RIK2.VARE.LEVNR) INNER JOIN BRT.BRTOMS_DAG ON (RIK2.VARE.VARE_SNR = BRT.BRTOMS_DAG.VARE_SNR) AND (RIK2.VARE.VARENR = BRT.BRTOMS_DAG.VARENR) AND (RIK2_VARE.SORTIMENT = BRT_BRTOMS_DAG.SORTIMENT)) INNER JOIN RIK2_AVD ON BRT.BRTOMS_DAG.AVDNR = RIK2.AVD.AVDNR WHERE (((RIK2.LEV.SELSKAP)=11) AND ((RIK2.VARE.SELSKAP)=11) AND ((RIK2.AVD.SELSKAP)=11)) GROUP BY RIK2.LEV.LEVNR, RIK2.VARE.EAN_NR, RIK2.VARE.VARENAVN, RIK2.AVD.KJEDE, BRT.BRTOMS_DAG.DATO, RIK2.VARE.STR, RIK2.VARE.HYLLETXT2 HAVING (((RIK2.AVD.KJEDE) In (30,31,32,33,34))) ORDER BY RIK2.VARE.EAN_NR; I guess problem with left join, inner join and outer join Thanks in advance. Roland -- 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: User Query Tools
It's your worst nightmare come true!!! The users want to do it 'cause a) IS charge to much for the work b) All it is is a bunch of stuff in a big file thing, how difficult could it be? c) Isn't it just like a big spreadsheet only different? d) I built one at home so I know what to look for (the worst one, instant expert!) Good luckgrinas for tools, try Oracle Discoverer. Regards, 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 http://www.calanais.com/ -Original Message- Sent: 10 September 2001 23:52 To: Multiple recipients of list ORACLE-L Hey all, I just got out from a meeting where I was told that some of our users are asking for a tool to do their own queries against our database so they wouldn't have to request reports and such from IS. Oh BTW, they don't know (or feel the need to learn) SQL so they will be needing something with either a good GUI QBF or some kind of natural language interface. We are leaning against MS Query to avoid ODBC performance problems. Does anyone out there have users like this? Any product referrals with pros/cons? TIA If you have any questions, please feel free to call me or drop me a note. Stephen Andert 480-445-2506 -- 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: export user definitions
something like this i have found on teamdba.com
select 'create user '||username||' identified by values '
||chr(39)||password||chr(39)||
' default tablespace '||default_tablespace ||
' temporary tablespace '|| temporary_tablespace||' ;'
from dba_users
where username not in ('SYS','SYSTEM','DBSNMP','OUTLN');
-Oorspronkelijk bericht-
Van: Jared Still [SMTP:[EMAIL PROTECTED]]
Verzonden:maandag 10 september 2001 15:47
Aan: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Onderwerp:Re: export user definitions
On Monday 10 September 2001 02:45, [EMAIL PROTECTED] wrote:
hi everyone
can anybody help me with a script that recreates
user definitions and the granted roles ?
thanks
g.g. kor
rdw ict groningen
Someone asked this just a couple of weeks ago. That
script will recreate a user.
Take a look through the archives at www.fatcity.com for this.
Recreating the roles is a simple exercise I'll leave to you.
Jared
--
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: What's wrong with this query
Anne, Upon first glance I wondered if it's because you are not specifing the Index to use for b. Possibly, you don't have a clause in your where statement that filters the number of records you're trying to get back from ucc_master_amendment m. In the statement: d.document_number = m.document_number but what does m.document_number equal? Can you see what I'm getting at here? Sorry 8:45am, still a little sleepy ;-) Regards, 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: 10 September 2001 20:15 To: Multiple recipients of list ORACLE-L Hey list, Can anyone tell me what's wrong with this query? many thanks, select /*+ INDEX(b)*/ distinct d.batch_number , d.document_number , d.entry_user_id , d.document_type_id , d.document_processed_date , b.batch_media_id, d.return_Method_Id from submitter_batch b , document d , ucc_master_amendment m where d.batch_number = b.batch_number and d.document_number = m.document_number and d.imaged = 0 and b.batch_media_id = 4 and d.document_status_id = 4 Submitter_batch - 97853 rows Document- 8043272 rows (fk_d_batchnumber index on batch_number) Ucc_master_adment -0 rows (pk_uma_dn index on document_number) Here is the explain plan: explain planexpected rows object name select statement 164662478 sort (unique) 164662478 nested loops 164662478 nested loops 2008079 table access(full) 46193 submitted batch table access(by idx) 2008079 document index(range scan) 2008079 fk_d_batchnumber non-unique index(unique scan) 82 pk_uma_dn unique -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu 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).
DBMS_JOB statement
Hallo, Can anyone tell me a example on a script which does the following: - Starts a job, a pl/sql-procedur, at 6 pm every day, - If something goes wrong then I want information to be logged. (Should I include the logging in the pl/sql procedur) 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).
Migration from Informix to oracle
Hi All, Can anybody suggest me the steps to migrate to oracle database from Informix ? Can it be done simply by using sqlloader oracle utility ? Kindly reply. Regards, Deepender -- Information transmitted by this E-MAIL is proprietary to Wipro and/or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at mailto:[EMAIL PROTECTED] and delete this mail from your records. --
RE: query for top customer
Thanks Greg, ;-) I needed that! I just got into PL/SQL mode and went for itLOL 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: 11 September 2001 05:30 To: Multiple recipients of list ORACLE-L Here's me publishing war-n-peace to solve a problem that takes 4 lines of code... True, but your PL/SQL solution is fast. Using a correlated subquery to find the top three rows works fine against EMP, but what happens when it goes against a table with 100,000 rows? This subquery runs 100,000 times: where 3 (select count(*) from tablea y where y.sales x.sales) The correlated subquery solution will run forever and a day, and an index won't help. If you can't do an in-line view, forget the correlated subquery, no matter how short it is, and use PL/SQL. Am I missing something here? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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).
too high load on Linux
Hello! I'm new in this list and I sorry for easy and stupid questions and my English. :) I have a 8.1.7 database on Debian 2.2 and the oracle session use nearly 100 percent of CPU. I listed v$session view and noticed one session do that! But how can I get more information for this session ? How can I see what this session do ? Any trace log ? Please help me! Best regards: András, Czoch -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrew Cook 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).
NLS_ Client settings
Hi All, Someone came up to me today with a list of 17 NLS parameters and wanted to know what the settings were on our clients. I have been able to find some of the parameters in the v$nls_parameters view and asssume that these are client/session related since they change with alter session commands. Anyway I searched the documentation to find the missing ones (like nls_debit, nls_credit etc..) and only found that the default is derived from something else, and some OCI function could retrieve them. I do not have experience with OCI programming so.. Has anybody had the request to list all nls_parameters and created the script to get them, or is there another/easier way to get them?? TIA 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).
ORA-12705 - REALLY URGENT
Hello all, I am getting an error, ORA-12705, could you please advise what steps I can take to set the NLS_LANG properly, this is what it says is needed. Also please tell me what are the possible solutions to this problem? This is really urgent, please help. rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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: Solaris Hang
Hi, take a look at the SUN System Administrator Guide. Here's an excerpt: Every other leap year, your CDE hangs on the 2nd full moon night of September after you try to write more then 4 files to a floppy disk. To fix this problem, you have to go to store.sun.com and buy even more memory. cheers | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FBOM | | Tel.: 0211/533-4893| Sinardy schrieb: Hi all, My Machine Ultra 10 256 MB, Solaris 7 running : 0. Stand Alone workstation 1. Oracle 8.1.6 single dbwriter logwriter, noarchive 2. Hot Java 3. 3 Text Editors 4. 2 Terminals 5. 2 File Managers When I tried to copy 5 files into floppy my CDE frozen ? and my floppy busy light is still on What happen ?? Is this because of Unix or CDE ? Thanks -- 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: ORA-12705 - REALLY URGENT
Hi, What is exactly that you are trying to do. Alter session? What syntax? Start the database? What O/S? What is your environment like (on UNIX env |grep nls) Jack Viraj Luthra [EMAIL PROTECTED]@fatcity.com on 11-09-2001 12:05:26 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hello all, I am getting an error, ORA-12705, could you please advise what steps I can take to set the NLS_LANG properly, this is what it says is needed. Also please tell me what are the possible solutions to this problem? This is really urgent, please help. rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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: too high load on Linux
Hi Andras,
Firstly, welcome to the list, and your English is fine!!
For a good session detail run the following query:
--Sessions.sql---
select s.sid sid,
s.serial# serial#,
s.lockwait lockwait,
0 blkby,
0 blkcnt,
s.username session_user,
s.program program,
s.osuser osuser,
s.status status,
s.server server,
s.command cmd_code,
s.terminal terminal,
s.type session_type,
a.name command,
p.pid pid,
p.spid spid,
p.username process_user,
i.block_gets + i.consistent_gets logrds,
i.physical_reads phyrds,
i.block_changes + i.consistent_changes writes
from v$session s,
v$process p,
v$sess_io i,
audit_actions a
where s.paddr = p.addr
and s.sid = i.sid
and s.command = a.action
order by s.sid,
s.serial#
-
To find out the currently executing SQL for this session, insert the SID
shown in the previous query for the offending user in to the following
statement, this will show you all of the SQL that the user currently has in
the SQLArea, as well as showing you their currently executing cursor which
is shown with an asterix(*) in the EXECCUR column:
-SessionSQL.sql--
select s.sid sid,
c.sql_text sql_text,
c.address address,
c.hash_value,
substrb(' ',1,2) execcur
from v$open_cursor c,
v$session s
where c.saddr = s.saddr
and c.hash_value != s.sql_hash_value
and s.sid in (SID)
union
select s.sid sid,
c.sql_text sql_text,
c.address address,
c.hash_value hash_value,
substrb('* ',1,2) execcur
from v$open_cursor c,
v$session s
where c.saddr = s.saddr
and c.hash_value = s.sql_hash_value
and s.sid in (SID)
-
You can trace the user, by using the DBMS_SYSTEM package. Again, take a note
of the offending users SID, and SERIAL#, and use the following syntax:
exec sys.dbms_system.set_sql_trace_in_session(sid,serial#,TRUE|FALSE);
So assuming the SID is 9, and the serial is 224:
exec sys.dbms_system.set_sql_trace_in_session(9,224,TRUE);
And to stop the trace:
exec sys.dbms_system.set_sql_trace_in_session(9,224,FALSE);
Any trace files generated will be in your user_dump_destination (wherever
that is specified in your initSID.ora file).
I hope this helps,
Regards
Mark
-Original Message-
Sent: Tuesday, September 11, 2001 10:45
To: Multiple recipients of list ORACLE-L
Hello!
I'm new in this list and I sorry for easy and stupid questions and my
English. :)
I have a 8.1.7 database on Debian 2.2 and the oracle session use nearly 100
percent of CPU. I listed v$session view and noticed one session do that!
But how can I get more information for this session ? How can I see what
this session do ? Any trace log ?
Please help me!
Best regards:
András, Czoch
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrew Cook
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).
RE: DBMS_JOB statement
Hi Roland, declare l_job number; begin dbms_job.submit( l_job, 'procedure;', trunc(sysdate)+18/24, 'trunc(sysdate)+18/24' ); end; This runs at exactly 6pm every day (18 hours into the day, replace procedure with the name of the stored procedure that you want to run. 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: 11 September 2001 10:00 To: Multiple recipients of list ORACLE-L Hallo, Can anyone tell me a example on a script which does the following: - Starts a job, a pl/sql-procedur, at 6 pm every day, - If something goes wrong then I want information to be logged. (Should I include the logging in the pl/sql procedur) 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: 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: ORA-12705 - REALLY URGENT
Problem is resolved. The NLS_LANG was not set correctly in the environment. Thanks for all help. rgds, raja -- On Tue, 11 Sep 2001 02:30:38 nlzanen1 wrote: Hi, What is exactly that you are trying to do. Alter session? What syntax? Start the database? What O/S? What is your environment like (on UNIX env |grep nls) Jack Viraj Luthra [EMAIL PROTECTED]@fatcity.com on 11-09-2001 12:05:26 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hello all, I am getting an error, ORA-12705, could you please advise what steps I can take to set the NLS_LANG properly, this is what it says is needed. Also please tell me what are the possible solutions to this problem? This is really urgent, please help. rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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:
Replication ??
Hi Gurus We are considering implementing replication, on our server. Microsoft 2000 Oracle 816. Does anyone know of any problems, or I wish I had known that before. type of issues of doing this? Many Thanks Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: query problem
Or set define off.. -Original Message- Sent: Monday, September 10, 2001 21:56 To: Multiple recipients of list ORACLE-L or .. If you are doing it in SQLPLUS you can do set scan off That way it will not look for variables. -Original Message- Sent: Monday, September 10, 2001 3:31 PM To: Multiple recipients of list ORACLE-L Hi, I need to run the follwing query: select * from t_enum_data where id_enum_data ='metrr/usa canada'; and it is always prompt for value of canada as there is sign.. how to supress for prompt and use as constant Thanks -harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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: 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). -- 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).
Copying backups across a narrow pipe.
Hi Gurus I have a problem in that I have to copy my backups across a wan connection to a remote server. However the copy ( using xcopy) in the microsoft NT environment, keeps on dropping or times out. So the success rate is very low, the Boss is now becoming difficult about it. Does anyone know of any tools/Software which I could use to copy the file across, check the integrity and recopy if it had failed? Any suggestions will be appreciated Many Thanks Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva 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).
Ftp from Oracle
Hallo, Is it possible to do ftp commands directly from PL/SQL procedur? Including logon to the ftp server.? Give me an example please if possible. Thanks in advance Roland -- 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).
Differential Backup
Hi all, we have oracle server version 8.1.7 on windows NT. We take daily full backup of our data. Now we want to take differential backup with respect to last backup taken. So if any help possible it will be great to me. Thanks. -Ketan _ 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: Ketan Patel 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 RE: Interesting News..
Ok guys, now tell us how you really feel. :o) I just about choked from laughing. Dave -Original Message- Sent: Monday, September 10, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Eric, I join with you in emptying the contents of my venom sac deep into the putrid flesh of shitty vendors like Oracle, Microsoft, and yes..COMCRAP. Getting tired of reading Service is Our Number One Priority when it is clearly fifth or sixth, directly under. F*cking You Hard When We Can or Doing Kind of The Best We Feel Like, Depending on the Weather or You'll Get NOTHING, and LIKE IT, or You're Our Plaything Now That You've Drunk from the Proprietary Kool-Aid Good Customer Service is really really really rare, especially when you factor in consistent delivery of same. Multibillion dollar corporations that get away with murder on a daily basis are...well...a dime a dozen. Now I must rest...as my venom sacs once again fill with their sweet liquid of death - Ross -Original Message- Sent: Monday, September 10, 2001 5:17 PM To: Multiple recipients of list ORACLE-L K- I apparently made the mistake of thinking that the US constitution says that there is a right to FREE SPEECH in this friggin country. I'm reporting what a reseller is saying about his several years of experience, and what bugs the daylights out of the people that ACTUALLY PAY MONEY FOR A PRODUCT (known as customers for those that have never heard the word before). Note that the resalescritter was specifically addressing the headaches reported by CUSTOMERS at sites using service offerings in the SUB-enterprise category. Anyone feel free to call me an idiot (HELP), that I'm wrong, or whatever, but absent the technical merits of a pro-Compaq position having been presented in detail, all I hear is someone acting like a pissy little fascist. My writing wasn't exacty at the level of the Great Bard, but it would help if people would read a bit more carefully before they barf. Speaking of which, I'm sick of all the crap (lying/etc.) from vendors and their employees and the friends of their employees, and having them expecting the customers to kiss their a$$es all the time because they are some big megacorp. Of course the good news is that I can now go around telling people that if they want good services, they should buy IBM since there are so many a$$holes in the Compaq world. brgrds, ep [ via ORACLE-L Digest -- Volume 2001, Number 251] -- From: Kimberly Smith [EMAIL PROTECTED] Date: Fri, 7 Sep 2001 08:16:35 -0700 Subject: RE: Interesting News.. Jon, you need to get some thick skin. My company is destroyed quite often in this list (although it has been a while). -Original Message- Sent: Friday, September 07, 2001 4:50 AM To: Multiple recipients of list ORACLE-L Eric: While I can appreciate that your opinion of the Compaq Services division might be less than positive, would you please, for the sake of those who actually work for these companies, be a little less dramatic in your expression of that opinion. Jon Walthour Oracle Database Administrator COMPAQ DBA Team Cincinnati, Ohio -Original Message- Sent: Thursday, September 06, 2001 4:22 PM To: Multiple recipients of list ORACLE-L According to our hardware resalescritter: especially for anything below large enterprise level, both HP and Compaq services suck. so, I guess the objective is to create a new company who services suck even more than either individually? Synergy!!! Guy Hammond wrote: On the contrary, I'd say this is a godsend for Sun. Compaq made a mess of truly epic proportions when they tried to integrate DEC and Tandem into their operations. HP did just as badly with Apollo. ... -- 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). -- 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
RE: Re[2]: RE: Interesting News..
Why is it that flames rarely have the letters OT in the subject line... Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-12705 - REALLY URGENT
You should look at the values of NLS_LANG and ORA_NLS33 or ORA_NLS32 in the client. If it is an NT's client, the values must be defined once and not in each HOME. Regards. --- Viraj Luthra [EMAIL PROTECTED] wrote: Hello all, I am getting an error, ORA-12705, could you please advise what steps I can take to set the NLS_LANG properly, this is what it says is needed. Also please tell me what are the possible solutions to this problem? This is really urgent, please help. rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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).
Downloading from Oracle
Sometimes when I download files from the Oracle web sites, I can't use Download Accelerator Plus. I like that utility, it downloads files in parallel. When I try to download using IE, 90% of the time the large .zip file is corrupt and unusable. Has anyone found a way to download the Applications service pack from Oracle successfully? TIA Patrice Boivin Systems Analyst (Oracle Certified DBA) Acting Head Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- 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: nvl not using index
Big
Planet wrote
-I
am writing this proc does a searchin databasebased on these in
parameters and returns a ref cursor . Now one moreofthesein
parameters can be null and my query should return data neglecting null
parameters . So I use nvl in the query as shown below
Big Planet, small
print,,, coincidence??
-Original Message-From: Big Planet
[mailto:[EMAIL PROTECTED]]Sent: Monday, September 10, 2001
5:20 PMTo: Multiple recipients of list ORACLE-LSubject:
nvl not using index
Hi All ,
I am writing this proc does a searchin
databasebased on these in parameters and returns a ref cursor .
Now one more of these in parameters can be null and my query should return
data neglecting null parameters . So I use nvl in the query as shown below
.
Now my problem is , the query doesnt use index
available on table since i m using a function .
Is there any way I can rewrite this query so
that it meets my requirements and use the index . I have other option is to
create a dynamic sql based on in parameters .
TIA for any help .
-BigP
PROCEDURE get_alertlog (
p_loginidvarchar2 ,
p_startdate date,
p_firstname varchar2 ,
p_enddate date ,
p_status out number,
p_msg out varchar2,
p_refcursor out c_refcursor )
Begin
open p_refcursor for
select logpin , logtype , logaction , logdate , memberpin
FROM mem
WHEREloginid
=nvl(p_loginid , loginid )
AND logdate
between nvl(p_startdate,to_date('1-jan-1900','dd-mon-') )
And firstname = nvl( p_firstname , firstname
)
and nvl(p_enddate , sysdate ) ;
End
;
RE: Downloading from Oracle
I am too in the same shoes. Any help from others?? Rajesh -Original Message- Patrice J Sent: Tuesday, September 11, 2001 4:35 PM To: Multiple recipients of list ORACLE-L Sometimes when I download files from the Oracle web sites, I can't use Download Accelerator Plus. I like that utility, it downloads files in parallel. When I try to download using IE, 90% of the time the large .zip file is corrupt and unusable. Has anyone found a way to download the Applications service pack from Oracle successfully? TIA Patrice Boivin Systems Analyst (Oracle Certified DBA) Acting Head Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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).
Inserting records into a table without creating indexes
List, Environment: Solaris 7 : Oracle 817 : OLTP system with stringent throughput requirements A transaction inserts a record into 4 tables. After successful insert into all the four tables, the transaction issues a commit. Many alternate index keys (AK's) are defined on each table. Expected number of transactions : 300 - 400 transactions per second. Requirement: While insert is taking place on the tables, I do not want to create indexes. Immediately After the transaction is committed, I want to create indexes for the inserted record. I do not want disable the indexes during the transaction processing. Is the above requirement feasible? Or am I on a wrong path? Please advise. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara 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: Copying backups across a narrow pipe.
Hi, take a look at connect direct. It's a data transfer tool that is scriptable and can handle high volumes at a high transfer rate. Denham Eva schrieb: Hi Gurus I have a problem in that I have to copy my backups across a wan connection to a remote server. However the copy ( using xcopy) in the microsoft NT environment, keeps on dropping or times out. So the success rate is very low, the Boss is now becoming difficult about it. Does anyone know of any tools/Software which I could use to copy the file across, check the integrity and recopy if it had failed? Any suggestions will be appreciated Many Thanks Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva 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! - -- | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FBOM | | Tel.: 0211/533-4893| -- 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: Differential Backup
Try with RMAN. Regards. --- Ketan Patel [EMAIL PROTECTED] wrote: Hi all, we have oracle server version 8.1.7 on windows NT. We take daily full backup of our data. Now we want to take differential backup with respect to last backup taken. So if any help possible it will be great to me. Thanks. -Ketan _ 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: Ketan Patel 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Differential Backup
Take a look at the fine documentation on RMAN. It can do different levels of incremental backup. -Joe - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 8:30 AM Hi all, we have oracle server version 8.1.7 on windows NT. We take daily full backup of our data. Now we want to take differential backup with respect to last backup taken. So if any help possible it will be great to me. Thanks. -Ketan _ 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: Ketan Patel 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: Joe Raube 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: Replication ??
Hi, it depends on what kind of replication you want. We're using normal snapshots (read only and updatable) and multi master replication. There is an organisational issue concerning multi master replication. You have to be sure about how you want to replicate. We went with asynchronous replication, because that way, it doesn't have an impact on instance A if instance B is down or can't be reached for some other reason. If you have synchronous replication and you're doing an update on instance A while instance B is gone, your application that tries the update might hang, since instance A tries to fire the trigger to do the update in instance B immediately within the same transaction. Also, there are several different ways of conflict resolution. You might want to take a look at this. Once you have everything running, write some scripts to deal with the errors before they pile up. Denham Eva schrieb: Hi Gurus We are considering implementing replication, on our server. Microsoft 2000 Oracle 816. Does anyone know of any problems, or I wish I had known that before. type of issues of doing this? Many Thanks Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva 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! - -- | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FBOM | | Tel.: 0211/533-4893| -- 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: Downloading from Oracle
At 09:15 AM 9/11/2001, you wrote: I am too in the same shoes. Any help from others?? Rajesh i use getright. seems to work ok for me. -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Stack Error: Lost on a cluttered desk... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: [Fwd: Re: patch question]
Anjan, Thanks, what I thought is I installed the 8170, apply patch 8172, then upgrade db from 816 to 817.2 directly. (not apply a 817 patch to 816 db) Anyway, I think I will upgrade first to 817.0 and apply patch to 817.2. Thanks, Joan Anjan Thakuria wrote: Upgrade and then apply patch. (You could not apply a 817 patch to a 816 db could u ??) Anjan Joan Hsieh wrote: Thanks, Joe, I read the notes. It seems can go either way. I reinstalled the 817 base again. My next question puzzled me, should I upgrade database first 816- 817, then apply the patch, or apply patch goes first? Maybe it goes either way. But I'd like to hear some advice first. Joan Original Message Subject: Re: patch question Date: Thu, 06 Sep 2001 09:47:01 -0800 From: JOE TESTA [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Joan, check out the release notes for aix patches, if i remember correctly: 8.1.7.0 - 8.1.7.18.1.7.0 - 8.1.7.2 8.1.7.1 - 8.1.7.0 - 8.1.7.2 to go from 8171 to 8172, i think you have to reinstall 8.1.7.0, run all scripts, then apply patch and run scripts again. joe [EMAIL PROTECTED] 09/06/01 01:32PM Hi Listers, I am asking a simple question today. We have 8.1.6 production database and want to upgrade to 8.1.7.2 on AIX R/6000. 1. I installed 8.1.7 on production already. Can I install 8.1.7.2 patch direct on top of 8.1.7 or have to go 8.1.7.1 first? 2. Installed patch first, then upgrade database later or upgrade database from 8.1.6 to 8.1.7 then installed patch later? Thanks, Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh 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: Joan Hsieh 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: Anjan Thakuria 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: Joan Hsieh 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: Ftp from Oracle
Not that I know of through PL/SQL, but you can use Java Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 11, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Hallo, Is it possible to do ftp commands directly from PL/SQL procedur? Including logon to the ftp server.? Give me an example please if possible. Thanks in advance Roland -- 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: Christopher Spence 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: Do fast full index scans do physical disk reads?
If you read the email as I wrote it, it was a sarcastic response to someone elses posts. And a few emails later I reiterated that it was only meant sarcastically. But take it as you may. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, September 10, 2001 8:03 PM To: 'Christopher Spence'; 'Multiple recipients of list ORACLE-L ' Anyone who informs the group of his high IQ is not suffering from humility. In doing so, one invites the occaisonal barb. However continuing to do so would be childish. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 10, 2001 3:36 PM To: MacGregor, Ian A.; 'Multiple recipients of list ORACLE-L ' I resent the self-touting, the email you are probably refering to was a sarcastic one of someone (I believe Mark's) email. I am actually fairly humble for the most part. Although I tend to be quite sarcastic at times and on email it is sometimes hard to see my humor in most everything I say. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/10/01 6:40 PM Yes it's fun getting Chris, our self-touting genuis. However, the point is not that unique indexes cannot be compressed, but that the prefix length canot be mre that one less than the numbewr of coluymns in the index. Ian A MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 10, 2001 2:55 PM To: Multiple recipients of list ORACLE-L Whoa Chris, gotcha on that one. :) The combination of columns may be unique, but you can certainly compress a unique index for significant space savings. The unique index I used in testing had three columns, ordered most selective first. By reversing the column order of the index and compressing it, the index went from 180 Megs to 60 megs. The cardinality of the new leading column was 26 in table of 1.5 million rows. Jared Christopher Spence To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cspence@FuelS cc: pot.com Subject: RE: Do fast full index scans do physical disk reads? Sent by: [EMAIL PROTECTED] om 09/10/01 01:20 PM Please respond to ORACLE-L Yes, there is no point in compressing all columns of a unique index as it would result in 0% compression as they are unique. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, September 10, 2001 3:55 PM To: Multiple recipients of list ORACLE-L The restriction is on unique indexes. 1* select column_name from dba_ind_COLUMNS where INDEX_NAME = 'WOLO_PK' SQL / COLUMN_NAME PERSON_ID INSTITUTION_CODE ALTER INDEX CASEPUPPY.WOLO_PK REBUILD COMPRESS 2 TABLESPACE PEPII_INDEX / REBUILD COMPRESS 2 TABLESPACE PEPII_INDEX * ERROR at line 2: ORA-25194: invalid COMPRESS prefix length value ALTER INDEX CASEPUPPY.WOLO_PK REBUILD COMPRESS 1 TABLESPACE PEPII_INDEX / Index altered. This was done on an 8.1.6.3 database. As far as what's done in practice, I would hazard accepting the Oracle defaults for prefix length values is the most common. The documentation states: For unique indexes, the valid range of prefix length values is from 1 to the number of key columns minus 1. The default prefix length is the number of key columns minus 1. For nonunique indexes, the valid range of prefix length values is from 1 to the number of key columns. The default prefix length is the number of key columns. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 10, 2001 11:26 AM To: Multiple recipients of list ORACLE-L Actually you can create compressed indexes upto the size of the columns. In other words, the last column in a concentated index can be compressed. Although most practice does not. Do not criticize someone until you walked a mile in their shoes,
RE: Copying backups across a narrow pipe.
And where can I get that look? Alex Hillman -Original Message- Sent: Tuesday, September 11, 2001 9:10 AM To: Multiple recipients of list ORACLE-L Hi, take a look at connect direct. It's a data transfer tool that is scriptable and can handle high volumes at a high transfer rate. Denham Eva schrieb: Hi Gurus I have a problem in that I have to copy my backups across a wan connection to a remote server. However the copy ( using xcopy) in the microsoft NT environment, keeps on dropping or times out. So the success rate is very low, the Boss is now becoming difficult about it. Does anyone know of any tools/Software which I could use to copy the file across, check the integrity and recopy if it had failed? Any suggestions will be appreciated Many Thanks Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva 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! - -- | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FBOM | | Tel.: 0211/533-4893| -- 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: Hillman, Alex 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 RE: Interesting News..
Now for my encore, I'll crash into the World Trade Center. EG -Original Message- Sent: Tuesday, September 11, 2001 8:00 AM To: Multiple recipients of list ORACLE-L Ok guys, now tell us how you really feel. :o) I just about choked from laughing. Dave -Original Message- Sent: Monday, September 10, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Eric, I join with you in emptying the contents of my venom sac deep into the putrid flesh of shitty vendors like Oracle, Microsoft, and yes..COMCRAP. Getting tired of reading Service is Our Number One Priority when it is clearly fifth or sixth, directly under. F*cking You Hard When We Can or Doing Kind of The Best We Feel Like, Depending on the Weather or You'll Get NOTHING, and LIKE IT, or You're Our Plaything Now That You've Drunk from the Proprietary Kool-Aid Good Customer Service is really really really rare, especially when you factor in consistent delivery of same. Multibillion dollar corporations that get away with murder on a daily basis are...well...a dime a dozen. Now I must rest...as my venom sacs once again fill with their sweet liquid of death - Ross -Original Message- Sent: Monday, September 10, 2001 5:17 PM To: Multiple recipients of list ORACLE-L K- I apparently made the mistake of thinking that the US constitution says that there is a right to FREE SPEECH in this friggin country. I'm reporting what a reseller is saying about his several years of experience, and what bugs the daylights out of the people that ACTUALLY PAY MONEY FOR A PRODUCT (known as customers for those that have never heard the word before). Note that the resalescritter was specifically addressing the headaches reported by CUSTOMERS at sites using service offerings in the SUB-enterprise category. Anyone feel free to call me an idiot (HELP), that I'm wrong, or whatever, but absent the technical merits of a pro-Compaq position having been presented in detail, all I hear is someone acting like a pissy little fascist. My writing wasn't exacty at the level of the Great Bard, but it would help if people would read a bit more carefully before they barf. Speaking of which, I'm sick of all the crap (lying/etc.) from vendors and their employees and the friends of their employees, and having them expecting the customers to kiss their a$$es all the time because they are some big megacorp. Of course the good news is that I can now go around telling people that if they want good services, they should buy IBM since there are so many a$$holes in the Compaq world. brgrds, ep [ via ORACLE-L Digest -- Volume 2001, Number 251] -- From: Kimberly Smith [EMAIL PROTECTED] Date: Fri, 7 Sep 2001 08:16:35 -0700 Subject: RE: Interesting News.. Jon, you need to get some thick skin. My company is destroyed quite often in this list (although it has been a while). -Original Message- Sent: Friday, September 07, 2001 4:50 AM To: Multiple recipients of list ORACLE-L Eric: While I can appreciate that your opinion of the Compaq Services division might be less than positive, would you please, for the sake of those who actually work for these companies, be a little less dramatic in your expression of that opinion. Jon Walthour Oracle Database Administrator COMPAQ DBA Team Cincinnati, Ohio -Original Message- Sent: Thursday, September 06, 2001 4:22 PM To: Multiple recipients of list ORACLE-L According to our hardware resalescritter: especially for anything below large enterprise level, both HP and Compaq services suck. so, I guess the objective is to create a new company who services suck even more than either individually? Synergy!!! Guy Hammond wrote: On the contrary, I'd say this is a godsend for Sun. Compaq made a mess of truly epic proportions when they tried to integrate DEC and Tandem into their operations. HP did just as badly with Apollo. ... -- 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). -- 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
RE: Downloading from Oracle
What is the problem with using DAP to do the download? Failing getting this working - as it almost guarantees a valid download - have you also tried some of the other download aids (getright, or real download for example)? I do agree, DAP is the best I have come across so far.. What is the error you are getting? not a valid archive file? Is the downloaded file size the same as the reported file size on the web page? I have never seemed to have a problem with DAP on the Oracle sites.. Mark -Original Message- Dayal Sent: Tuesday, September 11, 2001 14:15 To: Multiple recipients of list ORACLE-L I am too in the same shoes. Any help from others?? Rajesh -Original Message- Patrice J Sent: Tuesday, September 11, 2001 4:35 PM To: Multiple recipients of list ORACLE-L Sometimes when I download files from the Oracle web sites, I can't use Download Accelerator Plus. I like that utility, it downloads files in parallel. When I try to download using IE, 90% of the time the large .zip file is corrupt and unusable. Has anyone found a way to download the Applications service pack from Oracle successfully? TIA Patrice Boivin Systems Analyst (Oracle Certified DBA) Acting Head Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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).
RE: STOP THE PRESS!!
The BBC seems to have more info than the U.S. web sites. Tuesday, 11 September, 2001, 13:35 GMT 14:35 UK Planes 'attack' World Trade Center A huge explosion rocks one of towers Two planes have crashed into the World Trade Center in New York City while an explosion has rocked the Pentagon in Washington DC. The White House is reportedly being evacuated. One report says six people have been killed in the New York incident while hundreds have been injured. Smoke is pouring from the upper storeys of both towers of the World Trade Center. The building, one of the world's tallest, has been badly damaged in what President George W Bush has described as an apparent terrorist attack. He said: We will find those who committed this attack. New York police have been quoted as saying that both planes were hijacked from Boston. A few minutes after the first tower was hit by a passenger plane, a second, similar plane was seen flying into the second tower. A huge explosion was seen. Eyewitnesses say the first plane crashed into the West Tower after flying unusually low over Manhattan Island. A BBC correspondent says 10 to 15 floors have been affected by the crash. Briton James Winter, 30, living in an apartment close to the centre, said he was woken a huge bang at around 0800 local time. I was in bed and there was a huge explosion. The whole building rattled and shook, he said. I ran to the window and there was smoke billowing from the south side of one of the towers. Everyone in my building was panicking and running around. The World Trade Center consists of two 110-story skyscrapers, New York's tallest buildings. One of the towers is just six feet (two metres) taller than the other. About 40,000 people work inside the two-building centre, and more than 150,000 people enter the complex every day. On 26 February, 1993, a terrorist bomb exploded in building number one's lower level. -- 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).
FW: nvl not using index
Title: FW: nvl not using index
BigPee,
Have you tried a function-based index yet? (8i) You'll need to grant query rewrite privilege to the user creating the index.
Lisa Koivu
Glorified Typist and DBA
Ft. Lauderdale, FL, USA
-Original Message-
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, September 11, 2001 8:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: nvl not using index
Big Planet wrote
-I am writing this proc does a search in database based on these in parameters and returns a ref cursor . Now one more of these in parameters can be null and my query should return data neglecting null parameters . So I use nvl in the query as shown below
Big Planet, small print,,, coincidence??
-Original Message-
From: Big Planet [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 5:20 PM
To: Multiple recipients of list ORACLE-L
Subject: nvl not using index
Hi All ,
I am writing this proc does a search in database based on these in parameters and returns a ref cursor . Now one more of these in parameters can be null and my query should return data neglecting null parameters . So I use nvl in the query as shown below .
Now my problem is , the query doesnt use index available on table since i m using a function .
Is there any way I can rewrite this query so that it meets my requirements and use the index . I have other option is to create a dynamic sql based on in parameters .
TIA for any help .
-BigP
PROCEDURE get_alertlog ( p_loginid varchar2 ,
p_startdate date,
p_firstname varchar2 ,
p_enddate date ,
p_status out number,
p_msg out varchar2,
p_refcursor out c_refcursor )
Begin
open p_refcursor for
select logpin , logtype , logaction , logdate , memberpin
FROM mem
WHERE loginid =nvl(p_loginid , loginid )
AND logdate between nvl(p_startdate,to_date('1-jan-1900','dd-mon-') )
And firstname = nvl( p_firstname , firstname )
and nvl(p_enddate , sysdate ) ;
End ;
OT: STOP THE PRESS!!
List, I am sure many of you Americans will have woken to this news, or maybe you got to work before it happened: I just saw on the news the World Trade Centre in NY, has just taken two direct hits from two separate aeroplanes!! Suspected to be a terrorist assault. Full video the lot!! They hit around the top of the buildings.. My heart goes out to those in the buildings.. What will THIS do for the American economy? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- 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).
RE: What's wrong with this query
Thanks Thomas, Lisa, Attached is the TKPROF EXPLAIN PLAN for this query.Please review. Many thanks, TKPROF: Release 8.0.6.3.0 - Production on Tue Sep 11 07:38:26 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Trace file: texasprd_ora_24718.trc Sort options: default count= number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query= number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call alter session set sql_trace = true call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Misses in library cache during execute: 1 Optimizer goal: CHOOSE Parsing user id: 111 BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END; call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 4 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total8 0.00 0.00 0 0 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 111 select /*+ INDEX(b)*/ distinct d.batch_number , d.document_number , d.entry_user_id , d.document_type_id , d.document_processed_date , b.batch_media_id, d.return_Method_Id from submitter_batch b , document d , ucc_master_amendment m where d.batch_number = b.batch_number and d.document_number = m.document_number and d.imaged = 0 and b.batch_media_id = 4 and d.document_status_id = 4 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch1 0.00 0.00 32 3193 0 0 --- -- -- -- -- -- -- total3 0.00 0.00 32 3193 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 111 Rows Row Source Operation --- --- 0 SORT UNIQUE 0 NESTED LOOPS 1NESTED LOOPS 147 TABLE ACCESS BY INDEX ROWID SUBMITTER_BATCH 148 INDEX RANGE SCAN (object id 10416) 2722 TABLE ACCESS BY INDEX ROWID DOCUMENT 2869 INDEX RANGE SCAN (object id 10385) 1INDEX UNIQUE SCAN (object id 8484) explain plan set statement_id='ANN_UCC_3' for select /*+ INDEX(b)*/ distinct d.batch_number , d.document_number , d.entry_user_id , d.document_type_id , d.document_processed_date , b.batch_media_id, d.return_Method_Id from submitter_batch b , document d , ucc_master_amendment m where d.batch_number = b.batch_number and d.document_number = m.document_number and d.imaged = 0 and b.batch_media_id = 4 and d.document_status_id = 4 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 111 Rows Row Source Operation ---
RE: Ftp from Oracle
Hi Roland, Yes it is possible, I have got a piece of code that I got from the site asktom.oracle.com, that allows you to send Unix commands to the shell from within SQL. I'm making the assumption that it's a Unix environment you want to make the call within? If it is, give me a shout and I'll let you have the code... Regards, Kev. __ 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: 11 September 2001 13:10 To: Multiple recipients of list ORACLE-L Hallo, Is it possible to do ftp commands directly from PL/SQL procedur? Including logon to the ftp server.? Give me an example please if possible. Thanks in advance Roland -- 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: 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: Downloading from Oracle
r all our friends OK in WTC disaster ?? Srini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 9:55 AM At 09:15 AM 9/11/2001, you wrote: I am too in the same shoes. Any help from others?? Rajesh i use getright. seems to work ok for me. -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Stack Error: Lost on a cluttered desk... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: VeniVas 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: Snapshot Refresh Process ??
I'm interested in the cutover point. Our snapshots are set up with FORCE, which allows Oracle to choose between a FAST or a COMPLETE. But at what point does Oracle decide that it will be faster to do the complete? Does Oracle need to have the tables analyzed so that it has some statistics to work with? Obviously, I'm unclear on the whole thing. Tracy Rahmlow Tracy.RahmlowTo: Multiple recipients of list ORACLE-L @aexp.com[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Snapshot Refresh Process ?? om 09/11/2001 12:10 AM Please respond to ORACLE-L At times it is faster to do a complete refresh of an oracle snapshot rather than an incremental (fast). My question is how do you know when to do the complete? For example, there are times when a user will run a conversion and they may update 10% of the rows in the master table. If I do a fast refresh it may take 4 hours but if I did a complete it takes 2 hours. I have not seen a pattern in determing the breakeven point. For example, one table we may update 20% of the rows and the incremental is faster other times we update 5% of the rows in a different table and the complete would have been an better option. (Don't quote me on the percentages, just trying to make a point) I remember seeing a reference to this issue that it was addressed at ioug conference years ago, but I did not find anything there. So again the question: What factor(s) should be considered to determine which process(fast or complete) will provide for a faster refresh for higher than normal updates to a master table? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow 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 can I read this dump
Hi list I've done a sql_trace_in_session of a user process and I'm getting a big dump. I'm just curious about this line in particular: PARSE #34:c=7,e=8,p=0,cr=8,cu=2,mis=1,r=0,dep=0,og=3,tim=1236949953 What does tim mean? How can I read it? TIA ___ Do You Yahoo!? Yahoo! Messenger: Comunicación instantánea gratis con tu gente - http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= 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: Interesting News..
So, as you devote the extra minutes to your job, does this mean COMPAQ customer service will get better or worse? EG -Original Message- Sent: Monday, September 10, 2001 10:50 PM To: Multiple recipients of list ORACLE-L After thinking about this whole thing further, I realize I've made a terrible mistake. I've stooped to his level rather than stay mature about the whole thing and let it go. It won't happen again. To all of you who've had to receive these messages, I'm sorry. I'm done with this thread. Jon Walthour -Original Message- Sent: Monday, September 10, 2001 7:28 PM To: Walthour, Jon (GEAE, Compaq) Cc: [EMAIL PROTECTED] Jon, Believe it or not, some people *DO* know they are getting screwed even if the person doing it is being superficially polite. regards, ep On 10 Sep 2001, at 19:19, Walthour, Jon (GEAE, Compaq) [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date sent: Mon, 10 Sep 2001 19:19:17 -0400 Eric: I wasn't being a pissy little fascist as you call it. I was attempting to be respectful of you, courteous and professional. But, since you obviously insist on responding like the child you are, let me say, Sticks and stones may break my bones, but names will never hurt me. :-P Who pissed in your Cheerios this morning? Jon Walthour Oracle Database Administrator COMPAQ DBA Team Cincinnati, Ohio -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walthour, Jon (GEAE, Compaq) 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).
New York/East Coast !!!!
I sure hope our members on the East Coast are ok. If anyone is out there and has access, I'd be happy to pass along any messages to family, etc. Let us know if you guys are ok. Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert 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: STOP THE PRESS!!
Looks like the Pentagon was also just bombed. Denise Gwinn [EMAIL PROTECTED] -- 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: OT RE: Interesting News..
very inappropriate, considering the situation Mohan, Ross MohanR@STARSTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] -SMI.comcc: Sent by: Subject: RE: OT RE: Interesting News.. root@fatcity. com 09/11/2001 09:35 AM Please respond to ORACLE-L Now for my encore, I'll crash into the World Trade Center. EG -Original Message- Sent: Tuesday, September 11, 2001 8:00 AM To: Multiple recipients of list ORACLE-L Ok guys, now tell us how you really feel. :o) I just about choked from laughing. Dave -Original Message- Sent: Monday, September 10, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Eric, I join with you in emptying the contents of my venom sac deep into the putrid flesh of shitty vendors like Oracle, Microsoft, and yes..COMCRAP. Getting tired of reading Service is Our Number One Priority when it is clearly fifth or sixth, directly under. F*cking You Hard When We Can or Doing Kind of The Best We Feel Like, Depending on the Weather or You'll Get NOTHING, and LIKE IT, or You're Our Plaything Now That You've Drunk from the Proprietary Kool-Aid Good Customer Service is really really really rare, especially when you factor in consistent delivery of same. Multibillion dollar corporations that get away with murder on a daily basis are...well...a dime a dozen. Now I must rest...as my venom sacs once again fill with their sweet liquid of death - Ross -Original Message- Sent: Monday, September 10, 2001 5:17 PM To: Multiple recipients of list ORACLE-L K- I apparently made the mistake of thinking that the US constitution says that there is a right to FREE SPEECH in this friggin country. I'm reporting what a reseller is saying about his several years of experience, and what bugs the daylights out of the people that ACTUALLY PAY MONEY FOR A PRODUCT (known as customers for those that have never heard the word before). Note that the resalescritter was specifically addressing the headaches reported by CUSTOMERS at sites using service offerings in the SUB-enterprise category. Anyone feel free to call me an idiot (HELP), that I'm wrong, or whatever, but absent the technical merits of a pro-Compaq position having been presented in detail, all I hear is someone acting like a pissy little fascist. My writing wasn't exacty at the level of the Great Bard, but it would help if people would read a bit more carefully before they barf. Speaking of which, I'm sick of all the crap (lying/etc.) from vendors and their employees and the friends of their employees, and having them expecting the customers to kiss their a$$es all the time because they are some big megacorp. Of course the good news is that I can now go around telling people that if they want good services, they should buy IBM since there are so many a$$holes in the Compaq world. brgrds, ep [ via ORACLE-L Digest -- Volume 2001, Number 251]
OT
Title: OT I hope everyone on this list in the New York area is safe I am so scared. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117
Sad News - Jets crashed into World Trade Center
Did anyone see this? 2 small jets crashed into World Trade Center in NY shortly before 9am. I feel horrible and sorry for all the people suffered. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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: Do fast full index scans do physical disk reads?
Awww, come on, Chris. You're starting to sound like a COMPAQ customer service rep. ;-) -Original Message- Sent: Tuesday, September 11, 2001 9:50 AM To: Multiple recipients of list ORACLE-L If you read the email as I wrote it, it was a sarcastic response to someone elses posts. And a few emails later I reiterated that it was only meant sarcastically. But take it as you may. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, September 10, 2001 8:03 PM To: 'Christopher Spence'; 'Multiple recipients of list ORACLE-L ' Anyone who informs the group of his high IQ is not suffering from humility. In doing so, one invites the occaisonal barb. However continuing to do so would be childish. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 10, 2001 3:36 PM To: MacGregor, Ian A.; 'Multiple recipients of list ORACLE-L ' I resent the self-touting, the email you are probably refering to was a sarcastic one of someone (I believe Mark's) email. I am actually fairly humble for the most part. Although I tend to be quite sarcastic at times and on email it is sometimes hard to see my humor in most everything I say. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/10/01 6:40 PM Yes it's fun getting Chris, our self-touting genuis. However, the point is not that unique indexes cannot be compressed, but that the prefix length canot be mre that one less than the numbewr of coluymns in the index. Ian A MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 10, 2001 2:55 PM To: Multiple recipients of list ORACLE-L Whoa Chris, gotcha on that one. :) The combination of columns may be unique, but you can certainly compress a unique index for significant space savings. The unique index I used in testing had three columns, ordered most selective first. By reversing the column order of the index and compressing it, the index went from 180 Megs to 60 megs. The cardinality of the new leading column was 26 in table of 1.5 million rows. Jared Christopher Spence To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cspence@FuelS cc: pot.com Subject: RE: Do fast full index scans do physical disk reads? Sent by: [EMAIL PROTECTED] om 09/10/01 01:20 PM Please respond to ORACLE-L Yes, there is no point in compressing all columns of a unique index as it would result in 0% compression as they are unique. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, September 10, 2001 3:55 PM To: Multiple recipients of list ORACLE-L The restriction is on unique indexes. 1* select column_name from dba_ind_COLUMNS where INDEX_NAME = 'WOLO_PK' SQL / COLUMN_NAME PERSON_ID INSTITUTION_CODE ALTER INDEX CASEPUPPY.WOLO_PK REBUILD COMPRESS 2 TABLESPACE PEPII_INDEX / REBUILD COMPRESS 2 TABLESPACE PEPII_INDEX * ERROR at line 2: ORA-25194: invalid COMPRESS prefix length value ALTER INDEX CASEPUPPY.WOLO_PK REBUILD COMPRESS 1 TABLESPACE PEPII_INDEX / Index altered. This was done on an 8.1.6.3 database. As far as what's done in practice, I would hazard accepting the Oracle defaults for prefix length values is the most common. The documentation states: For unique indexes, the valid range of prefix length values is from 1 to the number of key columns minus 1. The default prefix length is the number of key columns minus 1. For nonunique indexes, the valid range of prefix length values is from 1 to the number of key columns. The default prefix length is the number of key columns. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 10, 2001 11:26 AM To: Multiple recipients of list ORACLE-L Actually you can create compressed indexes
RE: OT RE: Interesting News..
Not funny, Ross. --Walt Weaver Bozeman, Montana -Original Message- Sent: Tuesday, September 11, 2001 8:35 AM To: Multiple recipients of list ORACLE-L Now for my encore, I'll crash into the World Trade Center. EG -Original Message- Sent: Tuesday, September 11, 2001 8:00 AM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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: Ftp from Oracle
The only way I would think would be an External Procedure. -Original Message- Sent: Tuesday, September 11, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Not that I know of through PL/SQL, but you can use Java Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 11, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Hallo, Is it possible to do ftp commands directly from PL/SQL procedur? Including logon to the ftp server.? Give me an example please if possible. Thanks in advance Roland -- 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: Christopher Spence 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: 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).
today is disaster recovery drill day
burn your .dmp to CDs and head for the hills. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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: STOP THE PRESS!!
Capitol Hill? Are you sure? Pat. -Original Message- From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: STOP THE PRESS!! The south Tower of the World Trade Center is no more. and Capitol Hill and the Pentagon have been hit also. hope all from the list who work in the vicinity are OK. -Original Message- Sent: 11 September 2001 15:25 To: Multiple recipients of list ORACLE-L List, I am sure many of you Americans will have woken to this news, or maybe you got to work before it happened: I just saw on the news the World Trade Centre in NY, has just taken two direct hits from two separate aeroplanes!! Suspected to be a terrorist assault. Full video the lot!! They hit around the top of the buildings.. My heart goes out to those in the buildings.. What will THIS do for the American economy? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- 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). 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: 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).
OT Breaking News
Off topic and serious for once; The World Trade Towers, the Pentagon, the USA Today building have all been hit by bombs. The first is quite major. There is word here in DC that they are evacuating people from around the White House. -- 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).
RE: Sad News - Jets crashed into World Trade Center
Small... 1 DC-3 and one Boeing 767. Pat. -Original Message- From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 11:15 AM To: Multiple recipients of list ORACLE-L Subject: Sad News - Jets crashed into World Trade Center Did anyone see this? 2 small jets crashed into World Trade Center in NY shortly before 9am. I feel horrible and sorry for all the people suffered. Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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: OT RE: Interesting News..
Agreed 110%, that was just wrong. Friends have died this event. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 11, 2001 11:10 AM To: Multiple recipients of list ORACLE-L very inappropriate, considering the situation Mohan, Ross MohanR@STARSTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] -SMI.comcc: Sent by: Subject: RE: OT RE: Interesting News.. root@fatcity. com 09/11/2001 09:35 AM Please respond to ORACLE-L Now for my encore, I'll crash into the World Trade Center. EG -Original Message- Sent: Tuesday, September 11, 2001 8:00 AM To: Multiple recipients of list ORACLE-L Ok guys, now tell us how you really feel. :o) I just about choked from laughing. Dave -Original Message- Sent: Monday, September 10, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Eric, I join with you in emptying the contents of my venom sac deep into the putrid flesh of shitty vendors like Oracle, Microsoft, and yes..COMCRAP. Getting tired of reading Service is Our Number One Priority when it is clearly fifth or sixth, directly under. F*cking You Hard When We Can or Doing Kind of The Best We Feel Like, Depending on the Weather or You'll Get NOTHING, and LIKE IT, or You're Our Plaything Now That You've Drunk from the Proprietary Kool-Aid Good Customer Service is really really really rare, especially when you factor in consistent delivery of same. Multibillion dollar corporations that get away with murder on a daily basis are...well...a dime a dozen. Now I must rest...as my venom sacs once again fill with their sweet liquid of death - Ross -Original Message- Sent: Monday, September 10, 2001 5:17 PM To: Multiple recipients of list ORACLE-L K- I apparently made the mistake of thinking that the US constitution says that there is a right to FREE SPEECH in this friggin country. I'm reporting what a reseller is saying about his several years of experience, and what bugs the daylights out of the people that ACTUALLY PAY MONEY FOR A PRODUCT (known as customers for those that have never heard the word before). Note that the resalescritter was specifically addressing the headaches reported by CUSTOMERS at sites using service offerings in the SUB-enterprise category. Anyone feel free to call me an idiot (HELP), that I'm wrong, or whatever, but absent the technical merits of a pro-Compaq position having been presented in detail, all I hear is someone acting like a pissy little fascist. My writing wasn't exacty at the level of the Great Bard, but it would help if people would read a bit more carefully before they barf. Speaking of which, I'm sick of all the crap (lying/etc.) from vendors and their employees and the friends of their employees, and having them expecting the customers to kiss their a$$es all the time because they are some big megacorp. Of course the good news is that I can now go around telling people that if they want good services, they should buy IBM since there are so many a$$holes in the Compaq world. brgrds, ep [ via ORACLE-L Digest -- Volume 2001, Number 251] -- From: Kimberly Smith [EMAIL PROTECTED] Date: Fri, 7 Sep 2001 08:16:35 -0700 Subject: RE: Interesting News.. Jon, you need to get some thick skin. My company is destroyed quite often in this list (although it has been a while). -Original Message- Sent: Friday, September 07, 2001 4:50 AM To: Multiple recipients of list ORACLE-L Eric: While I can appreciate that your opinion of the Compaq Services division might be less than positive, would you please, for the sake of those who actually work for these companies, be a little less dramatic in your expression of that opinion. Jon Walthour Oracle Database Administrator COMPAQ DBA Team Cincinnati, Ohio -Original Message- Sent: Thursday, September 06, 2001 4:22 PM To: Multiple recipients of list ORACLE-L According to our hardware resalescritter: especially for anything below large enterprise level, both HP and Compaq services suck. so, I guess the objective is to create a new company who services suck even more than either individually? Synergy!!! Guy Hammond wrote: On the contrary, I'd say this is a godsend for Sun. Compaq made a mess of truly epic proportions when they
RE: Ftp from Oracle
It's possible if you setup a shell script which continually polls for information coming through on a DBMS_PIPE. A procedure within the database sends messages onto the pipe (the messages being Unix commands), the shell script then takes these commands from the pipe and builds another shell script on the fly containing the Unix command, this is then executed thereby running the unix command. Haven't tried it with an FTP command but there's no reason why you can't build your entire FTP script up as a shell script and then issue the command from within sql to run the script using the method above. Cheers, K. 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: 11 September 2001 14:45 To: Multiple recipients of list ORACLE-L Not that I know of through PL/SQL, but you can use Java Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 11, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Hallo, Is it possible to do ftp commands directly from PL/SQL procedur? Including logon to the ftp server.? Give me an example please if possible. Thanks in advance Roland -- 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: Christopher Spence 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: Ftp from Oracle
Hi Kev, Mind just posting the code to the list? I'm sure there will be many responses to yourself asking for this code, so it may be easier just to post it directly.. Cheers Mark -Original Message- Kevin Sent: Tuesday, September 11, 2001 15:00 To: Multiple recipients of list ORACLE-L Hi Roland, Yes it is possible, I have got a piece of code that I got from the site asktom.oracle.com, that allows you to send Unix commands to the shell from within SQL. I'm making the assumption that it's a Unix environment you want to make the call within? If it is, give me a shout and I'll let you have the code... Regards, Kev. __ 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: 11 September 2001 13:10 To: Multiple recipients of list ORACLE-L Hallo, Is it possible to do ftp commands directly from PL/SQL procedur? Including logon to the ftp server.? Give me an example please if possible. Thanks in advance Roland -- 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: 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). -- 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).
RE: New York/East Coast !!!!
Is there anyway we can submit names of family members in NY -Original Message- From: Stephen Andert [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 11:25 AM To: Multiple recipients of list ORACLE-L Subject: New York/East Coast I sure hope our members on the East Coast are ok. If anyone is out there and has access, I'd be happy to pass along any messages to family, etc. Let us know if you guys are ok. Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert 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: Giles, Teri 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: Ftp from Oracle
Are my emails getting through to this list??? I did send a couple of responses regarding this one but I haven't personally seen them.. K. :( -Original Message- Sent: 11 September 2001 15:50 To: Multiple recipients of list ORACLE-L The only way I would think would be an External Procedure. -Original Message- Sent: Tuesday, September 11, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Not that I know of through PL/SQL, but you can use Java Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 11, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Hallo, Is it possible to do ftp commands directly from PL/SQL procedur? Including logon to the ftp server.? Give me an example please if possible. Thanks in advance Roland -- 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: Christopher Spence 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: 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). -- 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: STOP THE PRESS!!
The south Tower of the World Trade Center is no more. and Capitol Hill and the Pentagon have been hit also. hope all from the list who work in the vicinity are OK. -Original Message- Sent: 11 September 2001 15:25 To: Multiple recipients of list ORACLE-L List, I am sure many of you Americans will have woken to this news, or maybe you got to work before it happened: I just saw on the news the World Trade Centre in NY, has just taken two direct hits from two separate aeroplanes!! Suspected to be a terrorist assault. Full video the lot!! They hit around the top of the buildings.. My heart goes out to those in the buildings.. What will THIS do for the American economy? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- 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). 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: STOP THE PRESS!!
Its now 1. BOTH tower have fallen. 2. Pentagon hit by a plane. 3. All flights in US grounded And I am sure more to follow -Original Message- Sent: Tuesday, September 11, 2001 9:55 AM To: Multiple recipients of list ORACLE-L The BBC seems to have more info than the U.S. web sites. Tuesday, 11 September, 2001, 13:35 GMT 14:35 UK Planes 'attack' World Trade Center A huge explosion rocks one of towers Two planes have crashed into the World Trade Center in New York City while an explosion has rocked the Pentagon in Washington DC. The White House is reportedly being evacuated. One report says six people have been killed in the New York incident while hundreds have been injured. Smoke is pouring from the upper storeys of both towers of the World Trade Center. The building, one of the world's tallest, has been badly damaged in what President George W Bush has described as an apparent terrorist attack. He said: We will find those who committed this attack. New York police have been quoted as saying that both planes were hijacked from Boston. A few minutes after the first tower was hit by a passenger plane, a second, similar plane was seen flying into the second tower. A huge explosion was seen. Eyewitnesses say the first plane crashed into the West Tower after flying unusually low over Manhattan Island. A BBC correspondent says 10 to 15 floors have been affected by the crash. Briton James Winter, 30, living in an apartment close to the centre, said he was woken a huge bang at around 0800 local time. I was in bed and there was a huge explosion. The whole building rattled and shook, he said. I ran to the window and there was smoke billowing from the south side of one of the towers. Everyone in my building was panicking and running around. The World Trade Center consists of two 110-story skyscrapers, New York's tallest buildings. One of the towers is just six feet (two metres) taller than the other. About 40,000 people work inside the two-building centre, and more than 150,000 people enter the complex every day. On 26 February, 1993, a terrorist bomb exploded in building number one's lower level. -- 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). -- 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: OT: STOP THE PRESS!!
we just lost the 2nd tower. Mark Leith wrote: List, I am sure many of you Americans will have woken to this news, or maybe you got to work before it happened: I just saw on the news the World Trade Centre in NY, has just taken two direct hits from two separate aeroplanes!! Suspected to be a terrorist assault. Full video the lot!! They hit around the top of the buildings.. My heart goes out to those in the buildings.. What will THIS do for the American economy? Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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: Downloading from Oracle
No, DAP just doesn't kick in, even when it is browser enabled. I have been able to use DAP for many Oracle files, but it's that server in the east that doesn't allow DAP. The server hosts the Applications maintenance sets. Pat. -Original Message- From: Mark Leith [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 10:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: Downloading from Oracle What is the problem with using DAP to do the download? Failing getting this working - as it almost guarantees a valid download - have you also tried some of the other download aids (getright, or real download for example)? I do agree, DAP is the best I have come across so far.. What is the error you are getting? not a valid archive file? Is the downloaded file size the same as the reported file size on the web page? I have never seemed to have a problem with DAP on the Oracle sites.. Mark -Original Message- Dayal Sent: Tuesday, September 11, 2001 14:15 To: Multiple recipients of list ORACLE-L I am too in the same shoes. Any help from others?? Rajesh -Original Message- Patrice J Sent: Tuesday, September 11, 2001 4:35 PM To: Multiple recipients of list ORACLE-L Sometimes when I download files from the Oracle web sites, I can't use Download Accelerator Plus. I like that utility, it downloads files in parallel. When I try to download using IE, 90% of the time the large .zip file is corrupt and unusable. Has anyone found a way to download the Applications service pack from Oracle successfully? TIA Patrice Boivin Systems Analyst (Oracle Certified DBA) Acting Head Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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: 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:User Query Tools
Stephen, We are in the end of just such a task for our end users. Consequently I'm going to forward your message to the project lead here. We looked at Brio Reports, Oracle's Discoverer 4i and Cognos Query. We limited our search to these for certain reasons, which I won't elaborate on. Of the three I'll state a Personal preference for Brio's product. But since the end users are the real deciding force the 'jury is still out'. Dick Goulet Reply Separator Author: Stephen Andert [EMAIL PROTECTED] Date: 9/10/2001 2:52 PM Hey all, I just got out from a meeting where I was told that some of our users are asking for a tool to do their own queries against our database so they wouldn't have to request reports and such from IS. Oh BTW, they don't know (or feel the need to learn) SQL so they will be needing something with either a good GUI QBF or some kind of natural language interface. We are leaning against MS Query to avoid ODBC performance problems. Does anyone out there have users like this? Any product referrals with pros/cons? TIA If you have any questions, please feel free to call me or drop me a note. Stephen Andert 480-445-2506 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 5.50.4522.1800 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px DIVHey all, /DIV DIVnbsp;/DIV DIVI just got out from a meeting where I was told that some of our users are asking for a tool to do their own queries against our database so they wouldn't have to request reports and such from IS.nbsp; Oh BTW, they don't know (or feel the need to learn) SQL so they will be needing something with either a good GUI QBF or some kind of natural language interface.nbsp; /DIV DIVnbsp;/DIV DIVWe are leaning against MS Query to avoid ODBC performance problems./DIV DIVnbsp;/DIV DIVDoesnbsp;anyone out there have users like this?nbsp; Any product referrals with pros/cons?nbsp; /DIV DIVnbsp;/DIV DIVTIABR/DIV DIVnbsp;/DIV DIVIf you have any questions, please feel free to call me or drop me a note./DIV DIVnbsp;/DIV DIVStephen AndertBR480-445-2506/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 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
Title: Message Similar wishes here. I wish the best for all involved. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: OT I hope everyone on this list in the New York area is safe I am so scared. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117
RE: STOP THE PRESS!!
Both buildings have now completely collapsed. I first found out about it when I stepped out of the PATH train station and saw the flames. Currently I'm stranded in New Jersey and going a little crazy about some friends that work in dowtown NYC, but otherwise I'm fine. My prayers are with all list members in the area or with friends and relatives in the area. Jay Miller -Original Message- Sent: Tuesday, September 11, 2001 10:55 AM To: Multiple recipients of list ORACLE-L The BBC seems to have more info than the U.S. web sites. Tuesday, 11 September, 2001, 13:35 GMT 14:35 UK Planes 'attack' World Trade Center A huge explosion rocks one of towers Two planes have crashed into the World Trade Center in New York City while an explosion has rocked the Pentagon in Washington DC. The White House is reportedly being evacuated. One report says six people have been killed in the New York incident while hundreds have been injured. Smoke is pouring from the upper storeys of both towers of the World Trade Center. The building, one of the world's tallest, has been badly damaged in what President George W Bush has described as an apparent terrorist attack. He said: We will find those who committed this attack. New York police have been quoted as saying that both planes were hijacked from Boston. A few minutes after the first tower was hit by a passenger plane, a second, similar plane was seen flying into the second tower. A huge explosion was seen. Eyewitnesses say the first plane crashed into the West Tower after flying unusually low over Manhattan Island. A BBC correspondent says 10 to 15 floors have been affected by the crash. Briton James Winter, 30, living in an apartment close to the centre, said he was woken a huge bang at around 0800 local time. I was in bed and there was a huge explosion. The whole building rattled and shook, he said. I ran to the window and there was smoke billowing from the south side of one of the towers. Everyone in my building was panicking and running around. The World Trade Center consists of two 110-story skyscrapers, New York's tallest buildings. One of the towers is just six feet (two metres) taller than the other. About 40,000 people work inside the two-building centre, and more than 150,000 people enter the complex every day. On 26 February, 1993, a terrorist bomb exploded in building number one's lower level. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: STOP THE PRESS!!
Actually the World Trade Center is no more. Both towers have collapsed in on themselves. As for the economy, it will have global implications. Rachel, are you on today? How close is all this to you? Rodd Original Message On 9/11/01, 9:25:27 AM, Mark Leith [EMAIL PROTECTED] wrote regarding OT: STOP THE PRESS!!: List, I am sure many of you Americans will have woken to this news, or maybe you got to work before it happened: I just saw on the news the World Trade Centre in NY, has just taken two direct hits from two separate aeroplanes!! Suspected to be a terrorist assault. Full video the lot!! They hit around the top of the buildings.. My heart goes out to those in the buildings.. What will THIS do for the American economy? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- 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: Rodd Holman 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
Title: OT this is the most bizarre day of my entire life. I watched the second tower collapse from my office window. I basically just feel completely sick to my stomach right now. I hope that there is no one on this list from NYC. kk -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Tuesday, September 11, 2001 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: OT I hope everyone on this list in the New York area is safe I am so scared. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117
RE: OT Breaking News
They were actually planes and not bombs. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 11, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Off topic and serious for once; The World Trade Towers, the Pentagon, the USA Today building have all been hit by bombs. The first is quite major. There is word here in DC that they are evacuating people from around the White House. -- 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: Christopher Spence 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: STOP THE PRESS!!
Yep, according to the live news Lee -Original Message- Sent: 11 September 2001 15:48 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Capitol Hill? Are you sure? Pat. -Original Message- From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: STOP THE PRESS!! The south Tower of the World Trade Center is no more. and Capitol Hill and the Pentagon have been hit also. hope all from the list who work in the vicinity are OK. -Original Message- Sent: 11 September 2001 15:25 To: Multiple recipients of list ORACLE-L List, I am sure many of you Americans will have woken to this news, or maybe you got to work before it happened: I just saw on the news the World Trade Centre in NY, has just taken two direct hits from two separate aeroplanes!! Suspected to be a terrorist assault. Full video the lot!! They hit around the top of the buildings.. My heart goes out to those in the buildings.. What will THIS do for the American economy? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- 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). 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: 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).
unable to insert into table with datatype raw
create table ff (dd raw(16));
SQL insert into ff (select hex_to_raw('234') from dual);
insert into ff (select hex_to_raw('234') from dual)
*
ERROR at line 1:
ORA-01465: invalid hex number
SQL select hex_to_raw('234') from dual;
HEX_TO_RAW('234')
---
#
Thanks
-Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
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: STOP THE PRESS!!
I am wondering whether this was an attack from outside, or from people like Timothy McVeigh. It seems to be awfully well co-ordinated, how could they breach security to that extent. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -- 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: STOP THE PRESS!!
They found out the planes were not from boston (10 miles from me). I can't remember where they claimed to come from. Pentagon was confirmed not bomb, but 2 planes crashed into it, minor damage. Claim is when the market open (today or other) will open rock bottom and crashed. Claim for Martial law is potential. Which means military and curfew enforcement amoung the areas. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 11, 2001 10:55 AM To: Multiple recipients of list ORACLE-L The BBC seems to have more info than the U.S. web sites. Tuesday, 11 September, 2001, 13:35 GMT 14:35 UK Planes 'attack' World Trade Center A huge explosion rocks one of towers Two planes have crashed into the World Trade Center in New York City while an explosion has rocked the Pentagon in Washington DC. The White House is reportedly being evacuated. One report says six people have been killed in the New York incident while hundreds have been injured. Smoke is pouring from the upper storeys of both towers of the World Trade Center. The building, one of the world's tallest, has been badly damaged in what President George W Bush has described as an apparent terrorist attack. He said: We will find those who committed this attack. New York police have been quoted as saying that both planes were hijacked from Boston. A few minutes after the first tower was hit by a passenger plane, a second, similar plane was seen flying into the second tower. A huge explosion was seen. Eyewitnesses say the first plane crashed into the West Tower after flying unusually low over Manhattan Island. A BBC correspondent says 10 to 15 floors have been affected by the crash. Briton James Winter, 30, living in an apartment close to the centre, said he was woken a huge bang at around 0800 local time. I was in bed and there was a huge explosion. The whole building rattled and shook, he said. I ran to the window and there was smoke billowing from the south side of one of the towers. Everyone in my building was panicking and running around. The World Trade Center consists of two 110-story skyscrapers, New York's tallest buildings. One of the towers is just six feet (two metres) taller than the other. About 40,000 people work inside the two-building centre, and more than 150,000 people enter the complex every day. On 26 February, 1993, a terrorist bomb exploded in building number one's lower level. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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).
db link from oracle 8.1.7 to 8.0.5
Title: db link from oracle 8.1.7 to 8.0.5 hi list, i am trying to make a database link from oracle 8.1.7 to oracle 8.0.5, but its failing, giving message DB LINK NOT ACTIVE global_names parameter is false on both the database, the schema in which its being created exists in both the databases with same password and privillages, and i am using CONNECTED USER mode of database link, is that possible to create db link in such conditions, any suggestions, Thanks in Advance Arslan
RE: Do fast full index scans do physical disk reads?
Well thanks for you comment, but you are no means the list master. Why don't you send this useless email to everyone who posts off topic. Have a nice day -Original Message- Sent: Tuesday, September 11, 2001 10:12 AM To: [EMAIL PROTECTED] Apparently you never learned the lesson that goes If you can't say something nice, then it is better to say NOTHING at all!. PLEASE keep your OFF TOPIC remarks OFF the list! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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: STOP THE PRESS!!
According to AP. It looks like the entire island of Manhatten is one big ball of black smoke. AA Flt. 11 from Boston hit one WTC. UA FLt. 175 from boston hit the other. AA Flt. 77 hit the Pentagon. UA Flt 93 crashed in Pittsburg - questionable target?? Untold numbers of people dead in the buildings - projecting at least 20,000 inside. Possible secondary bombs exploded that collapsed the buildings. Suspect bomb in a high school nearby too. Continue to hear explosions all downtown - gas lines exploding... Pretty sure it's BinLadin who is being kept in Afghanistan. It will be WAR for sure on Afghanistan if they continue to harbor him. Pictures of Palestinians CELEBRATING this on the West Bank. -Original Message- Sent: Tuesday, September 11, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Its now 1. BOTH tower have fallen. 2. Pentagon hit by a plane. 3. All flights in US grounded And I am sure more to follow -Original Message- Sent: Tuesday, September 11, 2001 9:55 AM To: Multiple recipients of list ORACLE-L The BBC seems to have more info than the U.S. web sites. Tuesday, 11 September, 2001, 13:35 GMT 14:35 UK Planes 'attack' World Trade Center A huge explosion rocks one of towers Two planes have crashed into the World Trade Center in New York City while an explosion has rocked the Pentagon in Washington DC. The White House is reportedly being evacuated. One report says six people have been killed in the New York incident while hundreds have been injured. Smoke is pouring from the upper storeys of both towers of the World Trade Center. The building, one of the world's tallest, has been badly damaged in what President George W Bush has described as an apparent terrorist attack. He said: We will find those who committed this attack. New York police have been quoted as saying that both planes were hijacked from Boston. A few minutes after the first tower was hit by a passenger plane, a second, similar plane was seen flying into the second tower. A huge explosion was seen. Eyewitnesses say the first plane crashed into the West Tower after flying unusually low over Manhattan Island. A BBC correspondent says 10 to 15 floors have been affected by the crash. Briton James Winter, 30, living in an apartment close to the centre, said he was woken a huge bang at around 0800 local time. I was in bed and there was a huge explosion. The whole building rattled and shook, he said. I ran to the window and there was smoke billowing from the south side of one of the towers. Everyone in my building was panicking and running around. The World Trade Center consists of two 110-story skyscrapers, New York's tallest buildings. One of the towers is just six feet (two metres) taller than the other. About 40,000 people work inside the two-building centre, and more than 150,000 people enter the complex every day. On 26 February, 1993, a terrorist bomb exploded in building number one's lower level. -- 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). -- 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).
Terrorist Attacks.
...about two hours ago...when people were clustered around radios...not quite believing...hearing rumors...someone lost a quarter in the soda machine, which is quite heavy. As they shook it, the floor and walls rumbled. It sounded like a distant explosion. I found out at that moment how scared I was... -Original Message- Sent: Tuesday, September 11, 2001 12:05 PM To: Multiple recipients of list ORACLE-L Similar wishes here. I wish the best for all involved. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 11, 2001 11:15 AM To: Multiple recipients of list ORACLE-L I hope everyone on this list in the New York area is safe I am so scared. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 --_=_NextPart_001_01C13AD8.D95C3410 Content-Type: text/html; charset=iso-8859-1 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 TITLEMessage/TITLE META content=MSHTML 5.50.4616.200 name=GENERATOR/HEAD BODY DIVSPAN class=087374315-11092001FONT face=Arial color=#ff size=2...about two hours ago...when people were clustered around radios...not quite/FONT/SPAN/DIV DIVSPAN class=087374315-11092001FONT face=Arial color=#ff size=2believing...hearing /FONT/SPANSPAN class=087374315-11092001FONT face=Arial color=#ff size=2rumors...someone lost a quarter in the soda machine, which /FONT/SPAN/DIV DIVSPAN class=087374315-11092001FONT face=Arial color=#ff size=2is quite heavy.nbsp; /FONT/SPANSPAN class=087374315-11092001FONT face=Arial color=#ff size=2As they shook it, the floor and walls rumbled. It sounded like a /FONT/SPAN/DIV DIVSPAN class=087374315-11092001FONT face=Arial color=#ff size=2distantnbsp;explosion.nbsp; I found out at that moment how cared I was.../FONT/SPAN/DIV BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B Christopher Spence [mailto:[EMAIL PROTECTED]]BRBSent:/B Tuesday, September 11, 2001 12:05 PMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B RE: OTBRBR/FONT/DIV DIVSPAN class=467310015-11092001FONT face=Arial color=#ff size=2Similar wishes here.nbsp; I wish the best for all involved./FONT/SPAN/DIV!-- Converted from text/rtf format -- PFONT face=Times New RomanDo not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes./FONT/P PFONT face=Script size=5Christopher R. Spence/FONT BRFONT face=Comic Sans MS size=2Oracle DBA/FONT BRFONT face=Comic Sans MS size=2Phone: (978) 322-5744/FONT BRFONT face=Comic Sans MS size=2Fax:nbsp;nbsp;nbsp; (707) 885-2275/FONT /P PFONT face=Comic Sans MS size=2Fuelspot/FONT BRFONT face=Comic Sans MS size=273 Princeton Street/FONT BRFONT face=Comic Sans MS size=2North, Chelmsford 01863/FONT BRFONT face=Comic Sans MS size=2/FONTnbsp; /P BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px DIV/DIV DIV class=OutlookMessageHeader lang=en-us dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B Koivu, Lisa [mailto:[EMAIL PROTECTED]] BRBSent:/B Tuesday, September 11, 2001 11:15 AMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B OTBRBR/FONT/DIV PFONT face=GeorgiaI hope everyone on this list in the New York area is safenbsp; I am so scared./FONT /P PFONT face=GeorgiaLisa Koivu/FONT BRFONT face=GeorgiaOracle Database Administrator/FONT BRFONT face=GeorgiaFairfield Resorts, Inc./FONT BRFONT face=Georgia954-935-4117/FONT /P/BLOCKQUOTE/BLOCKQUOTE/BODY/HTML --_=_NextPart_001_01C13AD8.D95C3410-- -- 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).
Re: Inserting records into a table without creating indexes
No. There is no provision for deferred index creation in Oracle. Having faced similar issues with large, hot OKTP systems, I can sympathize. Be very picky about what indexes are allowed on tables with high insert rates. Careful segregation of the affected segments between disks.can help also. -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 8:30 AM List, Environment: Solaris 7 : Oracle 817 : OLTP system with stringent throughput requirements A transaction inserts a record into 4 tables. After successful insert into all the four tables, the transaction issues a commit. Many alternate index keys (AK's) are defined on each table. Expected number of transactions : 300 - 400 transactions per second. Requirement: While insert is taking place on the tables, I do not want to create indexes. Immediately After the transaction is committed, I want to create indexes for the inserted record. I do not want disable the indexes during the transaction processing. Is the above requirement feasible? Or am I on a wrong path? Please advise. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara 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: Don Granaman 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).
News
Another plane crash in Pennsylvania. Take care friends Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121
Re[2]: Re[2]: RE: Interesting News..
Eric, One of these days some genius will figure out how we can do e-mail with video and audio vs. just plain text characters. Then the non-verbal messages maybe able to make the transit as well as the text which will kill a lot of these misunderstandings. Dick Goulet Reply Separator Author: Eric D. Pierce [EMAIL PROTECTED] Date: 9/10/2001 3:42 PM Dick, Short/brusque, me Thanks! :) I don't mind being called on it if someone thinks I'm being argumentative (HELP, am I an idiot?), the thing that bugs me is when it is done in such a manner that the chastiser sounds like a pissy little fascist (autocratic/dicatorial/conformist/suppressive of opposition/etc). Even worse is when they then go on to provide absolutely no further useful/interesting information on the subject (by which their otherwise cr*ppy attitude could perhaps be ever so slightly redeemed). With infinite wisdom, the Creator of the universe (the God that doesn't think he is Larry Ellison) brought about cooperation and competition. Looks like we need to work on cooperation at this point. I do recognize that the world isn't divided into bad evil corporate types, and innocent customers. The situation in the industry is complex, and subject to wrenching changes (eg, PCs as commodities) and bad times. If customers were more responsible about understanding the industry, and trying to support good players in various ways, there is no doubt that the world would be more full of good at this point. At the same time, the hype, arrogance, and techno- insularization that crops up on on the corporate side is very annoying, and I'm getting really sick of it. I think it would be useful if corporate people would try to learn a little bit about systems theory (cybernetics, self-learning and self- organization of communities of interest, communities of competence, etc.), and gain an understanding of how there are always informal information sharing mechanisms that function as needed alternatives to the formal mechanisms of management, information control and corporate mission. Given that there appears to be a fair amount of awareness of the internal need to run companies in smart mode with respect to the internal value of such informal dynamics, one has to wonder if it is just too hard to deal with the chaos involved in extending those methods to external relations with customers? As always, your comrade in visualizing whirled peas, ep On 10 Sep 2001, at 16:37, [EMAIL PROTECTED] scribbled with alacrity and cogency: Date sent: Mon, 10 Sep 2001 16:37:43 -0400 To: Eric D. Pierce [EMAIL PROTECTED], Multiple recipients of list ORACLE-L [EMAIL PROTECTED] To All, As much as this thread is apparently getting a little terse (No I'm NOT getting on ANYBODY's case) it is a relief to realize that I'm not the only person who gets barbecued for what I believe is a normal, non argumentative e-mail message. If I have a nickel for every time one of my local colleagues called me a bonehead for a message, I could have retired last year! Guess Eric I are both in the STBU club! Eric, welcome aboard! :-) Dick Goulet Reply Separator Subject:Re: RE: Interesting News.. Author: Eric D. Pierce [EMAIL PROTECTED] Date: 9/10/2001 1:17 PM K- I apparently made the mistake of thinking that the US constitution says that there is a right to FREE SPEECH in this friggin country. I'm reporting what a reseller is saying about his several years of experience, and what bugs the daylights out of the people that ACTUALLY PAY MONEY FOR A PRODUCT (known as customers for those that have never heard the word before). Note that the resalescritter was specifically addressing the headaches reported by CUSTOMERS at sites using service offerings in the SUB-enterprise category. Anyone feel free to call me an idiot (HELP), that I'm wrong, or whatever, but absent the technical merits of a pro-Compaq position having been presented in detail, all I hear is someone acting like a pissy little fascist. My writing wasn't exacty at the level of the Great Bard, but it would help if people would read a bit more carefully before they barf. Speaking of which, I'm sick of all the crap (lying/etc.) from vendors and their employees and the friends of their employees, and having them expecting the customers to kiss their a$$es all the time because they are some big megacorp. Of course the good news is that I can now go around telling people that if they want good services, they should buy IBM since there are so many a$$holes in the Compaq world. brgrds, ep [ via ORACLE-L Digest -- Volume 2001, Number 251] -- From: Kimberly Smith [EMAIL PROTECTED] Date: Fri, 7 Sep 2001 08:16:35 -0700 Subject: RE: Interesting
RE: STOP THE PRESS!!
The first tower is down, the second one is falling, the Pentagon had two planes crash into it as well. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 11, 2001 10:25 AM To: Multiple recipients of list ORACLE-L List, I am sure many of you Americans will have woken to this news, or maybe you got to work before it happened: I just saw on the news the World Trade Centre in NY, has just taken two direct hits from two separate aeroplanes!! Suspected to be a terrorist assault. Full video the lot!! They hit around the top of the buildings.. My heart goes out to those in the buildings.. What will THIS do for the American economy? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- 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: Christopher Spence 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: STOP THE PRESS!!
Terror attacks hit U.S. September 11, 2001 Posted: 1457 GMT People walk away from the World Trade Center as ash rains down. NEW YORK (CNN) -- Terrorists struck the United States Tuesday morning in harrowing, widespread attacks that included at least three commercial jet crashes into significant buildings. * In the first attack, a plane hit the north tower of the World Trade Center in Manhattan shortly before 9 a.m., followed by another plane into the second tower about 20 minutes later. Both towers later collapsed. * About an hour later, a plane crashed into the Pentagon, part of which later collapsed. * American Airlines told CNN that it lost two planes in tragic accidents: Flight 11 from Boston with 81 passengers and 11 crew aboard and Flight 77 from Washington Dulles airport with 58 passengers and six crew aboard. Both planes were en route to Los Angeles * United Airlines Flight 93 airliner headed from Newark, New Jersey, to San Francisco, crashed near Somerset, Pennsylvania -- police said initial reports indicated no survivors. It was not known if this was connected to the attacks. United also said it was deeply concerned about Flight l75 from Boston to Los Angeles. * The Pentagon, the White House, the State Department, the Justice Department, the Capitol, the CIA and all other government buildings in Washington evacuated. * In the first ever national ground stop of aircraft, all flights nationwide have been stopped at their departure airports. * All international flights were diverted to Canada. * Israel has evacuated all its missions around the world. * President Bush cancelled an appearance in Florida to return to Washington, calling the crashes apparent terrorist attacks and a national tragedy. * In Chicago, the Sears Tower was evacuated; United Nations in New York evacuated. * The Centers for Disease Control and Prevention in Atlanta was evacuated. CDC was preparing bioterrorism teams in case they become necessary. * The New York Port Authority said it had closed all bridges and tunnels into the city. * New York's Bellevue Hospital was designated command central for handling the catastrophe. Several hospitals have already reported receiving victims with burns and head injuries. * U.S. stock markets were closed after the New York attacks. -- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] -Original Message- From: Rodd Holman [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 09:35 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: STOP THE PRESS!! Actually the World Trade Center is no more. Both towers have collapsed in on themselves. As for the economy, it will have global implications. Rachel, are you on today? How close is all this to you? Rodd Original Message On 9/11/01, 9:25:27 AM, Mark Leith [EMAIL PROTECTED] wrote regarding OT: STOP THE PRESS!!: List, I am sure many of you Americans will have woken to this news, or maybe you got to work before it happened: I just saw on the news the World Trade Centre in NY, has just taken two direct hits from two separate aeroplanes!! Suspected to be a terrorist assault. Full video the lot!! They hit around the top of the buildings.. My heart goes out to those in the buildings.. What will THIS do for the American economy? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- 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: Rodd Holman 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
RE: OT: STOP THE PRESS!!
and the State Department in DC. WTC 1 and 2 are down pray for the familes.. -Original Message- Sent: Tuesday, September 11, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Looks like the Pentagon was also just bombed. Denise Gwinn [EMAIL PROTECTED] -- 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).
Re: OT Terrorist Acts
At 12:15 PM 9/11/2001, you wrote: Yes, I see that and wish i could remove it. Consider it done We've just heard the towers went downjust incredible..i had never thought that i'd be there at the start of World War III. And wanted very badly to fight in it. to you all: someone once said those who hate war the most are those best trained in it's use. trust me, you DON'T want to fight in a war. you may end up doing just that, but you don't want to. i had friends who's pentagon offices were where the impact was. and i wish death wasn't a friend of mine. -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Stack Error: Lost on a cluttered desk... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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).
TERRORIST ACTS
This Reuters report is spot on accurate from my seat, in downtown DC, about five blocks from White House. I am going out to have another look now, and will report back, but ...I have NEVER seen anything like this...people are shocked...there is NO business as usual attitude here. more later.. ## Panic Reigns on Washington Streets Reuters Sep 11 2001 11:31AM WASHINGTON (Reuters) - Panic-stricken Washington pedestrians froze in their tracks when they heard the whir of a plane overhead on Tuesday after plane attacks demolished New York's World Trade Center and damaged the Pentagon. Washington workers flooded the streets near the White House and elsewhere after all federal buildings were ordered evacuated and other businesses shut down. But some people seemed bewildered about what to do next. I'm totally freaked out. Hearing the plane going over my head was frightening, Elissa Brainard, 29, told Reuters as she joined the 150 yard line to get her car from the parking garage. But even with her car, Brainard faced a long wait to get home, as gridlock hit Washington's roads. Drivers ran red lights and sped across intersections, sending pedestrians scattering. Police near the White House tried to direct traffic, but a few blocks away chaos reigned, thwarting the efforts of emergency vehicles. Wailing sirens from fire engines, police patrols and ambulances mingled with car horns, whistles and human cries. Everything is going crazy. People are getting so stressed out, one office worker said. CELLULAR TELEPHONE MELTDOWN Pedestrians hurried away from the federal quarter and clutched cellular telephones to their ears, desperately trying to reach loved ones. But cellular telephone networks seemed to be disrupted and people began to line up at public phones. I'm terrified. We tried to call on the cellphone but they weren't working, office assistant Val Thornton said. Thornton, whose commuter bus takes her past the Pentagon to her Virginia home, did not know how she would get out of the city. -- 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).
RE: OT RE: Interesting News..
Feeling Good. Keep it up. Ok guys, now tell us how you really feel. :o) I just about choked from laughing. Dave -Original Message- Sent: Monday, September 10, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Eric, I join with you in emptying the contents of my venom sac deep into the putrid flesh of shitty vendors like Oracle, Microsoft, and yes..COMCRAP. Getting tired of reading Service is Our Number One Priority when it is clearly fifth or sixth, directly under. F*cking You Hard When We Can or Doing Kind of The Best We Feel Like, Depending on the Weather or You'll Get NOTHING, and LIKE IT, or You're Our Plaything Now That You've Drunk from the Proprietary Kool-Aid Good Customer Service is really really really rare, especially when you factor in consistent delivery of same. Multibillion dollar corporations that get away with murder on a daily basis are...well...a dime a dozen. Now I must rest...as my venom sacs once again fill with their sweet liquid of death - Ross -Original Message- Sent: Monday, September 10, 2001 5:17 PM To: Multiple recipients of list ORACLE-L K- I apparently made the mistake of thinking that the US constitution says that there is a right to FREE SPEECH in this friggin country. I'm reporting what a reseller is saying about his several years of experience, and what bugs the daylights out of the people that ACTUALLY PAY MONEY FOR A PRODUCT (known as customers for those that have never heard the word before). Note that the resalescritter was specifically addressing the headaches reported by CUSTOMERS at sites using service offerings in the SUB-enterprise category. Anyone feel free to call me an idiot (HELP), that I'm wrong, or whatever, but absent the technical merits of a pro-Compaq position having been presented in detail, all I hear is someone acting like a pissy little fascist. My writing wasn't exacty at the level of the Great Bard, but it would help if people would read a bit more carefully before they barf. Speaking of which, I'm sick of all the crap (lying/etc.) from vendors and their employees and the friends of their employees, and having them expecting the customers to kiss their a$$es all the time because they are some big megacorp. Of course the good news is that I can now go around telling people that if they want good services, they should buy IBM since there are so many a$$holes in the Compaq world. brgrds, ep [ via ORACLE-L Digest -- Volume 2001, Number 251] -- From: Kimberly Smith [EMAIL PROTECTED] Date: Fri, 7 Sep 2001 08:16:35 -0700 Subject: RE: Interesting News.. Jon, you need to get some thick skin. My company is destroyed quite often in this list (although it has been a while). -Original Message- Sent: Friday, September 07, 2001 4:50 AM To: Multiple recipients of list ORACLE-L Eric: While I can appreciate that your opinion of the Compaq Services division might be less than positive, would you please, for the sake of those who actually work for these companies, be a little less dramatic in your expression of that opinion. Jon Walthour Oracle Database Administrator COMPAQ DBA Team Cincinnati, Ohio -Original Message- Sent: Thursday, September 06, 2001 4:22 PM To: Multiple recipients of list ORACLE-L According to our hardware resalescritter: especially for anything below large enterprise level, both HP and Compaq services suck. so, I guess the objective is to create a new company who services suck even more than either individually? Synergy!!! Guy Hammond wrote: On the contrary, I'd say this is a godsend for Sun. Compaq made a mess of truly epic proportions when they tried to integrate DEC and Tandem into their operations. HP did just as badly with Apollo. ... -- 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). -- 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
RE: What's wrong with this query
Thanks Lisa, I have been a system dba from many years. This is my very first involvement with the pl/sql.The application was created by an Oracle consultant Co I'm just monitoring the system and feel funny about this query.There is nothing I can change. -Original Message- Sent: Tuesday, September 11, 2001 10:35 AM To: Multiple recipients of list ORACLE-L Hi Anne, What's the name of your index you want the query to use? Change your hint to correct syntax. /*+ index (b index_name) */ Do you absolutely have to have the distinct in there? The number of rows after the unique sort hasn't changed. Taking distinct out of there will help. Try both suggestions and try to trace again. Do you understand what it's telling you? If not, ask. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- Sent: Tuesday, September 11, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Thanks Thomas, Lisa, Attached is the TKPROF EXPLAIN PLAN for this query.Please review. Many thanks, TKPROF: Release 8.0.6.3.0 - Production on Tue Sep 11 07:38:26 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Trace file: texasprd_ora_24718.trc Sort options: default count= number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query= number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call alter session set sql_trace = true call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Misses in library cache during execute: 1 Optimizer goal: CHOOSE Parsing user id: 111 BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END; call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 4 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total8 0.00 0.00 0 0 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 111 select /*+ INDEX(b)*/ distinct d.batch_number , d.document_number , d.entry_user_id , d.document_type_id , d.document_processed_date , b.batch_media_id, d.return_Method_Id from submitter_batch b , document d , ucc_master_amendment m where d.batch_number = b.batch_number and d.document_number = m.document_number and d.imaged = 0 and b.batch_media_id = 4 and d.document_status_id = 4 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch1 0.00 0.00 32 3193 0 0 --- -- -- -- -- -- -- total3 0.00 0.00 32 3193 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 111 Rows Row Source Operation --- --- 0 SORT UNIQUE 0 NESTED LOOPS 1NESTED LOOPS 147 TABLE ACCESS BY INDEX ROWID SUBMITTER_BATCH 148 INDEX RANGE SCAN (object id 10416) 2722 TABLE ACCESS BY INDEX ROWID DOCUMENT 2869 INDEX RANGE SCAN (object id 10385) 1INDEX UNIQUE SCAN
RE: STOP THE PRESS!!
Forget the economy. Its going to piss off some Americans. There are other stories about other sites being hit, Pentagon, State Department, etc. It will probably take sometime to sort everything out from the rumors. -Original Message- Sent: Tuesday, September 11, 2001 10:25 AM To: Multiple recipients of list ORACLE-L List, I am sure many of you Americans will have woken to this news, or maybe you got to work before it happened: I just saw on the news the World Trade Centre in NY, has just taken two direct hits from two separate aeroplanes!! Suspected to be a terrorist assault. Full video the lot!! They hit around the top of the buildings.. My heart goes out to those in the buildings.. What will THIS do for the American economy? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- 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: 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).
RE: OT
Title: OT Hey List I'm at work in downtown DC and its really weird. Most public building are evacuating. The subways are closed so the streets are very busy with cars and pedestrians. I could see the smoke from the Pentagon fire from my office and heard the sonic boom from the military fighter planes being scrambled. It's likebeing in a black and white science fiction movie. You know the one where the flying saucer hits the Washington Monument. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 11, 2001 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: OT I hope everyone on this list in the New York area is safe I am so scared. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117
RE: OT Breaking News
The Financial Markets are shut down indefinitely My friends at NASDAQ are being sent home... The WTC was a massive massive center for pricing for an enormous variety of financial instruments. This will be hard to recover from quickly. But the money is nothing compared to the hollow heavy feeling in my chest when i think of the towers going downall those people...it's more than anyone could have imagined... DC still a mess...i am going to walk out and survey again in a bit...had to come back inside to use a landline to reach my kids...cellphones near useless, network choked. -Original Message- Sent: Tuesday, September 11, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Off topic and serious for once; The World Trade Towers, the Pentagon, the USA Today building have all been hit by bombs. The first is quite major. There is word here in DC that they are evacuating people from around the White House. -- 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: 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).
RE: OT: STOP THE PRESS!!
Re. NY, a canadian news site posted this phone number if you have friends / relatives in NYC: FRIENDS/FAMILY IN NYC ? CALL 1-800-387-3124 The url for this site is www.bourque.com Pat. -- 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: STOP THE PRESS!!
Title: RE: STOP THE PRESS!! The State Department was NOT hit. There was just an update... The attack on the Pentagon, however, was quite serious. .there were 50,000 people in the World Trade Center. -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 11, 2001 11:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: STOP THE PRESS!! It's worse. The pentagon, the capital and the state department have also been attacked, according to the latest reports. The State department attack is still unconfirmed at this time. -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Subject: OT: STOP THE PRESS!! List, I am sure many of you Americans will have woken to this news, or maybe you got to work before it happened: I just saw on the news the World Trade Centre in NY, has just taken two direct hits from two separate aeroplanes!! Suspected to be a terrorist assault. Full video the lot!! They hit around the top of the buildings.. My heart goes out to those in the buildings.. What will THIS do for the American economy? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- 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).
