Re: ORA-24314 service handle not initialized
anyways...how i could look the log. is there any? Stephane Faroult wrote: paPIpapupapePO wrote: hi! every time i start Oracle9i this error appears in my screen. i dunno how to fix this. unfortunately, my first time to use Oracle. thanks in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Must be something wrong in shared libraries, etc. Check your OS version vs Oracle version, you may have to upgrade your OS. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Wilfredo Sellado, AbtikBoys Software Design Engineer NEC Telecom Software Phils., Inc. Asia Town I.T. Park Lahug, Cebu City 6000, Philippines Office : +63(32)233-9142 Residence: +63(32)412-8350 Mobile : +63(917)546-5867 Email: [EMAIL PROTECTED] I love you without knowing how, or when, or from where I love you simply without problems or pride I love you in this way because I don't know any other way of loving -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: paPIpapupapePO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Off topic - Oracle 9i on W2k - AMD Athlon XP or Intel Celeron
Hi, I know this is by far off topic, but if some one could help me with this I would be very grateful. I am running Oracle 9i on my home machine (Celeron 300 MHz) and it is pretty slow. I would like to upgrade either to Celeron 1.2 GHz or AMD XP 1400+ GHz. Apart from the (not negligible) cost differences I can not decide which solution would be better in respect to the Oracle 9i performance. Every one here at my company would like to persuade me to buy AMD, because it is MUCH faster than an Intel Celeron solution. Does this hold? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: FUNCTION.
Take a look at the INSTR and SUBSTR functions. hth connor --- Hamid Alavi [EMAIL PROTECTED] wrote: HI LIST, I need some help to write a function or procedure to insert into a table, the input of this function will be a comma delimiter string like (aaa,bbbc,d,f,ggg) and the the result would be 4 records inserted into the table.the number of input could be diffrent. tableA 1 aaa 2 bbbc 3 d 4 f 5 ggg Thanks in Advance, Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PL/SQL - procedure - APOLOGY
I apologize for my dirty post here, Roland. I have had a bad day. I'm sorry. Jan Pruner To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: PL/SQL - procedure Dear Roland, first try to use your brain than ask in this group. Yesterday I've posted email about Exceptions in Oracle (to catch an error) and the tip - don't use datatype DATE to store start/end time. OK, the second tip: PROCEDURE my_procedure ( ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Best way to move db from AIX to Solaris
Title: Best way to move db from AIX to Solaris Hi! We want to migrate an Oracle db (approx. 50 GB) from AIX to Sun Solaris. What would be the best way to achieve this? Export/Import I guess, right? This is 8.1.7 on Sun Solaris/AIX. Thanks, Helmut
RE: Off topic - Oracle 9i on W2k - AMD Athlon XP or Intel Celeron
Tamas, I suppose this also depends on what else you use your home machine for? I run 9i on a P4 1.3GHz, and it screams (apart from the fragmented shared pool that I keep on getting - that I need to sort out when I get the time , tips anyone? ;P). Why not put P4 in to the equation? I know it had some bad press when it first came out, but subsequent benchmarks have shown it to be a stable and well performing processor.. Do you do internet gaming? If so, then it has to be either the P4 or the AMD (which supposedly has DirectX built directly in to the processor).. Same goes with any graphic designing.. There you go.. My recommendation would be either P4 or AMD, and since you don't have P4 on the list (and assuming your not willing to put it on the list) then AMD. 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 -Original Message- Tamas Sent: 28 March 2002 08:38 To: Multiple recipients of list ORACLE-L Hi, I know this is by far off topic, but if some one could help me with this I would be very grateful. I am running Oracle 9i on my home machine (Celeron 300 MHz) and it is pretty slow. I would like to upgrade either to Celeron 1.2 GHz or AMD XP 1400+ GHz. Apart from the (not negligible) cost differences I can not decide which solution would be better in respect to the Oracle 9i performance. Every one here at my company would like to persuade me to buy AMD, because it is MUCH faster than an Intel Celeron solution. Does this hold? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Off topic - Oracle 9i on W2k - AMD Athlon XP or Intel Celeron
Mark, thanks for your comments. Actually I do Forms developement on the maschine and some surfing and email handling. I do no shoot out gaming or video editing :-). I did not look at P4 because it had some problems with Ora9i installs and every body kept saying that AMD is much cheeper. Now I checked out the prices and actually a P4 1.3 hardly differs from the AMD prices. What currently I can not decide and where I need help is if the frontside bus speed of AMD is 266MHz with DDR RAM, while the P4 front side buss is the half of it. I do not know if it matters or not? Tamas -Original Message- Sent: Thursday, March 28, 2002 11:18 To: Multiple recipients of list ORACLE-L Celeron Tamas, I suppose this also depends on what else you use your home machine for? I run 9i on a P4 1.3GHz, and it screams (apart from the fragmented shared pool that I keep on getting - that I need to sort out when I get the time , tips anyone? ;P). Why not put P4 in to the equation? I know it had some bad press when it first came out, but subsequent benchmarks have shown it to be a stable and well performing processor.. Do you do internet gaming? If so, then it has to be either the P4 or the AMD (which supposedly has DirectX built directly in to the processor).. Same goes with any graphic designing.. There you go.. My recommendation would be either P4 or AMD, and since you don't have P4 on the list (and assuming your not willing to put it on the list) then AMD. 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 -Original Message- Tamas Sent: 28 March 2002 08:38 To: Multiple recipients of list ORACLE-L Hi, I know this is by far off topic, but if some one could help me with this I would be very grateful. I am running Oracle 9i on my home machine (Celeron 300 MHz) and it is pretty slow. I would like to upgrade either to Celeron 1.2 GHz or AMD XP 1400+ GHz. Apart from the (not negligible) cost differences I can not decide which solution would be better in respect to the Oracle 9i performance. Every one here at my company would like to persuade me to buy AMD, because it is MUCH faster than an Intel Celeron solution. Does this hold? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Problem in 9i - Is this a bug?
Title: Problem in 9i - Is this a bug? Hi, While testing 9i, I have come across a problem while testing to resize the size of Shared Pool Size dynamically, As soon as I give command ALTER SYSTEM SET SHARED_POOL_SIZE=size in bytes The processor goes to 100% usage, and keeps on 100%, until I kill the ORACLE.EXE process. It happened a number of times, and I am still not able to resize Shared Pool Size dynamically, though I have tested to resize the DB_BUFFER_CACHE (new name of DB_BLOCK_BUFFERS) successfully, Have any body else came across the same problem? Its Oracle 9i Enterprise edition 9.0.1.1.1 on Windows 2000 Advance Server, SP 2. Arslan Zaheer Dar [EMAIL PROTECTED] Database Administrator Shaukat Khanum Memorial Cancer Hospital Research Centre www.shaukatkhanum.org.pk + 92 (042) 5180725 - 34 Ext: 2323
RE: Off topic - Oracle 9i on W2k - AMD Athlon XP or Intel Celeron
Tamas The problem with the install is easily fixed.. Copy the install CD images to your hard drive, and replace each instance of symcjit.dll (I think there are around 3) with this one: http://www.cool-tools.co.uk/Products/Downloads/symcjit.dll I don't know where you got your info about the P4 Bus speed, but you are mistaken, mine runs at 400Mhz(!) with 512Mb RDRAM.. Check out: http://www.geek.com/procspec/intel/p7consumer.htm And compare this to the AMD K7 Thunderbird: http://www.geek.com/procspec/amd/k7ultra.htm I'm sure you'll find the P4 more appealing ;P HTH Mark -Original Message- Tamas Sent: 28 March 2002 10:43 To: Multiple recipients of list ORACLE-L Celeron Mark, thanks for your comments. Actually I do Forms developement on the maschine and some surfing and email handling. I do no shoot out gaming or video editing :-). I did not look at P4 because it had some problems with Ora9i installs and every body kept saying that AMD is much cheeper. Now I checked out the prices and actually a P4 1.3 hardly differs from the AMD prices. What currently I can not decide and where I need help is if the frontside bus speed of AMD is 266MHz with DDR RAM, while the P4 front side buss is the half of it. I do not know if it matters or not? Tamas -Original Message- Sent: Thursday, March 28, 2002 11:18 To: Multiple recipients of list ORACLE-L Celeron Tamas, I suppose this also depends on what else you use your home machine for? I run 9i on a P4 1.3GHz, and it screams (apart from the fragmented shared pool that I keep on getting - that I need to sort out when I get the time , tips anyone? ;P). Why not put P4 in to the equation? I know it had some bad press when it first came out, but subsequent benchmarks have shown it to be a stable and well performing processor.. Do you do internet gaming? If so, then it has to be either the P4 or the AMD (which supposedly has DirectX built directly in to the processor).. Same goes with any graphic designing.. There you go.. My recommendation would be either P4 or AMD, and since you don't have P4 on the list (and assuming your not willing to put it on the list) then AMD. 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 -Original Message- Tamas Sent: 28 March 2002 08:38 To: Multiple recipients of list ORACLE-L Hi, I know this is by far off topic, but if some one could help me with this I would be very grateful. I am running Oracle 9i on my home machine (Celeron 300 MHz) and it is pretty slow. I would like to upgrade either to Celeron 1.2 GHz or AMD XP 1400+ GHz. Apart from the (not negligible) cost differences I can not decide which solution would be better in respect to the Oracle 9i performance. Every one here at my company would like to persuade me to buy AMD, because it is MUCH faster than an Intel Celeron solution. Does this hold? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of
RE: Oracle CPU Licensing
One thing to be wary of is if you want Standard Edition. Typically this can only be used on machines up to 4 CPUs. However, say you want an expandable server that can take 6 CPUs max, but initially you only have 2 CPUs installed, because the server is CAPABLE of having 6 CPUs, you can only use Enterprise edition. Steve Parker Technical Consultant LIS -- E Mail: [EMAIL PROTECTED] -- [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 27/03/2002 22:10 Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle CPU Licensing Dennis, This doesn't sound right. Oracle will not try to extort, er, charge money for CPU's that aren't installed. Merely having the slots doesn't count. Having CPU's installed but switched off but installed is not a new concept, having been around in the mainframe world for some time. I wouldn't think Oracle would try to make you pay for CPU's you can't use. Best call your Oracle rep for a definitive answer. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/27/02 07:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle CPU Licensing An analyst recently made a statement that under CPU licensing Oracle is charging for unused CPU slots. I found this very surprising. I can see two possible interpretations: 1. If the system is capable of holding 8 CPUs, but I only have 4 CPUs installed, Oracle would charge me for 8 CPUs. I find this unacceptable. For one thing, in some machines, a slot can contain either a CPU or memory. 2. Some vendors (HP I believe) have offered an upgrade on demand configuration, where the system is delivered with more CPUs than the customer purchased. If the customer wants additional processing power, the vendor can switch on the additional CPUs, saving a visit by a customer engineer. Another possibility would be if I had a way to limit the number of CPUs that could execute Oracle. This doesn't sound so bad, since it might be easy to increase the number of CPUs without paying additional fees to Oracle. Has anyone heard of this type of license interpretation by Oracle? Our license renewal is coming up soon and we would prefer to not be blindsided. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: HOW OLE
Do you mean OLE: Organizational Leadership for Executives ??? JP On Wed 27. March 2002 22:25, you wrote: Hi How we can know whether OLE is installed in database? Thx -Seema _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Trigger question
Hallo, anyone who can please helpme with a trigger script that does the following: I want this script to run when I have updated a field in a table. update test set namn = upper(substr(namn,1,1) || substr(namn),2) I want this trigger to fire only for the selected record(row), that is going to be updated. Please help me with this, it might seem simple but I cant get it right. 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).
Names Servers synchronising
Hi All, I have set up 4 names servers, all using the same region database. Seems to work OK, but I have a few questions How can I check/make sure that there will be some sort of load balancing? How can I make the 4 names servers synchronise with the region database say every 6 hours? (I did check the Fine Manual and it mentions that the names servers will poll the database every now and then to see if there are changes but it does not seem to work automatically here) 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: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle CPU Licensing
Dennis, I remember something from the past about just such a Deal . You notified Oracle about the CPU's you had installed and then Oracle would use a monitoring tool to see how many CPU's you were using and they would charge you for the actual number of CPU's that you activated and for the time frame they were acticated. That way you could build a box that would run on 1 CPU for normal load and then ramp up for the heavy end of year processing. You would only be chagred for the extra CPU's when you needed them. I don't know if this policy is still in effect or not. ROR mª¿ªm [EMAIL PROTECTED] 03/27/02 05:10PM Dennis, This doesn't sound right. Oracle will not try to extort, er, charge money for CPU's that aren't installed. Merely having the slots doesn't count. Having CPU's installed but switched off but installed is not a new concept, having been around in the mainframe world for some time. I wouldn't think Oracle would try to make you pay for CPU's you can't use. Best call your Oracle rep for a definitive answer. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/27/02 07:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle CPU Licensing An analyst recently made a statement that under CPU licensing Oracle is charging for unused CPU slots. I found this very surprising. I can see two possible interpretations: 1. If the system is capable of holding 8 CPUs, but I only have 4 CPUs installed, Oracle would charge me for 8 CPUs. I find this unacceptable. For one thing, in some machines, a slot can contain either a CPU or memory. 2. Some vendors (HP I believe) have offered an upgrade on demand configuration, where the system is delivered with more CPUs than the customer purchased. If the customer wants additional processing power, the vendor can switch on the additional CPUs, saving a visit by a customer engineer. Another possibility would be if I had a way to limit the number of CPUs that could execute Oracle. This doesn't sound so bad, since it might be easy to increase the number of CPUs without paying additional fees to Oracle. Has anyone heard of this type of license interpretation by Oracle? Our license renewal is coming up soon and we would prefer to not be blindsided. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORACLE REVEALS AMBITIOUS HOSTING PLANS
List, More info on the proposal for Oracle to handle your APPS database. And the cost is3 - 5 % above licensing fee?? Check it out at: http://db.ittoolbox.com/news/nr.asp?i=67582 ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Trigger question
Title: RE: Trigger question This should work: CREATE TRIGGER BEFORE_ROWUPD_ON_TEST BEFORE UPDATE OF namn ON test REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN :NEW.namn := UPPER(SUBSTR(:OLD.namn, 1, 1) || SUBSTR(:OLD.namn), 2); EXCEPTION WHEN OTHERS THEN raise_application_error(-2, 'ERROR IN TRIGGER BEFORE_ROWUPD_ON_TEST: ' || SQLERRM); END; / Med vänliga hälsningar/ Kind regards -- Veriba AB Per Berghäll Brigadgatan 10 581 31 Linköping Tel: +46 (0)13-362600 Fax: +46 (0)13-362625 mailto:[EMAIL PROTECTED] http://www.veriba.se -- -- Från: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] Svara till: [EMAIL PROTECTED] Skickat: Thursday, March 28, 2002 12:33 PM Till: Multiple recipients of list ORACLE-L Angående: Trigger question Hallo, anyone who can please helpme with a trigger script that does the following: I want this script to run when I have updated a field in a table. update test set namn = upper(substr(namn,1,1) || substr(namn),2) I want this trigger to fire only for the selected record(row), that is going to be updated. Please help me with this, it might seem simple but I cant get it right. 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).
Table Insert Lock!!
Hi I have to revoke insert from a table where I am the owner of the Schema. is it possible. if so? how?. E.g. Owner a have a table t1 after inserting 1 row owner wish to revoke insert for the table t1. because t1 should not have more than one row. How to incorporate this. it is 8.1.7 on sun Solaris 5.7 Regards Ayyappan.S This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. Visit us @ www.ssiworldwide.com -- 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: FUNCTION.
Hamid, here is a simple proc to do what you want: CREATE OR REPLACE PROCEDURE Str_Insert ( p_recipient IN VARCHAR2 ) IS l_recipientVARCHAR2(200); start_indx NUMBER := 1; str_length NUMBER; BEGIN start_indx := 1; str_length := LENGTH(p_recipient) + 1; LOOP l_recipient := RTRIM(SUBSTR(p_recipient,start_indx, INSTR(p_recipient||',',',',start_indx)-start_indx+1),','); -- your insert statement would go here start_indx := INSTR(p_recipient||',',',',start_indx) + 1; EXIT WHEN start_indx = str_length; END LOOP; END; / Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, March 27, 2002 5:18 PM To: Multiple recipients of list ORACLE-L HI LIST, I need some help to write a function or procedure to insert into a table, the input of this function will be a comma delimiter string like (aaa,bbbc,d,f,ggg) and the the result would be 4 records inserted into the table.the number of input could be diffrent. tableA 1 aaa 2 bbbc 3 d 4 f 5 ggg Thanks in Advance, Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: hotbackup script for NT OR WIN2000
Brian, I probably should have been, but as Lisa mentions, you have to understand what you are doing and simply running another person's scripts isn't going to help him. I'll try and be a bit more constructive next time! Saul -Original Message- Sent: Wednesday, March 27, 2002 6:09 PM To: Multiple recipients of list ORACLE-L Ya know, I enjoy a good RTFM as much as the next guy, when done properly and for the right reasons. But the number of them that I have seen in the last few weeks is just not justified. Can we all be just a bit more constructive ... Hm Brian P. MacLean Oracle DBA, OCP8i Solomon, Saul M. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ssolomon@ppg. cc: com Subject: RE: hotbackup script for NT OR WIN2000 Sent by: [EMAIL PROTECTED] om 03/27/02 01:33 PM Please respond to ORACLE-L c:\winnt\system32\rtfm perhaps? -Original Message- Sent: Wednesday, March 27, 2002 1:08 PM To: Multiple recipients of list ORACLE-L Hi Can some one send me hotback scripts for NT OR WIN'2000? With regards Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema 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: Solomon, Saul M. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ:
Re: Table Insert Lock!!
Create your record, then change the tablespace to be read-only. OR Don't grant permissions to insert/update/delete the table to anyone. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 7:43 AM Hi I have to revoke insert from a table where I am the owner of the Schema. is it possible. if so? how?. E.g. Owner a have a table t1 after inserting 1 row owner wish to revoke insert for the table t1. because t1 should not have more than one row. How to incorporate this. it is 8.1.7 on sun Solaris 5.7 Regards Ayyappan.S This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. Visit us @ www.ssiworldwide.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: client/desktop management from network / was: Re: Net 8 insta
Eric: Thanks for your reply. We use Dell desktops here and have a state contract with Dell. I'll have our Lan people check with Dell. Have a good one. Ron -Original Message- Sent: Wednesday, March 27, 2002 3:23 PM To: Multiple recipients of list ORACLE-L installation on a server consider an alternative (maybe for future): use the network to standardize desktop settings, but not to store/run the executable. there is software that will vacuum custom client/desktop settings from the network side, and allow you to deploy those settings (elsewhere). sort of like Ghost on steroids. (this is being studied here to rapidly re/deploy OS images and standard loads in university computer labs.) eg, here is a product that our Dell rep brought in for a demo: http://www.altiris.com/ (I think at an educational discount, they were talkin' something like $60,000 for 2,000 nodes?) note: Dell, IBM (and probably Compaq/etc.) have similar capabilities, in the case of IBM, it is (suppposedly) bundled with all Netvista desktops, but watch out, in many instances the hardware-vendor desktop management stuff only does limited OS/BIOS type stuff, not applications. (eg, http://www.pc.ibm.com/us/pc/um/index.html ) due to the design/setup overhead involved, it is probably not worth setting up such stuff *just* for the Oracle client, but maybe you can get your LAN people to look into it long term for general use, and then use it for Oracle client stuff also? you would probably want to have WoL capable boxes. regards, ep ORACLE-L Digest -- Volume 2002, Number 086 -- From: Rodd Holman [EMAIL PROTECTED] Date: 26 Mar 2002 13:18:12 -0600 Subject: Re: Net 8 installation on a server rather than client question I did this for a while with the 7.3 client. Performance was abysmal. My network admin also was on my case about network traffic. I don't know if the Net8 client would be better or not. Pointing TNS_ADMIN to a network drive is great, but unless there have been significant changes in the client, I would be more inclined to have it local. What I did for the network install was to set up a machine installing the client to a network drive. Exported the registry key for Oracle. Copied the Windows system files to a network location. Added that location to the PATH variable. It was cumbersome, but it worked. On the other machines I imported the registry file, added the PATH variable, and TNS_ADMIN variable. The problem with all this is when you upgrade the client, you have to upgrad all the user registries with the new keys and structure changes that Oracle makes. You may as well install each machine. ... On Tue, 2002-03-26 at 09:18, Ron Cetnar wrote: Question to the list. Is there was way to install Net 8 on a nt server and have client pc's execute the Net 8 from the server instead of loading Net 8 on the client's pc. To avoid installation of Net 8 on the clients. I already have the tnsnames.ora file on the server and with a bat file that updates the registry on the client to point to the server to get the tnsnames file. ... -- 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: Ron Cetnar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: FUNCTION.
One approach is to use object types. There is an item on my web-site that I wrote in early 8.0 days. Use the CAST() operator to convert an input string into an object table of values, then use the TABLE() operator (once the THE()) operator to insert it into your table. Check under: Miscellaneous - In Lists Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases | |-Original Message- |Sent: Wednesday, March 27, 2002 5:18 PM |To: Multiple recipients of list ORACLE-L | | |HI LIST, | |I need some help to write a function or procedure to insert into a table, |the input of this function will be a comma delimiter string like |(aaa,bbbc,d,f,ggg) and the the result would be 4 records inserted into the |table.the number of input could be diffrent. | |tableA | |1 aaa |2 bbbc |3 d |4 f |5 ggg | |Thanks in Advance, | | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Trigger question
Oh my! (Is that gentle enough Jared?)Roland,I admire your ability to participate in this forum using the English language, I certainly could not pose questions within a Swedish discussion group. Since you have the ability to use the language, might I suggest once again you subscribe at http://otn.oracle.com (do they have a Swedish version as well?), then type the word 'trigger' into the search box. Triggers are a wonderful, varied construct and all their glory (including samples of just the type you wish to create) will be revealed.Just a thought. No offense.David A. BarbourOracle DBA, OCPAISD512-414-1002[EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]03/28/2002 03:33 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: bcc: Subject: Trigger question Hallo,anyone who can please helpme with a trigger script that does the following:I want this script to run when I have updated a field in a table.update test set namn = upper(substr(namn,1,1) || substr(namn),2)I want this trigger to fire only for the selected record(row), that is going to be updated. Please help me with this, it might seem simple but I cant get it right.Thanks in advanceRoland 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-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Table Insert Lock!!
You mention a lock? Are you getting an error message on attempted insert? Is the transaction committed? How about issuing the command 'rollback' ?David A. BarbourOracle DBA, OCPAISD512-414-1002[EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]03/28/2002 04:43 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: bcc: Subject: Table Insert Lock!! HiI have to revoke insert from a table where I am the owner of the Schema. isit possible. if so? how?.E.g.Owner a have a table t1after inserting 1 rowowner wish to revoke insert for the table t1. because t1 should not havemore than one row.How to incorporate this. it is 8.1.7 on sun Solaris 5.7RegardsAyyappan.SThis communication contains information, which is confidential and may alsobe privileged. It is for the exclusive use of the intended recipient(s). Ifyou are not the intended recipient(s), please note that any distribution,printing, copying or use of this communication or the information in it isstrictly prohibited. If you have received this communication in error,please notify the sender immediately and then destroy any copies of it.Visit us @www.ssiworldwide.com--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-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trigger question
Roland (and those, who thinks, that RTFM is not such a good advice), When you are saying, that you "can't get the trigger right", please be more specific: post trigger code, that you wrote, post errors, that you are getting, or if there is no errors, tell, what your trigger does not do, that you want it to do. If you don't post all these "little" things, you will be getting "RTFM" advice. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, March 28, 2002 8:19 AM Subject: Re: Trigger question Oh my! (Is that gentle enough Jared?) Roland, I admire your ability to participate in this forum using the English language, I certainly could not pose questions within a Swedish discussion group. Since you have the ability to use the language, might I suggest once again you subscribe at http://otn.oracle.com (do they have a Swedish version as well?), then type the word 'trigger' into the search box. Triggers are a wonderful, varied construct and all their glory (including samples of just the type you wish to create) will be revealed. Just a thought. No offense. David A. BarbourOracle DBA, OCPAISD512-414-1002 [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]03/28/2002 03:33 AM PSTPlease respond to ORACLE-LTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]cc: bcc: Subject: Trigger question Hallo,anyone who can please helpme with a trigger script that does the following:I want this script to run when I have updated a field in a table.update test set namn = upper(substr(namn,1,1) || substr(namn),2)I want this trigger to fire only for the selected record(row), that is going to be updated. Please help me with this, it might seem simple but I cant get it right.Thanks in advanceRoland 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-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Problem in 9i - Is this a bug?
Title: Problem in 9i - Is this a bug? Did you talk to Oracle support about this issue? Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Arslan Dar To: Multiple recipients of list ORACLE-L Sent: Thursday, March 28, 2002 6:03 AM Subject: Problem in 9i - Is this a bug? Hi, While testing 9i, I have come across a problem while testing to resize the size of Shared Pool Size dynamically, As soon as I give command ALTER SYSTEM SET SHARED_POOL_SIZE=size in bytes The processor goes to 100% usage, and keeps on 100%, until I kill the ORACLE.EXE process. It happened a number of times, and I am still not able to resize Shared Pool Size dynamically, though I have tested to resize the DB_BUFFER_CACHE (new name of DB_BLOCK_BUFFERS) successfully, Have any body else came across the same problem? Its Oracle 9i Enterprise edition 9.0.1.1.1 on Windows 2000 Advance Server, SP 2. Arslan Zaheer Dar [EMAIL PROTECTED] Database Administrator Shaukat Khanum Memorial Cancer Hospital Research Centre www.shaukatkhanum.org.pk + 92 (042) 5180725 - 34 Ext: 2323
Re: Long-running SQL
Stephane, Thanks for your reply. I am going to check into setting the nulls with the application owner to see if that is an acceptable solution. I am unable to create a function-based index as this is a version 8.0.4 database. Thanks, Cherie Stephane Faroult To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] sfaroult@orio cc: le.com Subject: Re: Long-running SQL Sent by: [EMAIL PROTECTED] om 03/27/02 03:03 PM Please respond to ORACLE-L [EMAIL PROTECTED] wrote: We have a statement that I feel takes too long to run in a nightly data load. The table it runs against has 386,000 records. It runs for about 10 seconds on average. We're only loading about 50,000 records a night but this statement is running during the majority of the 9-hour load time. This is causing the load to run longer than our allowable window and causing me untold headaches. If anyone has any suggestions to make this run faster, I'd be greatly appreciative. The columns in the where statement are all part of an index. However, the functions on the columns add additional execution time and complexity. This is an 8.0.4 database so I can not make this a function-based index. I put this in a couple of SQL tuning tools and came up with no valid alternatives. I can't help thinking that the statement could be rewritten into a couple of statements so that it would be more efficient. However, I'm not skilled enough with SQL to do it. Perhaps someone else is. Here's the code. SELECT /*+ INDEX(EXP_COST_CENTER_DIM EXP_COST_CENTER_DIM_IDX1) + */ EXP_COST_CENTER_KEY FROM EXP_COST_CENTER_DIM WHERE ACCOUNT_NUMBER = :b1 AND NVL(ORG_LEVEL_1_VALUE,'NONE') = NVL(:b2,'NONE') AND NVL(ORG_LEVEL_2_VALUE,'NONE') = NVL(:b3,'NONE') AND NVL(ORG_LEVEL_3_VALUE,'NONE') = NVL(:b4,'NONE') AND NVL(ORG_LEVEL_4_VALUE,'NONE') = NVL(:b5,'NONE') AND NVL(ORG_LEVEL_5_VALUE,'NONE') = NVL(:b6,'NONE') AND NVL(ORG_LEVEL_6_VALUE,'NONE') = NVL(:b7,'NONE') AND NVL(ORG_LEVEL_7_VALUE,'NONE') = NVL(:b8,'NONE') AND NVL(ORG_LEVEL_8_VALUE, 'NONE')= NVL(:b9,'NONE') AND ROWNUM = 1 SQL desc exp_cost_center_dim NameNull?Type --- EXP_COST_CENTER_KEY NOT NULL NUMBER(7) ACCOUNT_NUMBER NOT NULL NUMBER(9) BATCH_WINDOW_DATE_KEY NOT NULL NUMBER(5) ORG_LEVEL_1_VALUEVARCHAR2(20) ORG_LEVEL_2_VALUEVARCHAR2(20) ORG_LEVEL_3_VALUEVARCHAR2(20) ORG_LEVEL_4_VALUEVARCHAR2(20) ORG_LEVEL_5_VALUEVARCHAR2(20) ORG_LEVEL_6_VALUEVARCHAR2(20) ORG_LEVEL_7_VALUEVARCHAR2(20) ORG_LEVEL_8_VALUEVARCHAR2(20) DATA_SOURCE_MOD_DATETIMENOT NULL DATE DATA_WAREHOUSE_MOD_DATETIME NOT NULL DATE DATA_MART_MOD_DATETIME NOT NULL DATE SQL select column_name from dba_ind_columns where index_name ='EXP_COST_CENTER_D IM_IDX1'; COLUMN_NAME ACCOUNT_NUMBER ORG_LEVEL_1_VALUE ORG_LEVEL_2_VALUE ORG_LEVEL_3_VALUE
BDE 5.0.1. and Oracle 8.1.7.3.0
Does anyone know if Borland Database Engine 5.0.1. is compatible with Oracle 8.1.7.3.0? I am trying to contact Borland people, but one of their links was dead and I couldn't find a compatibility matrix on their Web site. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) 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]
Oracle PL/SQL Developer Needed on Long Island, New York
Long Island New York company needs a solid Oracle PL/SQL Developer to join its' I.T. team. PLEASE DO NOT send your resume for this position UNLESS you already live on Long Island (or within a reasonable commute) and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: Looking for a team oriented ORACLE PL/SQL DEVELOPER to design and support various Internet applications projects. Responsibilities include developing back-end components in contribution to the overall applications architecture. Expected to participate in the full development life cycle for projects. Requirements: -Must have 3+ years experience developing client server applications in ORACLE PL/SQL. Knowledge of ORACLE packages, stored proceures, triggers, and database design a must. -Will also need to be a U.S. citizen or permanent resident. The base salary range is 75-85K..depends on experience. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Long Island/PL/SQL/Andrea (*Local area candidaph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Problem in 9i - Is this a bug?
Hi, 1) Solaris 8 2) Oracle apps server 11.5.4 During installation I am getting response file error. Can anyone give me leads on this? shreepad -- 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: Best way to move db from AIX to Solaris
Helmut - There are a couple of methods that might suit your needs: 1) Because these platforms are not compatible at the binary level, you can't clone the database by copying datafiles. 2) Export/import will work. Look for FAQs on the Internet for tips on maximizing your speed. If these machines have multiple CPUs, you may want to run multiple export and import sessions. Be sure to turn archiving off on the target machine. 3) Use a database link to send data over SQL*Net. I have found this to be faster than Import because you are going database to database. Look at the SQL*Net COPY command. You didn't say how long you can have the database down, but I would recommend that you test the various methods until you are confident you have the method that works the best for you and can complete the task within the available time. And tell the users it will be down longer than you think it will. Users don't get angry if you finish early. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 28, 2002 4:03 AM To: Multiple recipients of list ORACLE-L Hi! We want to migrate an Oracle db (approx. 50 GB) from AIX to Sun Solaris. What would be the best way to achieve this? Export/Import I guess, right? This is 8.1.7 on Sun Solaris/AIX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Help in unix script
Greetings all, I need to do the following unix top -b -U norad PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 12733 norad 1 602 3936K 3392K run 0:05 7.21% dbganlz 12747 norad 4 522 13M 10M sleep 0:05 4.20% dbgora 12721 norad 1 532 3160K 2584K sleep 0:00 0.12% dbgsam 12726 norad 1 522 3184K 2416K sleep 0:00 0.02% dbgalert 12740 norad 1 532 2992K 2128K sleep 0:00 0.02% dbgrepos 12594 norad 1 590 3200K 2544K sleep 0:00 0.01% dbgsam 12606 norad 1 590 4696K 4160K sleep 0:11 0.00% dbganlz 12620 norad 4 590 42M 13M sleep 0:06 0.00% dbgora 12599 norad 1 580 3216K 2400K sleep 0:00 0.00% dbgalert 12613 norad 1 590 3016K 2112K sleep 0:00 0.00% dbgrepos I have to check the last character of SIZE column. If the size is in M(megabyte) then check if the value is 40 then send an e-mail with the COMMAND name and the size. Something like dbgora has a size of 42M I was trying the following script. But I am not sure how to get the last character of SIZE column from the above output and compare with 'M' and then compare with the value. top -b -U norad | grep norad | awk '{ print $6, $11 }' | \ while read SIZE COMMAND do echo Command : $COMMAND Size : $SIZE done Any suggestions will be appreciated. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle PL/SQL Developer Needed on Long Island, New York
The thermometer on my garage here in Hugo, MN reads 46 deg. F. and party cloudy. We had a touch of rain early this morning and there is still is a little snow left on the ground. Ken Janusz, CPIM Hugo, MN 55038 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 10:13 AM Never again Long Island! Wonder how the 495 parking lot is these days? Just love this sunshine, pipe down Lisa, its still in the 40's in MN :) [EMAIL PROTECTED] 03/28/02 10:13AM Long Island New York company needs a solid Oracle PL/SQL Developer to join its' I.T. team. PLEASE DO NOT send your resume for this position UNLESS you already live on Long Island (or within a reasonable commute) and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: Looking for a team oriented ORACLE PL/SQL DEVELOPER to design and support various Internet applications projects. Responsibilities include developing back-end components in contribution to the overall applications architecture. Expected to participate in the full development life cycle for projects. Requirements: -Must have 3+ years experience developing client server applications in ORACLE PL/SQL. Knowledge of ORACLE packages, stored proceures, triggers, and database design a must. -Will also need to be a U.S. citizen or permanent resident. The base salary range is 75-85K..depends on experience. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Long Island/PL/SQL/Andrea (*Local area candidaph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: spfile mystery on 9i
Hi! Joan Hsieh writes: If parameters cannot modified online, then you can added into your normal init.ora file and recreate spfile again. This is what I did today. Putting session_cached_cursors into the init.ora and recreation seems to work, since the parameter shows up in v$spparameter. It doesn't make sense to me, that initial values can be defined for some parameters this way and changing them later requires the init.ora file again. Did you try create pfile='path/init.ora' from spfile; I tried this but it failed with ORA-7393 as I wrote. Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Moeding INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to duplicate production database onto development box
Hi New Bee, Duplicatiing Oracle Applications has become successively complicated with every release. If you are on 11i and want to use a supported method, then use the 'adclone' method - details on MetaLink. Other unsupported methods exist out there - just search the web for 'clone 11i' and you will come across a ton of them. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to duplicate production database onto development box Hi Waleed, I am not sure about other applications but for Oracle HRMS Applications, I am afraid it's so. For example, refer to metalink Note 117012.1 Viewing Reports in 11I Applications ADI 7.0. In this article, you will realize that the machine name is hardcode in the column FND_CONCURRENT_QUEUES.target_node. Regds, New Bee -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Subject:RE: How to duplicate production database onto development box This will be ridiculous to hardcode this kind of information. So if my system crashed and I had to import a full export into a new machine, it's not going to work?!! I do not believe this could be true. Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -Original Message- Sent: Wednesday, March 27, 2002 7:43 PM To: Multiple recipients of list ORACLE-L Hi, Does anyone know whether I could duplicate the Oracle HRMS Applications using the same methods as described ? I understand that some of the Oracle Applications tables hardcode the server name etc. Has anyone done it before ? I need to migrate my production Oracle HRMS Apps database to a more powerful machine. TIA Regds, New Bee -Original Message- From: Marc Cure [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 4:16 AM To: Multiple recipients of list ORACLE-L Subject:RE: How to duplicate production database onto development box Is there any need to create a standby database in this case? My procedure for copying production to development is: 1. alter database backup controlfile to trace; (in production) 2. Restore a production backup (either hot or cold) to the development server 3. Update database name and filenames in the controlfile script from step 1, as required 4. Run script from step 3 on development server to create new controlfiles 5. Recover new development database up to desired point in time using archived redo from production 6. Open the new development database with resetlogs This approach allows me to rename the database and the datafiles (if the datafiles need to be placed differently on the development server than in production, for example) in one step, rather than manually renaming 50+ datafiles in a standby database, and then recovering, activating, and renaming that database. Marc Cure Oracle DBA, OCP -Original Message- Sent: Tuesday, March 26, 2002 11:59 AM To: Multiple recipients of list ORACLE-L
Re: Help in unix script
Oops, forgot the mail part. change: echo Greater than ${MAX} - ${SIZE}:${COMMAND} to: echo Process ${COMMAND} is above the ${MAX}M max size, currently ${SIZE} | mailx -s bad boy [EMAIL PROTECTED] Brian P MacLean To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] 03/28/02 11:05 Subject: Re: Help in unix script(Document link: Brian P MacLean) AM #!/bin/ksh MAX=40 top -b -U norad | grep norad | awk '{ print $6, $11 }' | \ while read SIZE COMMAND do #echo working with ${SIZE}:${COMMAND}#DEBUG WORK=${SIZE#*M} #echo 1-${WORK} #DEBUG if [[ ${#WORK} -eq 0 ]] then WORK=${SIZE%%M} #echo 2-${WORK} #DEBUG if [[ ${WORK} -ge ${MAX} ]] then echo Greater than ${MAX} - ${SIZE}:${COMMAND} fi fi done Brian P. MacLean Oracle DBA, OCP8i Mandal, Ashoke ashoke.k.mandal@medt To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ronic.com cc: Sent by:Subject: Help in unix script [EMAIL PROTECTED] 03/28/02 09:28 AM Please respond to ORACLE-L Greetings all, I need to do the following unix top -b -U norad PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 12733 norad 1 602 3936K 3392K run 0:05 7.21% dbganlz 12747 norad 4 522 13M 10M sleep 0:05 4.20% dbgora 12721 norad 1 532 3160K 2584K sleep 0:00 0.12% dbgsam 12726 norad 1 522 3184K 2416K sleep 0:00 0.02% dbgalert 12740 norad 1 532 2992K 2128K sleep 0:00 0.02% dbgrepos 12594 norad 1 590 3200K 2544K sleep 0:00 0.01% dbgsam 12606 norad 1 590 4696K 4160K sleep 0:11 0.00% dbganlz 12620 norad 4 590 42M 13M sleep 0:06 0.00% dbgora 12599 norad 1 580 3216K 2400K sleep 0:00 0.00% dbgalert 12613 norad 1 590 3016K 2112K sleep 0:00 0.00% dbgrepos I have to check the last character of SIZE column. If the size is in M(megabyte) then check if the value is 40 then send an e-mail with the COMMAND name and the size. Something like dbgora has a size of 42M I was trying the following script. But I am not sure how to get the last character of SIZE column from the above output and compare with 'M' and then compare with the value. top -b -U norad | grep norad | awk '{ print $6, $11 }' | \ while read SIZE COMMAND do echo Command : $COMMAND Size : $SIZE done Any suggestions will be appreciated. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
Re: Oracle PL/SQL Developer Needed on Long Island, New York
and I love NY, although I'd prefer Manhattan --- Gene Sais [EMAIL PROTECTED] wrote: Never again Long Island! Wonder how the 495 parking lot is these days? Just love this sunshine, pipe down Lisa, its still in the 40's in MN :) [EMAIL PROTECTED] 03/28/02 10:13AM Long Island New York company needs a solid Oracle PL/SQL Developer to join its' I.T. team. PLEASE DO NOT send your resume for this position UNLESS you already live on Long Island (or within a reasonable commute) and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: Looking for a team oriented ORACLE PL/SQL DEVELOPER to design and support various Internet applications projects. Responsibilities include developing back-end components in contribution to the overall applications architecture. Expected to participate in the full development life cycle for projects. Requirements: -Must have 3+ years experience developing client server applications in ORACLE PL/SQL. Knowledge of ORACLE packages, stored proceures, triggers, and database design a must. -Will also need to be a U.S. citizen or permanent resident. The base salary range is 75-85K..depends on experience. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Long Island/PL/SQL/Andrea (*Local area candidaph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Help in unix script
Hi Ashoke, I see that you are using NORAD (I am the resident NORAD sales critter ;P). Can't help you much on the script help, but one thing I can say: Have you looked at the IAS agent of NORAD (the system monitoring agent)? This will be able to do all that you want.. Under the standard rules (just the same as you see when using NORAD against Oracle) there is an IAS rule called IAS_PROCESSES_KMEM_USAGE (Interval KMem usage exceeds value) that will flag exactly what you want. Then all you have to do is generate an event handler for that rule that will email you the results.. If you want it to just run against the NORAD processes, copy the rule, and edit the where clause to also include and command like dbg%.. You could also use the Process Monitor built in to the IAS agent, to group the DBGXXX agents together to monitor the NORAD program as a group.. What version are you running, and what O/S are you running this against? You may want to get in touch with your local supplier (whoever that is) to talk about IAS. Alternatively, get in touch with me back channel ([EMAIL PROTECTED]) and I'll see if I can help you out (we are Bradmark's No.1 distributor worldwide..). I won't be able to supply the agents (that's best left to your local supplier), but I can point you in the right direction.. HTH 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 -Original Message- Ashoke Sent: 28 March 2002 16:28 To: Multiple recipients of list ORACLE-L Greetings all, I need to do the following unix top -b -U norad PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 12733 norad 1 602 3936K 3392K run 0:05 7.21% dbganlz 12747 norad 4 522 13M 10M sleep 0:05 4.20% dbgora 12721 norad 1 532 3160K 2584K sleep 0:00 0.12% dbgsam 12726 norad 1 522 3184K 2416K sleep 0:00 0.02% dbgalert 12740 norad 1 532 2992K 2128K sleep 0:00 0.02% dbgrepos 12594 norad 1 590 3200K 2544K sleep 0:00 0.01% dbgsam 12606 norad 1 590 4696K 4160K sleep 0:11 0.00% dbganlz 12620 norad 4 590 42M 13M sleep 0:06 0.00% dbgora 12599 norad 1 580 3216K 2400K sleep 0:00 0.00% dbgalert 12613 norad 1 590 3016K 2112K sleep 0:00 0.00% dbgrepos I have to check the last character of SIZE column. If the size is in M(megabyte) then check if the value is 40 then send an e-mail with the COMMAND name and the size. Something like dbgora has a size of 42M I was trying the following script. But I am not sure how to get the last character of SIZE column from the above output and compare with 'M' and then compare with the value. top -b -U norad | grep norad | awk '{ print $6, $11 }' | \ while read SIZE COMMAND do echo Command : $COMMAND Size : $SIZE done Any suggestions will be appreciated. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Help in unix script
#!/bin/ksh MAX=40 top -b -U norad | grep norad | awk '{ print $6, $11 }' | \ while read SIZE COMMAND do #echo working with ${SIZE}:${COMMAND}#DEBUG WORK=${SIZE#*M} #echo 1-${WORK} #DEBUG if [[ ${#WORK} -eq 0 ]] then WORK=${SIZE%%M} #echo 2-${WORK} #DEBUG if [[ ${WORK} -ge ${MAX} ]] then echo Greater than ${MAX} - ${SIZE}:${COMMAND} fi fi done Brian P. MacLean Oracle DBA, OCP8i Mandal, Ashoke ashoke.k.mandal@medt To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ronic.com cc: Sent by:Subject: Help in unix script [EMAIL PROTECTED] 03/28/02 09:28 AM Please respond to ORACLE-L Greetings all, I need to do the following unix top -b -U norad PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 12733 norad 1 602 3936K 3392K run 0:05 7.21% dbganlz 12747 norad 4 522 13M 10M sleep 0:05 4.20% dbgora 12721 norad 1 532 3160K 2584K sleep 0:00 0.12% dbgsam 12726 norad 1 522 3184K 2416K sleep 0:00 0.02% dbgalert 12740 norad 1 532 2992K 2128K sleep 0:00 0.02% dbgrepos 12594 norad 1 590 3200K 2544K sleep 0:00 0.01% dbgsam 12606 norad 1 590 4696K 4160K sleep 0:11 0.00% dbganlz 12620 norad 4 590 42M 13M sleep 0:06 0.00% dbgora 12599 norad 1 580 3216K 2400K sleep 0:00 0.00% dbgalert 12613 norad 1 590 3016K 2112K sleep 0:00 0.00% dbgrepos I have to check the last character of SIZE column. If the size is in M(megabyte) then check if the value is 40 then send an e-mail with the COMMAND name and the size. Something like dbgora has a size of 42M I was trying the following script. But I am not sure how to get the last character of SIZE column from the above output and compare with 'M' and then compare with the value. top -b -U norad | grep norad | awk '{ print $6, $11 }' | \ while read SIZE COMMAND do echo Command : $COMMAND Size : $SIZE done Any suggestions will be appreciated. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
ROLLBACK SEGMENT?
Hi I am looking lot of shrinkage in rollback segment.please suggest. Thx -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema 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).
urgent
Hi Guys , I am getting this weired result after executing stored proc . When I run a particuler stored proc which returns two refcursors ( inside proc theresare dynamic query ) multiple times the proc executes well ...but after someexeccution ( using same connection ) the connectiondropssaying end-of-file on communication channel . This is happening after I executes the proc may be 10-12 times . One more thing ..one of parameter to the proc which is getting used to build the dynamic sql is changed in between these execution. This happens only if I change that parameter . If I dont change that parameter its runs ok. Can you help pls .. Thanks , -ak
RE: Best way to move db from AIX to Solaris
We have been doing the reverse (SUN to AIX) here on a large number of databases anywhere from a 1GB in size to 500 GB in size. We use parallel exports over pipes (using DD) and import at the same time. Have a GB Ethernet adapter direct connected between the two boxes. I can do a 500GB database in about 8 hours or so on a really good day. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Thursday, March 28, 2002 5:03 AM To: Multiple recipients of list ORACLE-L Hi! We want to migrate an Oracle db (approx. 50 GB) from AIX to Sun Solaris. What would be the best way to achieve this? Export/Import I guess, right? This is 8.1.7 on Sun Solaris/AIX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Parallel execution question
Hi Friends, I want to use parallel execution to improve the performance of my Oracle7.3 database on AIX with front end baan. I read Oracle documentation, But they did't give me How to set these parameters.. PARALLEL_MIN_SERVERS PARALLEL_MAX_SERVERS PARALLEL_MIN_PERCENT My doubts are is it okay If I set these parameters?? or I have to do any other things to take advantage of parallel execution!! Iam not using parallel hints!! Iam using hints to use particular indexes!! mostly useing cbo with weekly analyzing tables!! Any info regarding that appreciatiable!! Thanks in advance Raghu. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle PL/SQL Developer Needed on Long Island, New York
Manhattan, MT is just 10 miles down the road. ;-) They have a restaurant there where, if you order a margarita when the train is going by it's only half price. It's a quality dive... there aren't as many trains there and they carry more cattle than people. Mooo... -Original Message- Sent: Thursday, March 28, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Importance: High and I love NY, although I'd prefer Manhattan --- Gene Sais [EMAIL PROTECTED] wrote: Never again Long Island! Wonder how the 495 parking lot is these days? Just love this sunshine, pipe down Lisa, its still in the 40's in MN :) [EMAIL PROTECTED] 03/28/02 10:13AM Long Island New York company needs a solid Oracle PL/SQL Developer to join its' I.T. team. PLEASE DO NOT send your resume for this position UNLESS you already live on Long Island (or within a reasonable commute) and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: Looking for a team oriented ORACLE PL/SQL DEVELOPER to design and support various Internet applications projects. Responsibilities include developing back-end components in contribution to the overall applications architecture. Expected to participate in the full development life cycle for projects. Requirements: -Must have 3+ years experience developing client server applications in ORACLE PL/SQL. Knowledge of ORACLE packages, stored proceures, triggers, and database design a must. -Will also need to be a U.S. citizen or permanent resident. The base salary range is 75-85K..depends on experience. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Long Island/PL/SQL/Andrea (*Local area candidaph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
Re: ROLLBACK SEGMENT?
Don't specify OPTIMAL parameter for rollback segment. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 1:38 PM Hi I am looking lot of shrinkage in rollback segment.please suggest. Thx -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema 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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Odd Sql result
Hey folks, Now I've seen some odd results form queries in the past, but I'll be d*mned is I can figure this one out. It defies logic. I've two queries that each return 50 rows from the database the rows are the same is each case (stubby pencil check), but of the three columns returned the last two reverse. I'm including the SQL, a sample result set, and the view definitions that are being used. If you can figure it out, please let me know. I'm asking OTS as well. Dick Goulet Here is the data: select pd.product_id, pts.PART_TYPE, pts.PART_NUM 2 from specsrv.mfg_products pd, vmecs.parts pts 3 where pts.part_type = pd.PART_TYPe 4 and pd.product_id in (6650,6550,6750,35,9920); PRODUCT_ID PART_TYPEPART_NUM -- 9920 BR-FT48C12C150A BRAIN_ASSY_FT 9920 4-FT48C5C100ABRAIN_ASSY_FT 9920 4-FT48C2C50A BRAIN_ASSY_FT 9920 4-FT48C12C150A BRAIN_ASSY_FT 9920 4-FT48C28C150A BRAIN_ASSY_FT 9920 4-SS48B15C250A BRAIN_ASSY_FT 9920 BR-FT48B2C100A BRAIN_ASSY_FT 9920 4-VI-810718 BRAIN_ASSY_FT 9920 4-FT300B15C250A BRAIN_ASSY_FT 9920 BR-FT48B15C250A BRAIN_ASSY_FT 9920 4-FT48B15C250A BRAIN_ASSY_FT 9920 BR-FT48B5C200A BRAIN_ASSY_FT 9920 BR-FT48B28C250A BRAIN_ASSY_FT 9920 4-FT48C3V3C75A BRAIN_ASSY_FT 9920 4-FT48C24C150A BRAIN_ASSY_FT 9920 4-HT-810354 BRAIN_ASSY_FT 9920 4-FT48B2C100ABRAIN_ASSY_FT 9920 4-FT48B5C200ABRAIN_ASSY_FT 9920 4-GW-810354 BRAIN_ASSY_FT 9920 4-VI-810354 BRAIN_ASSY_FT 9920 BR-FT300B15C250A BRAIN_ASSY_FT select pd.product_id, pts.PART_TYPE, pts.PART_NUM 2 from specsrv.mfg_products pd, vmecs.parts pts 3 where RTRIM(pts.part_type) = pd.PART_TYPE 4 and pd.product_id in (6650,6550,6750,35,9920); PRODUCT_ID PART_TYPEPART_NUM -- 9920 BRAIN_ASSY_FTBR-FT48C12C150A 9920 BRAIN_ASSY_FT4-FT48C5C100A 9920 BRAIN_ASSY_FT4-FT48C2C50A 9920 BRAIN_ASSY_FT4-FT48C12C150A 9920 BRAIN_ASSY_FT4-FT48C28C150A 9920 BRAIN_ASSY_FT4-SS48B15C250A 9920 BRAIN_ASSY_FTBR-FT48B2C100A 9920 BRAIN_ASSY_FT4-VI-810718 9920 BRAIN_ASSY_FT4-FT300B15C250A 9920 BRAIN_ASSY_FTBR-FT48B15C250A 9920 BRAIN_ASSY_FT4-FT48B15C250A 9920 BRAIN_ASSY_FTBR-FT48B5C200A 9920 BRAIN_ASSY_FTBR-FT48B28C250A 9920 BRAIN_ASSY_FT4-FT48C3V3C75A 9920 BRAIN_ASSY_FT4-FT48C24C150A 9920 BRAIN_ASSY_FT4-HT-810354 9920 BRAIN_ASSY_FT4-FT48B2C100A 9920 BRAIN_ASSY_FT4-FT48B5C200A 9920 BRAIN_ASSY_FT4-GW-810354 9920 BRAIN_ASSY_FT4-VI-810354 9920 BRAIN_ASSY_FTBR-FT300B15C250A desc vmecs.parts Name Null?Type --- PART_NUM NOT NULL VARCHAR2(20) PART_REV VARCHAR2(2) DESCRIPTION VARCHAR2(30) PART_TYPE VARCHAR2(20) PAN_TYPE VARCHAR2(20) PAN_SIZE NUMBER(22) STOCKING_UOM VARCHAR2(2) BUYER VARCHAR2(2) SOURCE_CODE VARCHAR2(2) CLASS_CODENUMBER(22) NUM_ERRORSNUMBER(22) DATE_CHANGED DATE desc specsrv.mfg_products Name Null?Type - PRODUCT_ID NOT NULL NUMBER PRODUCT_NAME VARCHAR2(60) PART_TYPE VARCHAR2(61) PROD_DESCNOT NULL VARCHAR2(60) CONFIGURABLE NOT NULL VARCHAR2(1) SPEC_TABLE_NAME VARCHAR2(40) NUM_SMD_BRDS NUMBER -- 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
CLIENT VERSION
Hi, In batch script If we need to verify the version of oracle software on server we issue: select * from v$version; But how to find the client version from some batch script?? 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).
Parallel execution question
Hi Friends, I want to use parallel execution to improve the performance of my Oracle7.3 database on AIX with front end baan. I read Oracle documentation, But they did't give me How to set these parameters.. PARALLEL_MIN_SERVERS PARALLEL_MAX_SERVERS PARALLEL_MIN_PERCENT My doubts are is it okay If I set these parameters?? or I have to do any other things to take advantage of parallel execution!! Iam not using parallel hints!! Iam using hints to use particular indexes!! mostly useing cbo with weekly analyzing tables!! I have 8 CPUs with 2GB RAM on AIX415. Any info regarding that appreciatiable!! Thanks in advance Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ROLLBACK SEGMENT?
Ross Keep the rollback segments out of the cold water. Shrinkage is bad. /Ross Scott Shafer San Antonio, TX 210-581-6217 Common sense will not accomplish great things. Simply become insane and desperate. -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Subject: ROLLBACK SEGMENT? Hi I am looking lot of shrinkage in rollback segment.please suggest. Thx -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle PL/SQL Developer Needed on Long Island, New York
Someone has been getting way to much fresh air...come out to the northeast and breath some quality smog...it will help to clear your head -Original Message- Sent: Thursday, March 28, 2002 2:28 PM To: Multiple recipients of list ORACLE-L Manhattan, MT is just 10 miles down the road. ;-) They have a restaurant there where, if you order a margarita when the train is going by it's only half price. It's a quality dive... there aren't as many trains there and they carry more cattle than people. Mooo... -Original Message- Sent: Thursday, March 28, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Importance: High and I love NY, although I'd prefer Manhattan --- Gene Sais [EMAIL PROTECTED] wrote: Never again Long Island! Wonder how the 495 parking lot is these days? Just love this sunshine, pipe down Lisa, its still in the 40's in MN :) [EMAIL PROTECTED] 03/28/02 10:13AM Long Island New York company needs a solid Oracle PL/SQL Developer to join its' I.T. team. PLEASE DO NOT send your resume for this position UNLESS you already live on Long Island (or within a reasonable commute) and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: Looking for a team oriented ORACLE PL/SQL DEVELOPER to design and support various Internet applications projects. Responsibilities include developing back-end components in contribution to the overall applications architecture. Expected to participate in the full development life cycle for projects. Requirements: -Must have 3+ years experience developing client server applications in ORACLE PL/SQL. Knowledge of ORACLE packages, stored proceures, triggers, and database design a must. -Will also need to be a U.S. citizen or permanent resident. The base salary range is 75-85K..depends on experience. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Long Island/PL/SQL/Andrea (*Local area candidaph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: ROLLBACK SEGMENT?
Anyone here write books for Coriolis? They are closing up shop effective today. No more Exam Crams, black books, etc... RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Coriolis is dead
Sorry for the repost, I put a wrong subject header on... Anyone here write books for Coriolis? They are closing up shop effective today. No more Exam Crams, black books, etc... RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Parallel execution question
Raghu Run following query to check your parallel parameters set in initSID.ora. If your running paralell degree upto 5 default is ok. However parallel execution requires lot of overhead like memory usage and temp tablespace. Please refer some Manual/book for proper understanding as it is itself a waste subject with lot of limitation in 7.3.4. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 28 Mar 2002 11:23:21 -0800 Hi Friends, I want to use parallel execution to improve the performance of my Oracle7.3 database on AIX with front end baan. I read Oracle documentation, But they did't give me How to set these parameters.. PARALLEL_MIN_SERVERS PARALLEL_MAX_SERVERS PARALLEL_MIN_PERCENT My doubts are is it okay If I set these parameters?? or I have to do any other things to take advantage of parallel execution!! Iam not using parallel hints!! Iam using hints to use particular indexes!! mostly useing cbo with weekly analyzing tables!! Any info regarding that appreciatiable!! Thanks in advance Raghu. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: urgent
Hello, Check alert.log. If there is a related error or if a trace is generated, forward them to list. Big Planet wrote: Hi Guys ,I am getting this weired result after executing stored proc . When I run a particuler stored proc which returns two refcursors ( inside proc theres are dynamic query ) multiple times the proc executes well ...but after someexeccution ( using same connection ) the connection drops saying end-of-file on communication channel .This is happening after I executes the proc may be 10-12 times . One more thing ..one of parameter to the proc which is getting used to build the dynamic sql is changed in between these execution. This happens only if I change that parameter . If I dont change that parameter its runs ok.Can you help pls ..Thanks ,-ak -- Danisment Gazi Unal http://www.unal-bilisim.com
Re: Odd Sql result
[EMAIL PROTECTED] wrote: Hey folks, Now I've seen some odd results form queries in the past, but I'll be d*mned is I can figure this one out. It defies logic. I've two queries that each return 50 rows from the database the rows are the same is each case (stubby pencil check), but of the three columns returned the last two reverse. I'm including the SQL, a sample result set, and the view definitions that are being used. If you can figure it out, please let me know. I'm asking OTS as well. Dick Goulet Waow, that's really weird. You say that what you are querying are VIEWS. Could you post the view text as well? I suspect that's where weirdness comes from. If they happen to be UNIONs with swapped columns in one segment, the fact that the RTRIM() changes the execution plan (probably) might hit other sections of the data. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Parallel execution question
Read all articles on Parallel Query at Jonathan's web site: http://www.jlcomp.demon.co.uk/ind_pqo.html You will know how it works and why... - Kirti -Original Message- Sent: Thursday, March 28, 2002 1:58 PM To: Multiple recipients of list ORACLE-L Hi Friends, I want to use parallel execution to improve the performance of my Oracle7.3 database on AIX with front end baan. I read Oracle documentation, But they did't give me How to set these parameters.. PARALLEL_MIN_SERVERS PARALLEL_MAX_SERVERS PARALLEL_MIN_PERCENT My doubts are is it okay If I set these parameters?? or I have to do any other things to take advantage of parallel execution!! Iam not using parallel hints!! Iam using hints to use particular indexes!! mostly useing cbo with weekly analyzing tables!! I have 8 CPUs with 2GB RAM on AIX415. Any info regarding that appreciatiable!! Thanks in advance Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle PL/SQL Developer Needed on Long Island, New York
okay, what's the reasoning behind the half price when the train goes by? --- Orr, Steve [EMAIL PROTECTED] wrote: Manhattan, MT is just 10 miles down the road. ;-) They have a restaurant there where, if you order a margarita when the train is going by it's only half price. It's a quality dive... there aren't as many trains there and they carry more cattle than people. Mooo... -Original Message- Sent: Thursday, March 28, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Importance: High and I love NY, although I'd prefer Manhattan --- Gene Sais [EMAIL PROTECTED] wrote: Never again Long Island! Wonder how the 495 parking lot is these days? Just love this sunshine, pipe down Lisa, its still in the 40's in MN :) [EMAIL PROTECTED] 03/28/02 10:13AM Long Island New York company needs a solid Oracle PL/SQL Developer to join its' I.T. team. PLEASE DO NOT send your resume for this position UNLESS you already live on Long Island (or within a reasonable commute) and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: Looking for a team oriented ORACLE PL/SQL DEVELOPER to design and support various Internet applications projects. Responsibilities include developing back-end components in contribution to the overall applications architecture. Expected to participate in the full development life cycle for projects. Requirements: -Must have 3+ years experience developing client server applications in ORACLE PL/SQL. Knowledge of ORACLE packages, stored proceures, triggers, and database design a must. -Will also need to be a U.S. citizen or permanent resident. The base salary range is 75-85K..depends on experience. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Long Island/PL/SQL/Andrea (*Local area candidaph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
Re: ROLLBACK SEGMENT?
Alternately run following script and set your optimal nearest to HWMSIZE as a start. It requires a lot of monitoring to set optimal according to your application requirement. select ud.name, sg.extents ext, round(sg.blocks * ts.blocksize / 1048576, 2) MB, round(s.optsize / 1048576, 1) optsize, round(s.aveactive / 1048576, 1) AVEACT, round(s.hwmsize / 1048576, 1) HWMSIZE, s.shrinks, s.wraps, s.waits, nvl(s.status, 'OFFLINE') status from v$rollstat s, sys.undo$ ud, sys.seg$ sg, sys.ts$ ts where ud.us# = s.usn (+) and ud.file# = sg.file# and ud.block# = sg.block# and sg.ts# = ts.ts# / Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 28 Mar 2002 11:08:20 -0800 Don't specify OPTIMAL parameter for rollback segment. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 1:38 PM Hi I am looking lot of shrinkage in rollback segment.please suggest. Thx -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema 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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle PL/SQL Developer Needed on Long Island, New York
When full cattle cars go by it's really fresh. -Original Message- Sent: Thursday, March 28, 2002 1:03 PM To: Multiple recipients of list ORACLE-L Someone has been getting way to much fresh air...come out to the northeast and breath some quality smog...it will help to clear your head -Original Message- Sent: Thursday, March 28, 2002 2:28 PM To: Multiple recipients of list ORACLE-L Manhattan, MT is just 10 miles down the road. ;-) They have a restaurant there where, if you order a margarita when the train is going by it's only half price. It's a quality dive... there aren't as many trains there and they carry more cattle than people. Mooo... -Original Message- Sent: Thursday, March 28, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Importance: High and I love NY, although I'd prefer Manhattan --- Gene Sais [EMAIL PROTECTED] wrote: Never again Long Island! Wonder how the 495 parking lot is these days? Just love this sunshine, pipe down Lisa, its still in the 40's in MN :) [EMAIL PROTECTED] 03/28/02 10:13AM Long Island New York company needs a solid Oracle PL/SQL Developer to join its' I.T. team. PLEASE DO NOT send your resume for this position UNLESS you already live on Long Island (or within a reasonable commute) and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: Looking for a team oriented ORACLE PL/SQL DEVELOPER to design and support various Internet applications projects. Responsibilities include developing back-end components in contribution to the overall applications architecture. Expected to participate in the full development life cycle for projects. Requirements: -Must have 3+ years experience developing client server applications in ORACLE PL/SQL. Knowledge of ORACLE packages, stored proceures, triggers, and database design a must. -Will also need to be a U.S. citizen or permanent resident. The base salary range is 75-85K..depends on experience. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Long Island/PL/SQL/Andrea (*Local area candidaph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
RE: Coriolis is dead
Robert Just bought your 8i book. Hope this doesn't affect you too badly. As a matter of interest Robert, why does your signature not mention 9i. You have taken (and passed!!) the 9i exam haven't you.? John -Original Message- Sent: 28 March 2002 20:09 To: Multiple recipients of list ORACLE-L Sorry for the repost, I put a wrong subject header on... Anyone here write books for Coriolis? They are closing up shop effective today. No more Exam Crams, black books, etc... RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ROLLBACK SEGMENT?
Thanks for the FYI. Do you have any details as to why they are closing up shop? I thought there Exam Cram and Black books were popular Does this mean we can freely copy these books now?? -Original Message- Sent: Thursday, March 28, 2002 3:08 PM To: Multiple recipients of list ORACLE-L Anyone here write books for Coriolis? They are closing up shop effective today. No more Exam Crams, black books, etc... RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Oracle PL/SQL Developer Needed on Long Island, New York
Well Steve, at least you don't totally miss out on the east coast smog. -Original Message- Sent: Thursday, March 28, 2002 2:38 PM To: Multiple recipients of list ORACLE-L When full cattle cars go by it's really fresh. -Original Message- Sent: Thursday, March 28, 2002 1:03 PM To: Multiple recipients of list ORACLE-L Someone has been getting way to much fresh air...come out to the northeast and breath some quality smog...it will help to clear your head -Original Message- Sent: Thursday, March 28, 2002 2:28 PM To: Multiple recipients of list ORACLE-L Manhattan, MT is just 10 miles down the road. ;-) They have a restaurant there where, if you order a margarita when the train is going by it's only half price. It's a quality dive... there aren't as many trains there and they carry more cattle than people. Mooo... -Original Message- Sent: Thursday, March 28, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Importance: High and I love NY, although I'd prefer Manhattan --- Gene Sais [EMAIL PROTECTED] wrote: Never again Long Island! Wonder how the 495 parking lot is these days? Just love this sunshine, pipe down Lisa, its still in the 40's in MN :) [EMAIL PROTECTED] 03/28/02 10:13AM Long Island New York company needs a solid Oracle PL/SQL Developer to join its' I.T. team. PLEASE DO NOT send your resume for this position UNLESS you already live on Long Island (or within a reasonable commute) and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: Looking for a team oriented ORACLE PL/SQL DEVELOPER to design and support various Internet applications projects. Responsibilities include developing back-end components in contribution to the overall applications architecture. Expected to participate in the full development life cycle for projects. Requirements: -Must have 3+ years experience developing client server applications in ORACLE PL/SQL. Knowledge of ORACLE packages, stored proceures, triggers, and database design a must. -Will also need to be a U.S. citizen or permanent resident. The base salary range is 75-85K..depends on experience. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Long Island/PL/SQL/Andrea (*Local area candidaph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the
RE: Oracle PL/SQL Developer Needed on Long Island, New York
Because of the sudden change in the ambient air freshness :) I bet the cattle still beat margaritas !! ;) Some things are difficult to imagine when one rides a train 1/2 a mile below ground ;))) - Kirti -Original Message- Sent: Thursday, March 28, 2002 2:29 PM To: Multiple recipients of list ORACLE-L okay, what's the reasoning behind the half price when the train goes by? --- Orr, Steve [EMAIL PROTECTED] wrote: Manhattan, MT is just 10 miles down the road. ;-) They have a restaurant there where, if you order a margarita when the train is going by it's only half price. It's a quality dive... there aren't as many trains there and they carry more cattle than people. Mooo... -Original Message- Sent: Thursday, March 28, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Importance: High and I love NY, although I'd prefer Manhattan --- Gene Sais [EMAIL PROTECTED] wrote: Never again Long Island! Wonder how the 495 parking lot is these days? Just love this sunshine, pipe down Lisa, its still in the 40's in MN :) [EMAIL PROTECTED] 03/28/02 10:13AM Long Island New York company needs a solid Oracle PL/SQL Developer to join its' I.T. team. PLEASE DO NOT send your resume for this position UNLESS you already live on Long Island (or within a reasonable commute) and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: Looking for a team oriented ORACLE PL/SQL DEVELOPER to design and support various Internet applications projects. Responsibilities include developing back-end components in contribution to the overall applications architecture. Expected to participate in the full development life cycle for projects. Requirements: -Must have 3+ years experience developing client server applications in ORACLE PL/SQL. Knowledge of ORACLE packages, stored proceures, triggers, and database design a must. -Will also need to be a U.S. citizen or permanent resident. The base salary range is 75-85K..depends on experience. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Long Island/PL/SQL/Andrea (*Local area candidaph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
Re: Odd Sql result
Are you sure you aren't running 9i with: alter session set sessiontimezone = 'UTC+72:00': Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 28 March 2002 20:12 |Hey folks, | |Now I've seen some odd results form queries in the past, but I'll be d*mned |is I can figure this one out. It defies logic. | |I've two queries that each return 50 rows from the database the rows are |the same is each case (stubby pencil check), but of the three columns returned |the last two reverse. I'm including the SQL, a sample result set, and the view |definitions that are being used. If you can figure it out, please let me know. |I'm asking OTS as well. | |Dick Goulet | |Here is the data: | |select pd.product_id, pts.PART_TYPE, pts.PART_NUM | 2 from specsrv.mfg_products pd, vmecs.parts pts | 3 where pts.part_type = pd.PART_TYPe | 4 and pd.product_id in (6650,6550,6750,35,9920); | |PRODUCT_ID PART_TYPEPART_NUM |-- | 9920 BR-FT48C12C150A BRAIN_ASSY_FT | 9920 4-FT48C5C100ABRAIN_ASSY_FT | 9920 4-FT48C2C50A BRAIN_ASSY_FT | 9920 4-FT48C12C150A BRAIN_ASSY_FT | 9920 4-FT48C28C150A BRAIN_ASSY_FT | 9920 4-SS48B15C250A BRAIN_ASSY_FT | 9920 BR-FT48B2C100A BRAIN_ASSY_FT | 9920 4-VI-810718 BRAIN_ASSY_FT | 9920 4-FT300B15C250A BRAIN_ASSY_FT | 9920 BR-FT48B15C250A BRAIN_ASSY_FT | 9920 4-FT48B15C250A BRAIN_ASSY_FT | 9920 BR-FT48B5C200A BRAIN_ASSY_FT | 9920 BR-FT48B28C250A BRAIN_ASSY_FT | 9920 4-FT48C3V3C75A BRAIN_ASSY_FT | 9920 4-FT48C24C150A BRAIN_ASSY_FT | 9920 4-HT-810354 BRAIN_ASSY_FT | 9920 4-FT48B2C100ABRAIN_ASSY_FT | 9920 4-FT48B5C200ABRAIN_ASSY_FT | 9920 4-GW-810354 BRAIN_ASSY_FT | 9920 4-VI-810354 BRAIN_ASSY_FT | 9920 BR-FT300B15C250A BRAIN_ASSY_FT | |select pd.product_id, pts.PART_TYPE, pts.PART_NUM | 2 from specsrv.mfg_products pd, vmecs.parts pts | 3 where RTRIM(pts.part_type) = pd.PART_TYPE | 4 and pd.product_id in (6650,6550,6750,35,9920); | |PRODUCT_ID PART_TYPEPART_NUM |-- | 9920 BRAIN_ASSY_FTBR-FT48C12C150A | 9920 BRAIN_ASSY_FT4-FT48C5C100A | 9920 BRAIN_ASSY_FT4-FT48C2C50A | 9920 BRAIN_ASSY_FT4-FT48C12C150A | 9920 BRAIN_ASSY_FT4-FT48C28C150A | 9920 BRAIN_ASSY_FT4-SS48B15C250A | 9920 BRAIN_ASSY_FTBR-FT48B2C100A | 9920 BRAIN_ASSY_FT4-VI-810718 | 9920 BRAIN_ASSY_FT4-FT300B15C250A | 9920 BRAIN_ASSY_FTBR-FT48B15C250A | 9920 BRAIN_ASSY_FT4-FT48B15C250A | 9920 BRAIN_ASSY_FTBR-FT48B5C200A | 9920 BRAIN_ASSY_FTBR-FT48B28C250A | 9920 BRAIN_ASSY_FT4-FT48C3V3C75A | 9920 BRAIN_ASSY_FT4-FT48C24C150A | 9920 BRAIN_ASSY_FT4-HT-810354 | 9920 BRAIN_ASSY_FT4-FT48B2C100A | 9920 BRAIN_ASSY_FT4-FT48B5C200A | 9920 BRAIN_ASSY_FT4-GW-810354 | 9920 BRAIN_ASSY_FT4-VI-810354 | 9920 BRAIN_ASSY_FTBR-FT300B15C250A | |desc vmecs.parts |Name Null?Type | --- |PART_NUM NOT NULL VARCHAR2(20) |PART_REV VARCHAR2(2) |DESCRIPTION VARCHAR2(30) |PART_TYPE VARCHAR2(20) |PAN_TYPE VARCHAR2(20) |PAN_SIZE NUMBER(22) |STOCKING_UOM VARCHAR2(2) |BUYER VARCHAR2(2) |SOURCE_CODE VARCHAR2(2) |CLASS_CODENUMBER(22) |NUM_ERRORSNUMBER(22) |DATE_CHANGED DATE | |desc specsrv.mfg_products | Name Null?Type | - | PRODUCT_ID NOT NULL NUMBER | PRODUCT_NAME VARCHAR2(60) | PART_TYPE VARCHAR2(61) | PROD_DESCNOT NULL VARCHAR2(60) | CONFIGURABLE NOT NULL VARCHAR2(1) | SPEC_TABLE_NAME
RE: Coriolis is dead
Nope, not taken the 9i OCP Upgrade yet. Started to in the UK in December but didn't. Have not had the time yet. Need to do it though. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Thursday, March 28, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Robert Just bought your 8i book. Hope this doesn't affect you too badly. As a matter of interest Robert, why does your signature not mention 9i. You have taken (and passed!!) the 9i exam haven't you.? John -Original Message- Sent: 28 March 2002 20:09 To: Multiple recipients of list ORACLE-L Sorry for the repost, I put a wrong subject header on... Anyone here write books for Coriolis? They are closing up shop effective today. No more Exam Crams, black books, etc... RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ROLLBACK SEGMENT?
Does this mean we can freely copy these books now?? Of course not!! :-( Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Thursday, March 28, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Thanks for the FYI. Do you have any details as to why they are closing up shop? I thought there Exam Cram and Black books were popular Does this mean we can freely copy these books now?? -Original Message- Sent: Thursday, March 28, 2002 3:08 PM To: Multiple recipients of list ORACLE-L Anyone here write books for Coriolis? They are closing up shop effective today. No more Exam Crams, black books, etc... RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]: Odd Sql result
Stephane, Yeah, it's weird at best. Asked OTS about it, along with sending them the view defs and they replied that I should try on a supported version of Oracle. I forgot to mention in the previous post that this is on 8.0.5.2.1. Anyway, I tried on 8.1.7 bingo it did not re-occur. The end result is that Oracle believes it to be a bug in 8.0. Well good for them, I really did need one more reason to upgrade this PIG and now I've got another. Dick Goulet Reply Separator Author: Stephane Faroult [EMAIL PROTECTED] Date: 3/28/2002 12:23 PM [EMAIL PROTECTED] wrote: Hey folks, Now I've seen some odd results form queries in the past, but I'll be d*mned is I can figure this one out. It defies logic. I've two queries that each return 50 rows from the database the rows are the same is each case (stubby pencil check), but of the three columns returned the last two reverse. I'm including the SQL, a sample result set, and the view definitions that are being used. If you can figure it out, please let me know. I'm asking OTS as well. Dick Goulet Waow, that's really weird. You say that what you are querying are VIEWS. Could you post the view text as well? I suspect that's where weirdness comes from. If they happen to be UNIONs with swapped columns in one segment, the fact that the RTRIM() changes the execution plan (probably) might hit other sections of the data. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Learn from my mistakes! Or Helpful DBA hint of the day
on 18/03/2002 -0800, you wrote: In 9.0.1, when you create a DB, you would connect / as sysdba. However, if you also run catalog and catproc while connected like this, Oracle Advanced Symmetric Replication WILL NOT WORK. You *MUST* be connected as SYS as sysdba. It's taken me forever to find this. The biggest clue I had was a number of ORA-06550 errors in the create logs that point to a character set mismatch. Of course, I found an article on Metaclink that said this may be normal, so I ignored them at first. (I can't find that article again!) I know I've sent out at least one other message like this, but these little things can really come back and haunt a person. And maybe the next time I have this and send a message to the list, someone with a real memory can help me! Enjoy! :) Hi Rich, sorry for a late answer... Recently i had this same problem upgrading to 8.1.7.3 and found a clue burried in a Metalink Forum (search for thread 142012.995) The interesting part is : Quote The problem might be related to a few SQL*Plus initialization bugs, i.e. you should not call PL/SQL in the same session in which you started the instance. You need to reconnect first End Quote HTH Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: CLIENT VERSION
Here's a way on unix: strings $ORACLE_HOME/lib/libclntsh.so | grep ^Version [7-9] -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 28 Mar 2002, Harvinder Singh wrote: In batch script If we need to verify the version of oracle software on server we issue: select * from v$version; But how to find the client version from some batch script?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Off topic - Oracle 9i on W2k - AMD Athlon XP or Intel Celeron
upgrade guide: http://www6.tomshardware.com/howto/01q4/011005/index.html If you surf around that site, you should find purchasing comparisons. The biggest stupidity with the P4 is the crippled LU2 cache. AMD came up with an achitecture that has a big LU2 cache, which in most (not all) cases translates into a better price/performace ratio. http://www.anandtech.com/ - old AMD architecture: http://www.anandtech.com/cpu/showdoc.html?i=1595 - new AMD architecture: http://www.anandtech.com/cpu/showdoc.html?i=1591 SMP (for database servers, consider benefits of 2 CPUs, which Win2000 natively supports:): http://www.lostcircuits.com/motherboard/amd_mpx regards, ep On 28 Mar 2002 at 0:38, Szecsy Tamas wrote: I am running Oracle 9i on my home machine (Celeron 300 MHz) and it is pretty slow. I would like to upgrade either to Celeron 1.2 GHz or AMD XP 1400+ GHz. Apart from the (not negligible) cost differences I can not decide which solution would be better in respect to the Oracle 9i performance. Every one here at my company would like to persuade me to buy AMD, because it is MUCH faster than an Intel Celeron solution. Does this hold? -- 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).
1999 Proceedings of OpenWorld
Does anyone have information on the location and format of the whitepapers and presentations from OpenWorld 1999? Was it produced on CD that year? If so does anyone have a copy? If it was published on the web, does anyone know where and if it is still there? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rename Oracle User
If you haven't already done this, the find's are unneeded. How about replacing 1,3,4 with: create dba group usermod -l oracle -g dba oracle2 Since the ownership's in UNIX are by UID, if the username is changed then all the files are now owned by the new username(same UID). shutdown BACKUP usermod update scripts startup -Original Message- From: Todd Carlson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Subject: Rename Oracle User Solaris 5.8 Oracle 8.1.7.2 Has anyone successfully renamed the Oracle user on a solaris box? At the moment I don't a test box and this is a rarely used development system. The current Oracle user and group are oracle2 and dba2. We have to change it to match our standards, i.e. oracle dba. The plan is to (after a full system backup): 1) Create the correct local user group with the same home directory. 2) Shutdown all Oracle processes. 3) Find . -user oracle2 -exec chown oracle {} \; 4) Find . -user dba2 -exec chgrp dba {} \; 5) Modify all scripts to use the correct group user. 6) Pray. 7) Start the database and listener. 8) Check for functionality errors. 9) Shut everything down and take a full system backup. Am I missing anything? Is there any problems with the method? Thanks, Todd Carlson Oracle Database Administrator Tripos, Inc. (314) 647-8837 Ext.3246 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Todd Carlson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle PL/SQL Developer Needed on Long Island, New York
not when one lives with 4 cats they aren't difficult to imagine! --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Because of the sudden change in the ambient air freshness :) I bet the cattle still beat margaritas !! ;) Some things are difficult to imagine when one rides a train 1/2 a mile below ground ;))) - Kirti -Original Message- Sent: Thursday, March 28, 2002 2:29 PM To: Multiple recipients of list ORACLE-L okay, what's the reasoning behind the half price when the train goes by? --- Orr, Steve [EMAIL PROTECTED] wrote: Manhattan, MT is just 10 miles down the road. ;-) They have a restaurant there where, if you order a margarita when the train is going by it's only half price. It's a quality dive... there aren't as many trains there and they carry more cattle than people. Mooo... -Original Message- Sent: Thursday, March 28, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Importance: High and I love NY, although I'd prefer Manhattan --- Gene Sais [EMAIL PROTECTED] wrote: Never again Long Island! Wonder how the 495 parking lot is these days? Just love this sunshine, pipe down Lisa, its still in the 40's in MN :) [EMAIL PROTECTED] 03/28/02 10:13AM Long Island New York company needs a solid Oracle PL/SQL Developer to join its' I.T. team. PLEASE DO NOT send your resume for this position UNLESS you already live on Long Island (or within a reasonable commute) and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: Looking for a team oriented ORACLE PL/SQL DEVELOPER to design and support various Internet applications projects. Responsibilities include developing back-end components in contribution to the overall applications architecture. Expected to participate in the full development life cycle for projects. Requirements: -Must have 3+ years experience developing client server applications in ORACLE PL/SQL. Knowledge of ORACLE packages, stored proceures, triggers, and database design a must. -Will also need to be a U.S. citizen or permanent resident. The base salary range is 75-85K..depends on experience. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Long Island/PL/SQL/Andrea (*Local area candidaph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Creating Oracle Users from Win NT/2000 users
Hi, Is it possible to create users in Oracle from Win NT users? In this case all the users of a domain will be using Oracle. Any new user will also be Oracle user. TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).