Slow database
Hallo all you experts, I have an Oracle database, every night it is read many files into the database, but all the procedures take so long, it keeps taking all the next day almost. It shouldnt do that, because the system is very slow because of this. When I run other things during the day, many things are slow, for instance when i delete 1000 rows it shouldnt take one hour, which it takes while the "big" process is running. Do you have any suggestion what I should do to trace the whole problem? When i delete 1000 rows during "low"-time, then it just take a few seconds to delete the records. Hope anyone can help me with suggestions. Roland Skldblom -- 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).
SGA Parameters ...
Hi, Can u help me to knoe what are the initDB.ora parameters contributing these ? Pl. give one to one or one to many mapping of these with the parameters. - Total System Global Area 57124108 bytes Fixed Size70924 bytes Variable Size 40198144 bytes Database Buffers 16777216 bytes Redo Buffers 77824 bytes Thanks, - Harsh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harsh Agrawal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: CDI-21600: A running generator o
:) the probled solved by upgrading Forms up to 6.0.8.8.0 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 7:06 PM To: Multiple recipients of list ORACLE-L Subject: RE:CDI-21600: A running generator o I faced the same problem. Just check the Oracle home in your registry. Otherwise Reinstall Designer on client machine. Cheers, -Anup -- 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). ÷ÉÒÕÓÙ ÎÅ ÏÂÎÁÒÕÖÅÎÙ. ðÒÏ×ÅÒÉÌ AVP for MS Exchange. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Belov Igor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 find SEQUENCE#
So rely on v$log_history. Regards. -Mensaje original- De: Vadim Gorbounov [SMTP:[EMAIL PROTECTED]] Enviado el: lunes 19 de marzo de 2001 21:11 Para: Multiple recipients of list ORACLE-L Asunto: How to find SEQUENCE# Hi, DBAs, Can anybody give me a guess, how to find out next log SEQUENCE#, required for recovery, without issuing RECOVER command? I believe, this is not possible to find it out of Oracle dictionary, can anybody confirm this or, otherwise, name appropriate fixed table? I'm particularly concerned with standby database recovery, I want to know in advance SEQUENCE#, required to roll forward, and don't want to rely on alertXXX.log tail. Another question, in "normal" database I can find correspondence between CHANGE# and log SEQUENCE# from v$archived_log or v$log. Where to look this correspondence in standby database. Thanks for Your Help Vadim Gorbounov Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Trassens, Christian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
Been drinking it in the UK for most of my 37 years !!! Used to be a plain old pick me up for years (if you ever had to go into hospital or indeed went visiting, you were either given or giving a bottle). Nowadays it is used by sportsmen etc for exactly what you have described. Regards Lee (one of the original Lucozade kids) PS. This was one of my mothers cravings when she was pregnant with me - however she could only drink it whilst eating rhubarb flavoured rock - WEIRD !! -Original Message- Sent: 19 March 2001 20:41 To: Multiple recipients of list ORACLE-L Speaking of sugar... I just returned from Trinidad (on a mission trip to build a church in Toco). While working in the 95 degree sun all day we often walked up to the corner store and bought water and cokes (the coca cola was much sweeter there than in the US, but also less carbonated). What we also found was a product called Lucozade (http://www.lucozade.com/). This was a sport drink essentially made of glucose syrup. From their website - "When you drink it, the glucose gets rapidly absorbed into your bloodstream and gives you a quick burst of energy. Glucose is the natural preferred fuel for the body becuase of the speed with which it can be digested and absorbed. Once absorbed it is a readily available source of fuel, whic all cells of the body can utilise." Official drink of on-call DBAs. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack C. Applewhite Sent: Monday, March 19, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Kimberley, I'd be surprised if you can get "real" raw sugar in stores. When I was in the U.S. Peace Corps in Belize in the mid '70s, raw sugar was readily available, since sugar was a primary export from that beautiful little country. If you let a couple of pounds of raw sugar sit in a brown paper bag for a day or two, the molasses would settle to the bottom and puddle - a jar, shaken occasionally, was a better storage option. It was delicious! There's nothing quite like a peanut butter and raw sugar sandwich! Ironically, the Belizians preferred refined, white sugar, since it was considered more "upscale" than the raw sugar. BTW, other advantages to living in a sugar-exporting country included very cheap soft drinks and rum!...Oh, and Reggae! ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Kimberly Smith Sent: Monday, March 19, 2001 9:33 AM To: Multiple recipients of list ORACLE-L Recipe Hey, found out that muscavado sugar is raw sugar. Hopefully I can find it in the stores. If not I am going to Second Cup and "borrowing" a whole bunch of little packets;-) 375g dark muscovado sugar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
They even do a low calorie version with sweetners instead of glucose... What's the point ! Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. Knaves House, Knaves Beech Business Centre Loudwater, High Wycombe Buckinghamshire , HP10 9QR, United Kingdom Telephone: +44 (0) 1494 540235 Facsimile: +44 (0) 1494 488824 E Mail: [EMAIL PROTECTED] -- lerobe - Lee RobertsonTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] LEROBE@acxiocc: m.co.uk Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Sent by: root@fatcity. com 20/03/2001 08:05 Please respond to ORACLE-L Been drinking it in the UK for most of my 37 years !!! Used to be a plain old pick me up for years (if you ever had to go into hospital or indeed went visiting, you were either given or giving a bottle). Nowadays it is used by sportsmen etc for exactly what you have described. Regards Lee (one of the original Lucozade kids) PS. This was one of my mothers cravings when she was pregnant with me - however she could only drink it whilst eating rhubarb flavoured rock - WEIRD !! -Original Message- Sent: 19 March 2001 20:41 To: Multiple recipients of list ORACLE-L Speaking of sugar... I just returned from Trinidad (on a mission trip to build a church in Toco). While working in the 95 degree sun all day we often walked up to the corner store and bought water and cokes (the coca cola was much sweeter there than in the US, but also less carbonated). What we also found was a product called Lucozade (http://www.lucozade.com/). This was a sport drink essentially made of glucose syrup. From their website - "When you drink it, the glucose gets rapidly absorbed into your bloodstream and gives you a quick burst of energy. Glucose is the natural preferred fuel for the body becuase of the speed with which it can be digested and absorbed. Once absorbed it is a readily available source of fuel, whic all cells of the body can utilise." Official drink of on-call DBAs. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack C. Applewhite Sent: Monday, March 19, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Kimberley, I'd be surprised if you can get "real" raw sugar in stores. When I was in the U.S. Peace Corps in Belize in the mid '70s, raw sugar was readily available, since sugar was a primary export from that beautiful little country. If you let a couple of pounds of raw sugar sit in a brown paper bag for a day or two, the molasses would settle to the bottom and puddle - a jar, shaken occasionally, was a better storage option. It was delicious! There's nothing quite like a peanut butter and raw sugar sandwich! Ironically, the Belizians preferred refined, white sugar, since it was considered more "upscale" than the raw sugar. BTW, other advantages to living in a sugar-exporting country included very cheap soft drinks and rum!...Oh, and Reggae! ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit,
BUG in installing Designer6 Repository on 8.1.7 database
List hi! Here is description of the Bug we found. It is quite unpleasent. For a while everything looks just nice, then installation freeze. There are no errors of any kind; system just hangs (and it can lasts for hours)! It cost me 3 hours, before I realized something is very wrong (you think it's almost done)! Just to let you know. Sonja Title: ALERT: Some Repository versions will not install on Oracle 8.1.7.0.0 ALERT: Some Repository versions will not install on Oracle 8.1.7.0.0 Versions Affected ~ Oracle Designer/Repository 6i Release 1 and all Oracle Designer 6.0 versions prior to Designer 6.0.3.11 (patchset 7) Platforms Affected ~~ ALL Description ~~~ During the installation phase of Designer Repository when the script CIUEET.OPB is fired the 8.1.7.0.0 database server will show 100% CPU usage and hang indefinitely. The script CIUEET.OPB installs the component that is responsible for managing UE elements Type Extensions to the repository. This problem can also occur if you attempt a full repository import. Note: This is an Oracle 8.1.7 PLSQL Server bug and not a Designer bug. See Oracle 8.1.7 Server PLSQL bug Bug:1396675. Likelihood of Occurrence HIGH: This problem will occur everytime you attempt to install or import(full repository) a Designer Repository against 8.1.7.0.0 of the Oracle Server. The exception to this is Designer 6i release 2 which has a workaround to the bug applied to its code. This workaround will be introduced to a future Designer 6.0 patchset. Possible Symptoms ~ When the script CIUEET.OPB is fired by the Repository Adminstration Utility (RAU), the database server will show 100% CPU usage and the database will hang indefinitely. The database will also hang if a full repository import is attempted, as the package cioue_element_type(orginal created by the CIUUET.OPB script) will be executed. Workaround ~~ Use 8.1.6 of the Oracle Server. Patches ~~~ However, a workaround has been introduced in the Designer 6i Release 2 code to get past the plsql problem. This release has been certified. For Designer 6.0 the code change has been introduced in Designer 6.0.3.11.0 (patchset 7). References ~~ Bug:1396675 Bug:1528667 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re:RE: RE: Oracle DBA evolution path - please share your opi
Title: RE: Re:RE: RE: Oracle DBA evolution path - please share your opi ---snip--- OK then, since you were including all the employees, and since you didn't mention Quest in your list of companies, I'll forgive you. But just in case you didn't know, the main source of the problems you encounter is those people in Marketing and Sales. :-) ---snip--- Passing the buck huh?;) I don't believe that ALLSales Marketing staff are theprimary problem when it comes to getting an intuitive, well coded,widely functional database product in the market place! Me, myself, and I all work as a Sales Marketing Exec for RDBMS performance tools, and I can say from past and present experience that we are just handed the tool, and told to market and sell it.From time to time we may get asked for opinions on software, but hey - who listens toSales Marketing - we're just the drive by gunmen that are sharks looking for a sale right? NOT TRUE!I keep in constant contact with prospects AND customers! A good software company has theright MANAGEMENT in place. It is not about the certain areas of the company, and the internal pettiness that can occur between these departments. The key to success IMHO, is to have a management team in place that can keep all areas of a business in touch with each other, working together - to come up with a product that will go down like a storm in the market! RD have to realise that it is the frontline (Sales Marketing) who are talking to the customers day in and day out, and are in fact the ones that are told day in and day out what a performance tool "should" do, and hey - that is this ultimate goal - to deliver a product to the market that the USER wants to use! How often have you heard of developers talking to customers? We work very closely with customers and prospects alike. Our main aim is to deliver a product to the customers desktop that they WILL use day in day out.. If that means that we spend a maximum of a day on site, installing and configuring the product - whilst training the customer - so be it. I would rather have a happy customer, than one shouting down my ear that the tools have crashed and the database is down. And hey, what's a day right? To conclude - it is not mainly marketing sales that are the problem, it is a break down of communication within these companies that cause the problems! That's why when you have a small close knit company, they can produce really cool products, that match what the customer wants, and needs! Then these small companies get acquired (because of their great new technology), by corporations who throw the product in to the pile, and the breakdown of communication starts there, and so does the breakdown of the product! Does this mean it is a collective failure of all groups? Maybe. Or could it be the failing of the management structure trying to hold all of this in place, strongly defending his/her own little "Castle"? That is more my feeling.. Just my £0.02 Mark P.S Damn I need a coffee now, where's my mug disappeared to?
NLS_DATE_FORMAT not effective..help!
Hi Gurus, We want to change the default date format of oracle from 'dd-mon-yy' to 'MM/DD/' format for one of our database ( 8.1.6 ). I have set NLS_DATE_FORMAT as "MM/DD/" (also tried for year!) in init file. It doesn't seems to have any effect when i query sysdate (SQL PLUS) from a client PC (Win 95 / Oracle 8 client / SQL PLUS) . Still in SQL PLUS it is displaying the date as 20-MAR-01 ( default format - dd-mon-yy) Ofcourse, after modifying, i bounced the db and listener. Interesting thing is when i query sysdate from SQLPLUS of my server (where Oracle is installed ), it is giving me the date as SELECT SYSDATE FROM DUAL; 03/20/200 ( it should be 03/20/2001 ) What went wrong? Did anyone faced similar problem? Do i need to modify registry in client PCs ( Win 9X)...?? Thank You. Arul. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Recipes, as promised
That sounds great! Could you please translate this to European measures? TIA, Sonja -Original Message- Sent: Monday, March 19, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Man, I am going to have to climb more mountains. -Original Message- Sent: Saturday, March 17, 2001 8:25 AM To: Multiple recipients of list ORACLE-L Unlike Mark, I cannot translate the measurements into metric. Note that I AM a chocoholic, dark chocolate to be precise, and even *I* cannot eat more than a thin slice of the chocolate mousse cake at any one sitting. What I really like about these recipes is that they are flourless -- so I can make them for Passover. Enjoy! CHOCOLATE MOUSSE CAKE Ingredients: 1/2 lb unsweetened chocolate (8 squares) 1/2 lb sweet butter cut into cubes, plus butter for greasing the pan 8 egg yolks (large eggs) 1 1/4 cups sugar 5 egg whites 1 tsp powdered cocoa (optional) 1 tsp confectioners sugar (optional) Instructions: 1. Preheat oven to 350. 2. Put chocolate squares and butter in saucepan, set in skillet of boiling water. Keep water at simmer, stir chocolate butter until chocolate is melted. Let cool slightly. 3. Combine egg yolks sugar in bowl of electric mixer. Beat until mix is light lemon-colored. 4. Add chocolate sauce to egg mixture, stirring to blend thoroughly. 5. Beat whites until stiff but not brittle. If whites are too stiffly beaten they will not fold properly. 6. Add 1/2 egg whites mixture to chocolate mixture beat. Fold in remaining whites. 7. Butter bottom sides of 8" springform pan, pour 3/4 of mixture into pan. Set remaining chocolate mixture aside (will be used as filling frosting) -- I refrigerate this until I need it 8. Place pan in oven bake 1 hr and 15 min. 9. When cake is done, transfer to rack, let stand about 10 min. Remove rim from springform pan. Let cake stand until thoroughly cool. 10. Spoon a portion of reserved, uncooked chocolate mixture around sides of cake like icing, build up slightly around top of cake. 11. Spoon remaining mix on top of cake smooth it. 12. Hold small sieve over cake spoon cocoa into it. Sprinkle it evenly over top of cake, chill briefly. Add confectioners sugarto sieve and sprinkle over top of cake. Keep refrigerated. NEW YORK CHEESECAKE Ingredients: 2 lbs cream cheese at room temperature 1 tsp pure vanilla 1 cup sugar 4 large eggs at room temperature Instructions: 1. Preheat oven to 350. Arrange a rack 1/3 up from the bottom of the oven. 2. Butter 8" springform pan, 3" deep. Butter rim of pan. Place circle of waxed paper cut to fit bottom of pan into pan and butter it as well. 3. Beat cream cheese until smooth, scraping sides and bottom of bowl. 4. Add vanilla, salt and sugar. Blend until thoroughly mixed with no lumps. 5. Start beating at moderate speed, add eggs one at a time, beating briefly after each addition, do not overbeat. 6. Pour mixture into pan. 7. Place springform pan into larger pan fill larger pan with hot water halfway up the sides of the springform pan (about 1 1/2" deep). 8. Place pans in oven bake 1 1/2 hr. Cake will rise above the rim of the pan about 1/4". Top of cake should be lightly browned. 9. Remove pan from water cool on rack 2-3 hours. Cake will sink back to original level. 10. Refrigerate until cold, then unmold. Keep refrigerated. Note: It's REALLY important to do the last 2 steps or you are eating cheesecake pudding :) _ Get your FREE download of MSN Explorer at http://explorer.msn.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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want
Re: NLS_DATE_FORMAT not effective..help!
Yea, to see it on a clint's SQL*Plus You have to modify \Hkey_local_machine\software\oracle\NLS_DATE_FORMAT At least this is on NT, I don't know about 95, 98 Gints Plivna Arul kumar rakumar@mahinTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] drabt.comcc: Sent by: Subject: NLS_DATE_FORMAT not effective..help! [EMAIL PROTECTED] om 01.03.20 10:36 Please respond to ORACLE-L Hi Gurus, We want to change the default date format of oracle from 'dd-mon-yy' to 'MM/DD/' format for one of our database ( 8.1.6 ). I have set NLS_DATE_FORMAT as "MM/DD/" (also tried for year!) in init file. It doesn't seems to have any effect when i query sysdate (SQL PLUS) from a client PC (Win 95 / Oracle 8 client / SQL PLUS) . Still in SQL PLUS it is displaying the date as 20-MAR-01 ( default format - dd-mon-yy) Ofcourse, after modifying, i bounced the db and listener. Interesting thing is when i query sysdate from SQLPLUS of my server (where Oracle is installed ), it is giving me the date as SELECT SYSDATE FROM DUAL; 03/20/200 ( it should be 03/20/2001 ) What went wrong? Did anyone faced similar problem? Do i need to modify registry in client PCs ( Win 9X)...?? Thank You. Arul. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
If-statement
Hallo, Do you have any good example on how to write a procedure, that checks if there is a ? in a column in tna table in te database. If it is a ? then it will be put a "0" in the place where it is a ?. If it is not a ? then it will be the no change in that place. Please help me with this Roland Skldblom -- 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: Recipes, as promised
Ingredients: 1/2 lb (8oz/230g) unsweetened chocolate (8 squares) 1/2 lb (8oz/230g) sweet butter cut into cubes, plus butter for greasing the pan 8 egg yolks (large eggs) 1 1/4 (Again this around 8oz/230g) cups sugar 5 egg whites (5 jumbo sized super chicken eggs) 1 tsp powdered cocoa (optional) 1 tsp confectioners sugar (optional) Preheat oven to gas mark 4 (180c) -Original Message- Sehovic Sent: Tuesday, March 20, 2001 10:21 To: Multiple recipients of list ORACLE-L That sounds great! Could you please translate this to European measures? TIA, Sonja -Original Message- Sent: Monday, March 19, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Man, I am going to have to climb more mountains. -Original Message- Sent: Saturday, March 17, 2001 8:25 AM To: Multiple recipients of list ORACLE-L Unlike Mark, I cannot translate the measurements into metric. Note that I AM a chocoholic, dark chocolate to be precise, and even *I* cannot eat more than a thin slice of the chocolate mousse cake at any one sitting. What I really like about these recipes is that they are flourless -- so I can make them for Passover. Enjoy! CHOCOLATE MOUSSE CAKE Ingredients: 1/2 lb unsweetened chocolate (8 squares) 1/2 lb sweet butter cut into cubes, plus butter for greasing the pan 8 egg yolks (large eggs) 1 1/4 cups sugar 5 egg whites 1 tsp powdered cocoa (optional) 1 tsp confectioners sugar (optional) Instructions: 1. Preheat oven to 350. 2. Put chocolate squares and butter in saucepan, set in skillet of boiling water. Keep water at simmer, stir chocolate butter until chocolate is melted. Let cool slightly. 3. Combine egg yolks sugar in bowl of electric mixer. Beat until mix is light lemon-colored. 4. Add chocolate sauce to egg mixture, stirring to blend thoroughly. 5. Beat whites until stiff but not brittle. If whites are too stiffly beaten they will not fold properly. 6. Add 1/2 egg whites mixture to chocolate mixture beat. Fold in remaining whites. 7. Butter bottom sides of 8" springform pan, pour 3/4 of mixture into pan. Set remaining chocolate mixture aside (will be used as filling frosting) -- I refrigerate this until I need it 8. Place pan in oven bake 1 hr and 15 min. 9. When cake is done, transfer to rack, let stand about 10 min. Remove rim from springform pan. Let cake stand until thoroughly cool. 10. Spoon a portion of reserved, uncooked chocolate mixture around sides of cake like icing, build up slightly around top of cake. 11. Spoon remaining mix on top of cake smooth it. 12. Hold small sieve over cake spoon cocoa into it. Sprinkle it evenly over top of cake, chill briefly. Add confectioners sugarto sieve and sprinkle over top of cake. Keep refrigerated. NEW YORK CHEESECAKE Ingredients: 2 lbs cream cheese at room temperature 1 tsp pure vanilla 1 cup sugar 4 large eggs at room temperature Instructions: 1. Preheat oven to 350. Arrange a rack 1/3 up from the bottom of the oven. 2. Butter 8" springform pan, 3" deep. Butter rim of pan. Place circle of waxed paper cut to fit bottom of pan into pan and butter it as well. 3. Beat cream cheese until smooth, scraping sides and bottom of bowl. 4. Add vanilla, salt and sugar. Blend until thoroughly mixed with no lumps. 5. Start beating at moderate speed, add eggs one at a time, beating briefly after each addition, do not overbeat. 6. Pour mixture into pan. 7. Place springform pan into larger pan fill larger pan with hot water halfway up the sides of the springform pan (about 1 1/2" deep). 8. Place pans in oven bake 1 1/2 hr. Cake will rise above the rim of the pan about 1/4". Top of cake should be lightly browned. 9. Remove pan from water cool on rack 2-3 hours. Cake will sink back to original level. 10. Refrigerate until cold, then unmold. Keep refrigerated. Note: It's REALLY important to do the last 2 steps or you are eating cheesecake pudding :) _ Get your FREE download of MSN Explorer at http://explorer.msn.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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
Re: FK Constraints
Rachel Carmichael wrote: the DBA is not responsible for the data?? Could you PLEASE come to my office and explain that (I'll bring the heavy club) to my developers, users and management? They seem to believe that my primary function is to dig information out of the database for them. Backup and recovery? Capacity planning? Why on earth would I want to do THAT? you sure we don't work of rhte same company?;-) [don't i just wish.;-)] and then there's [at 10AM] "oh bill we need a new ORACLE instance up and running for us." "ok, when do you need it by?" "noon." -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
Rachel Carmichael wrote: but Moom, the icky bugs TOUCHED the chocolate! :) just think of it as "quality protein". and yes i have munched a bug or to, with and without the chocolate.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: maintaining a backup table on another server
Thanks for the reply Jacques. I need to insert quite a bit of data (say 300-400 rows), and would like to perform the inserts as the data is collected. I would like to have the two server connections open at once. Otherwise, I would need to buffer the data and update each server separately. The speed factor is critical in this situation. I am also looking into using "runtime contexts" in a multithreaded application. Not sure if this approach is viable. John Armani [EMAIL PROTECTED] From: Jacques Kilchoer [EMAIL PROTECTED] Date: Mon, 19 Mar 2001 11:04:56 -0800 Subject: RE: maintaining a backup table on another server See my answer below. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] We have a single table that contains audit information, and would like to create an identical table on a separate server that we will update at the same time we update the primary server table. Multiple primary servers could exist throughout the system, and a common backup server could be shared by multiple primary servers. The inserts, updates, and deletes would be done from pro*c library routines that would exist on client machines. A simple solution would be to create a database link to the backup table, and whenever we update the primary table we will send a second update to the backup table (via the database link). This approach works fine as long as the servers are up, but raises issues in the case if one or both is down at update time. What other alternatives can we look into? Is the Parallel Server concept an overkill? If I understand your situation correctly, you want an application to update two tables in two different Oracle databases (that we will call A and B). If you use a database link from A to B, when A is down, this will prevent both updates, which is your concern. Why not have the application open two different connections - one to A and one to B? I'm pretty sure that it's possible in Pro*C. -- any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer. Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. -- 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).
DBMS_OUTPUT.PUT_LINE
Hello, Anyone who has a suggestion how to write the DBMS_OUTPUT.PUT_LINE command if I want to display the numbers of inserts done in that script? Would appreciate it very much if anyone could help.. Roland Skldblom -- 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: FK Constraints
Ramani: I live daily with the negative effects of referential integrity enforced (sometimes) at the application level. From my standpoint, there have been no "pros" to this method. I need to use a lot of data from our mainframe DB2 database, where all of the RI is written into their applications. Now I access the data from another avenue - Oracle's transparent gateway - and there is no way for me to tell what tables should join, what the valid values are, and even what codes within a column represent! Of course, when they designed this database 10 years ago, they never took into consideration that another database would access this data; they only thought that their COBOL programs would touch the data. Years later, programmers have moved on, the world has changed, but their database stays the same. The have one huge LOV table where they store codes based on what program/screen needs them (as far as I can figure). This entire design shows a lack of vision. Sorry to ramble, but this is a sore point with me. The bottom line here is that every time someone else needs to access the data, it takes at least 5 times longer to understand the relationships and make things work. And, we are never sure that what we are getting is right. I have at least 20 scientists accessing this data. Imagine not only the productivity that is lost, but can we be sure that the results produced from the analysis of this data is correct based on its lack of credibility? I would never, ever, ever, ever agree to a database without referential integrity imposed by the RDBMS that was in my control. I thank you for the opportunity to vent (-_-) ___ Sherrie Kubis Southwest Florida Water Management District 2379 Broad Street Brooksville FL 34604-6899 Phone: (352) 796-7211, Ext. 4033 Fax: (352) 754-6776 Email: Mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: If-statement
Hi Try using Translate function [EMAIL PROTECTED] wrote: Hallo, Do you have any good example on how to write a procedure, that checks if there is a ? in a column in tna table in te database. If it is a ? then it will be put a "0" in the place where it is a ?. If it is not a ? then it will be the no change in that place. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 find SEQUENCE#
Thank you Christian, That's almost what I was looking for. One issue - it doesnt work when I replace unrecoverable file with fresh hot copy. Vadim -Original Message- Sent: Tuesday, March 20, 2001 2:55 AM To: Multiple recipients of list ORACLE-L So rely on v$log_history. Regards. -Mensaje original- De: Vadim Gorbounov [SMTP:[EMAIL PROTECTED]] Enviado el: lunes 19 de marzo de 2001 21:11 Para: Multiple recipients of list ORACLE-L Asunto: How to find SEQUENCE# Hi, DBAs, Can anybody give me a guess, how to find out next log SEQUENCE#, required for recovery, without issuing RECOVER command? I believe, this is not possible to find it out of Oracle dictionary, can anybody confirm this or, otherwise, name appropriate fixed table? I'm particularly concerned with standby database recovery, I want to know in advance SEQUENCE#, required to roll forward, and don't want to rely on alertXXX.log tail. Another question, in "normal" database I can find correspondence between CHANGE# and log SEQUENCE# from v$archived_log or v$log. Where to look this correspondence in standby database. Thanks for Your Help Vadim Gorbounov Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Trassens, Christian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: If-statement
You don't have to use any if's, but use translate function: update Your_table set Your_column = translate(Your_column,'?','0'); HTH Jorma -Original Message- From: ext [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 20 March, 2001 13:41 To: Multiple recipients of list ORACLE-L Subject: If-statement Hallo, Do you have any good example on how to write a procedure, that checks if there is a ? in a column in tna table in te database. If it is a ? then it will be put a "0" in the place where it is a ?. If it is not a ? then it will be the no change in that place. Please help me with this Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
Kirti, I'd have to be truly desperate to eat chocolate that bugs had touched :) Of course, most American milk chocolate has a high wax content, which is why I prefer Europrean milk chocolate. Bittersweet rules totally though, wherever it's made Rachel From: "Deshpande, Kirti" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Mon, 19 Mar 2001 17:45:34 -0800 But, it's still food. YOUR favorite.. just close your eyes and keep that water handy... -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 6:11 PM To: Multiple recipients of list ORACLE-L Subject:RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe but Moom, the icky bugs TOUCHED the chocolate! :) From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Mon, 19 Mar 2001 13:45:29 -0800 You could just lick the chocolate off. -Original Message- Sent: Monday, March 19, 2001 10:11 AM To: Multiple recipients of list ORACLE-L shudder I have a phobia about bugs... what a waste of perfectly good chocolate From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Mon, 19 Mar 2001 09:11:20 -0800 OK you chocaholics try this on for size: Reuters Monday, March 19, 2001 Chocolate-Coated Bugs Are Latest Treat LONDON (Reuters) - Ants, crickets and scorpions, baked, coated in chocolate and promoted as a high-protein snack, are proving popular among peckish Londoners. Designer Todd Dalton, who trained as a chef in Louisiana and acquired a taste for cooked insects on his travels in Asia and central America, says he has sold 5,000 chocolate-coated bugs since he began marketing them in December. "They are very high in protein and very low in fat. They have a higher percentage of protein than any meat or fish that we commonly eat," he told Reuters. The creepy-crawly chocs sell for between three and 3.50 pounds ($4.30-$5.00) at upmarket London stores such as Selfridges and the Conran Shop and will soon be appearingin shops in Munich and Zurich. -- -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.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).
ops on linux
Has anyone here installed ops on linux? ( oralce 8.1.7.0.1) I just could not start the related daemons by using $ORACLE_HOME/oracm/bin/ocmstart.sh. The machine just hanged every time I ran ocmstart.sh. Any suggestions? Thanks in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
rhubarb flavored rock I'm working on a tentative assumption here that you don't mean actual rocks... translation please! From: lerobe - Lee Robertson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Tue, 20 Mar 2001 00:05:25 -0800 Been drinking it in the UK for most of my 37 years !!! Used to be a plain old pick me up for years (if you ever had to go into hospital or indeed went visiting, you were either given or giving a bottle). Nowadays it is used by sportsmen etc for exactly what you have described. Regards Lee (one of the original Lucozade kids) PS. This was one of my mothers cravings when she was pregnant with me - however she could only drink it whilst eating rhubarb flavoured rock - WEIRD !! -Original Message- Sent: 19 March 2001 20:41 To: Multiple recipients of list ORACLE-L Speaking of sugar... I just returned from Trinidad (on a mission trip to build a church in Toco). While working in the 95 degree sun all day we often walked up to the corner store and bought water and cokes (the coca cola was much sweeter there than in the US, but also less carbonated). What we also found was a product called Lucozade (http://www.lucozade.com/). This was a sport drink essentially made of glucose syrup. From their website - "When you drink it, the glucose gets rapidly absorbed into your bloodstream and gives you a quick burst of energy. Glucose is the natural preferred fuel for the body becuase of the speed with which it can be digested and absorbed. Once absorbed it is a readily available source of fuel, whic all cells of the body can utilise." Official drink of on-call DBAs. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack C. Applewhite Sent: Monday, March 19, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Kimberley, I'd be surprised if you can get "real" raw sugar in stores. When I was in the U.S. Peace Corps in Belize in the mid '70s, raw sugar was readily available, since sugar was a primary export from that beautiful little country. If you let a couple of pounds of raw sugar sit in a brown paper bag for a day or two, the molasses would settle to the bottom and puddle - a jar, shaken occasionally, was a better storage option. It was delicious! There's nothing quite like a peanut butter and raw sugar sandwich! Ironically, the Belizians preferred refined, white sugar, since it was considered more "upscale" than the raw sugar. BTW, other advantages to living in a sugar-exporting country included very cheap soft drinks and rum!...Oh, and Reggae! ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Kimberly Smith Sent: Monday, March 19, 2001 9:33 AM To: Multiple recipients of list ORACLE-L Recipe Hey, found out that muscavado sugar is raw sugar. Hopefully I can find it in the stores. If not I am going to Second Cup and "borrowing" a whole bunch of little packets;-) 375g dark muscovado sugar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be
Re:RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Re
Rachel, If you were given one, as I was in Nam, you'd not know the difference. Looks like, tastes like a crunch bar for the most part, except for the logo on top. It just crunches better. Dick Goulet Reply Separator Author: "Rachel Carmichael" [EMAIL PROTECTED] Date: 3/19/2001 4:10 PM but Moom, the icky bugs TOUCHED the chocolate! :) From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Mon, 19 Mar 2001 13:45:29 -0800 You could just lick the chocolate off. -Original Message- Sent: Monday, March 19, 2001 10:11 AM To: Multiple recipients of list ORACLE-L shudder I have a phobia about bugs... what a waste of perfectly good chocolate From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Mon, 19 Mar 2001 09:11:20 -0800 OK you chocaholics try this on for size: Reuters Monday, March 19, 2001 Chocolate-Coated Bugs Are Latest Treat LONDON (Reuters) - Ants, crickets and scorpions, baked, coated in chocolate and promoted as a high-protein snack, are proving popular among peckish Londoners. Designer Todd Dalton, who trained as a chef in Louisiana and acquired a taste for cooked insects on his travels in Asia and central America, says he has sold 5,000 chocolate-coated bugs since he began marketing them in December. "They are very high in protein and very low in fat. They have a higher percentage of protein than any meat or fish that we commonly eat," he told Reuters. The creepy-crawly chocs sell for between three and 3.50 pounds ($4.30-$5.00) at upmarket London stores such as Selfridges and the Conran Shop and will soon be appearingin shops in Munich and Zurich. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.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: INET: [EMAIL PROTECTED] Fat City Network Services
RE: If-statement
Not worth all the effort. select translate(te.tna,'?','0') from dual; done deal. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 6:41 AM To: Multiple recipients of list ORACLE-L Subject:If-statement Hallo, Do you have any good example on how to write a procedure, that checks if there is a ? in a column in tna table in te database. If it is a ? then it will be put a "0" in the place where it is a ?. If it is not a ? then it will be the no change in that place. Please help me with this Roland Skoldblom -- 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: William Rogge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lemon Juice in Ants Pooh-Poohed
Can't the list members PUH-LEEZE stick (mostly) to messages germane to the purpose of this list? I don't mind the occasional off-topic post, but, for crying out loud, how about a little restraint? The original recipe posting(s) have given rise to a plethora of messages about chocolate, sugar, ants, travel, etc. etc. I open list messages as they arrive and I don't appreciate the cumulative waste of my time in reading all of this nonsense. If you all MUST ventilate at length about eating chocolate-covered ants, let's adopt a convention of including "OFF-TOPIC" in the message header, at least, so it's possible to filter them out. And no, I am not a grouch, curmudgeon, in need of lightening up, etc. Sometimes enough is enough, already. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: NLS_DATE_FORMAT not effective..help!
Just create a Database on-logon trigger and setup the date as you want it. Then providing any "client" does not do an alter session you will have a standard DB date format. -Original Message- Sent: 20 March 2001 08:36 To: Multiple recipients of list ORACLE-L Hi Gurus, We want to change the default date format of oracle from 'dd-mon-yy' to 'MM/DD/' format for one of our database ( 8.1.6 ). I have set NLS_DATE_FORMAT as "MM/DD/" (also tried for year!) in init file. It doesn't seems to have any effect when i query sysdate (SQL PLUS) from a client PC (Win 95 / Oracle 8 client / SQL PLUS) . Still in SQL PLUS it is displaying the date as 20-MAR-01 ( default format - dd-mon-yy) Ofcourse, after modifying, i bounced the db and listener. Interesting thing is when i query sysdate from SQLPLUS of my server (where Oracle is installed ), it is giving me the date as SELECT SYSDATE FROM DUAL; 03/20/200 ( it should be 03/20/2001 ) What went wrong? Did anyone faced similar problem? Do i need to modify registry in client PCs ( Win 9X)...?? Thank You. Arul. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Martin Kendall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Insert without telling column names
Hallo, How can I create an insert statement without telling all the names of the columns? Give an example, please. Roland Skldblom -- 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:RE: Re:RE: RE: Oracle DBA evolution path - please share y
Well, Since I started this I guess I'll wade back in, but I'll save everyone some bandwidth in the process. To Jaques (sorry I don't think I spelled that right) point and Mike's too most of the rotten third party software I've seen does have a BAD management team behind it in one way or the other. Sometimes it's a lack of management that causes the problem and sometimes a "we've got to get this to market" attitude within the management team that causes the problem. From the Sales Marketing side I'd criticize those who have tried to push software at us that they themselves did not know what it did or what the benefit to us would be. It's great to market technology, but if your customer sees no benefit what's the sense. Most of the "canned" demos I've seen are not applicable to our business. We here do not do business over the web for the most part therefore don't come in here with a demo designed to impress and show the value of software to an E-business company, I need to talk to robots on an assembly floor. From the support/development side, the impression I constantly get is that "our application can only run standalone". BULL, in this day and age interconnecting one application to another is absolutely vital. And whereas I understand you cannot provide that interface for all possible combinations at least give me the ability to build that without having to go through hell 5 times over. Also I understand that there are locations you need to install in where a technically competent staff does not exist, but there are locations where there is a competent staff so make the install procedures a two part thing which one may or may not choose to use. Also, If you ask me to create an empty database with orainst understand what that means don't go back around the flag pole. The last thing I'd LOVE to see in third party apps is to finally get the use of ANSI standard SQL all over the place. This use of case sensitive object names of those with special characters where you always have to imbed the object in double quotes is an exception and should be banned. One other thing, when I do get to support people, don't patronize me. There is nothing I HATE more than being told "you obviously don't know what your doing" when the reverse is true. Case in point, many apps tell you to create the schema users by "grant connect, dba to magic". I always ask, why do you folks still use the OLD syntax. I've been told that that's the only way, that "create user" is not supported by Oracle. HUH??? who doesn't know that their doing. Now for the two who have gotten into this the most, I've demo'd a couple of tools from Quest, not bad I actually liked them and they did behave as I'd expect. They're still on my list of potential vendors, especially now that CA has most of the remainder of the good vendors under their umbrella. Cool-Tools I have had no experience with so since the jury hasn't heard that case yet the door is open. -- 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: FK Constraints
Rachel, One way I got this across to my developers and users was in creating new users for the DB. Every time I got a new user request, I would forward it to the director of the group that officially "owns" the data to get his permission to allow them in HIS data. After a few round robins of this the people finally realized that when I said Ops, Acctg, etc. owned the data, I also made them responsible for THEIR data. We still have fun every now and then with "Can you recover this for me" type reqests, but most of the time they recognize that I keep the system going and they keep the data correct. On Monday 19 March 2001 18:10, you wrote: the DBA is not responsible for the data?? Could you PLEASE come to my office and explain that (I'll bring the heavy club) to my developers, users and management? -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oracle training
what's a favored source for training? === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Streeter, Lerone A LBX INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ITL and possible deadlocks
Hello List, it's rather a theoretical question. Let say two sessions update a table. Each transaction allocated a transaction slot in a block (I consider the two different blocks). Each block has only one slot and there is no free space in these blocks to allocate additional transaction slots. Then each transaction tryes to update a row in the block which has already been updated by the other transaction. How Oracle to do with such situation in case when there is no access to a common resource (I mean a common row) ? Thanks in advance Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBMS_OUTPUT.PUT_LINE
I looked at the documentation and could not see a function giving that . But you can declare a variable and increase it after each insert ( if you do the inserts in a loop , it is good). Then dbms_output.put_line(variable_name); Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 3:50 PM Hello, Anyone who has a suggestion how to write the DBMS_OUTPUT.PUT_LINE command if I want to display the numbers of inserts done in that script? Would appreciate it very much if anyone could help.. Roland Skldblom -- 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: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lemon Juice in Ants Pooh-Poohed
Kevin, Kevin, Kevin... Don't diss my Cave Crickets. Are you sure they're cave crickets? (They're not even crickets! They're related to the grasshopper) Are the antenea as long as the rest of the body? And even if they are Cave Crickets, they won't bother you. They just come out of the cave to feed. Kevin Toepke Caver and Semi-professional, Semi-competent DBA-type guy P: 614/652-5117 F: 614/652-5401 - The information in this electronic mail message is Cendant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. - The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. - -Original Message- Sent: Tuesday, March 20, 2001 8:26 AM To: Multiple recipients of list ORACLE-L It doesn't matter if they give off a sweet lemony aroma, I am thinking I don't want to eat ants!! The only time I would eat ants is if I was stranded somewhere and had no food. See, I really don't like insects, they bother me, not all of them. A lot of ants sickens me, I am terrified of spiders BIG TIME!! Also, here in Jersey, we have these bugs, they are called cave crickets I believe. Oh man do they freak me out, they look like a mix of a big spider and a cricket!! They jump about 3 feet in the air and are by far one of the ugliest things I have ever seen. I won't go in a room if I know one is in there, I know they can't hurt me, but it's just a phobia. Sorry for getting so far off of the topic! Kev snipsnipouch!snipThat HURTS! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin 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).
RE: Lemon Juice in Ants Pooh-Poohed
Title: RE: Lemon Juice in Ants Pooh-Poohed Paul, I agree with you: enough is enough. Post a recipe and get it out of your system. Kwitcherbitchin'. G Any thoughts on the evolution or travel patterns of sugar/chocolate coated arthropods who have chosen database clerking as a career? I gotcher foreign constraints right *here*, buddy. Ross p.s. btw, I have to build a database with special NLS needs to track ant colonies near chocolate factories and my developers think i am responsible for the data but I am not, am I? Also, I want to convert man files into text for InterMedia into the database using FK constraints. Can anyone help me? Oh, please it's urgent -Original Message- From: Paul Baumgartel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 9:31 AM To: Multiple recipients of list ORACLE-L Subject: RE: Lemon Juice in Ants Pooh-Poohed Can't the list members PUH-LEEZE stick (mostly) to messages germane to the purpose of this list? I don't mind the occasional off-topic post, but, for crying out loud, how about a little restraint? The original recipe posting(s) have given rise to a plethora of messages about chocolate, sugar, ants, travel, etc. etc. I open list messages as they arrive and I don't appreciate the cumulative waste of my time in reading all of this nonsense. If you all MUST ventilate at length about eating chocolate-covered ants, let's adopt a convention of including OFF-TOPIC in the message header, at least, so it's possible to filter them out. And no, I am not a grouch, curmudgeon, in need of lightening up, etc. Sometimes enough is enough, already. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
-Original Message- Just keep the supply of Diet Coke coming. :) Make that "Tab", for me. -- 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: DBMS_OUTPUT.PUT_LINE
Roland,
The only trick with dbms_output.put_line is to set your serveroutput on.
The following is a sample script to be run in SQL*Plus. Warning: it's a
stupid script, you'd never want to do this in real life. :)
set serverout on
declare
cursor some_cursor is
select *
from some_table;
begin
for curRec in some_cursor loop
insert into another_table (col1, col2)
values (curRec.col1, curRec.col2);
dbms_output.put_line('Inserted ' || SQL%rowcount || '
rows.');
end loop;
end;
/
Diana
-Original Message-
Sent: Tuesday, March 20, 2001 8:51 AM
To: Multiple recipients of list ORACLE-L
Hello,
Anyone who has a suggestion how to write the DBMS_OUTPUT.PUT_LINE command
if I want to display the numbers of inserts done in that script?
Would appreciate it very much if anyone could help..
Roland Skldblom
--
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: Diana Duncan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Insert without telling column names
Roland, You can't. There are a number of ways to really cut down on the code required to do an insert, but if you think about it, how will Oracle know where the data is supposed to go if you don't give it the column name(at some point)? If you're using 8i, there is a direct load insert, but as far as I'm aware, this will work only for a select * from another table. Dynamic SQL works pretty well for this kind of stuff. What are you trying to do? Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth [EMAIL PROTECTED] wrote: Hallo, How can I create an insert statement without telling all the names of the columns? Give an example, please. Roland Skldblom -- 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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
ermI don't know how this travels. Like a sugary candy which is extremely hard, you do have candy canes in the States for Christmas trees etc ?? Sort of thicker, straighter version and normally minty in the UK - very popular at Seaside resorts where the sweet is manufactured with the name of the resort printed all the way through the middle. Oh God - this is sounding more weird, the more I try and describe it. Any other Brits who have lived/worked extensively in the States care to offer a better translation ?? Cheers Lee -Original Message- Sent: 20 March 2001 13:26 To: Multiple recipients of list ORACLE-L rhubarb flavored rock I'm working on a tentative assumption here that you don't mean actual rocks... translation please! From: lerobe - Lee Robertson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Tue, 20 Mar 2001 00:05:25 -0800 Been drinking it in the UK for most of my 37 years !!! Used to be a plain old pick me up for years (if you ever had to go into hospital or indeed went visiting, you were either given or giving a bottle). Nowadays it is used by sportsmen etc for exactly what you have described. Regards Lee (one of the original Lucozade kids) PS. This was one of my mothers cravings when she was pregnant with me - however she could only drink it whilst eating rhubarb flavoured rock - WEIRD !! -Original Message- Sent: 19 March 2001 20:41 To: Multiple recipients of list ORACLE-L Speaking of sugar... I just returned from Trinidad (on a mission trip to build a church in Toco). While working in the 95 degree sun all day we often walked up to the corner store and bought water and cokes (the coca cola was much sweeter there than in the US, but also less carbonated). What we also found was a product called Lucozade (http://www.lucozade.com/). This was a sport drink essentially made of glucose syrup. From their website - "When you drink it, the glucose gets rapidly absorbed into your bloodstream and gives you a quick burst of energy. Glucose is the natural preferred fuel for the body becuase of the speed with which it can be digested and absorbed. Once absorbed it is a readily available source of fuel, whic all cells of the body can utilise." Official drink of on-call DBAs. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack C. Applewhite Sent: Monday, March 19, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Kimberley, I'd be surprised if you can get "real" raw sugar in stores. When I was in the U.S. Peace Corps in Belize in the mid '70s, raw sugar was readily available, since sugar was a primary export from that beautiful little country. If you let a couple of pounds of raw sugar sit in a brown paper bag for a day or two, the molasses would settle to the bottom and puddle - a jar, shaken occasionally, was a better storage option. It was delicious! There's nothing quite like a peanut butter and raw sugar sandwich! Ironically, the Belizians preferred refined, white sugar, since it was considered more "upscale" than the raw sugar. BTW, other advantages to living in a sugar-exporting country included very cheap soft drinks and rum!...Oh, and Reggae! ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Kimberly Smith Sent: Monday, March 19, 2001 9:33 AM To: Multiple recipients of list ORACLE-L Recipe Hey, found out that muscavado sugar is raw sugar. Hopefully I can find it in the stores. If not I am going to Second Cup and "borrowing" a whole bunch of little packets;-) 375g dark muscovado sugar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
RE: Slow database
Maybe the "big" process is not doing intermittent commits, and is straining the rollback segments? Have you checked the growth and skew of your indices? Have you checked whether you can disable the indices while the process is running, then enable them? Is it doing inserts or updates or both? Does the code have scary SQL in it? Are you using SQL*Loader, and if not, why not? You may be able to do a "direct path" load. You need to take a look at the statistics for the SQL it is running to identify any poorly performing statements, then tune them. That will probably be the biggest bang for your buck. Sorry I can't be more explicit without more information... Diana -Original Message- Sent: Tuesday, March 20, 2001 2:26 AM To: Multiple recipients of list ORACLE-L Hallo all you experts, I have an Oracle database, every night it is read many files into the database, but all the procedures take so long, it keeps taking all the next day almost. It shouldnt do that, because the system is very slow because of this. When I run other things during the day, many things are slow, for instance when i delete 1000 rows it shouldnt take one hour, which it takes while the "big" process is running. Do you have any suggestion what I should do to trace the whole problem? When i delete 1000 rows during "low"-time, then it just take a few seconds to delete the records. Hope anyone can help me with suggestions. Roland Skldblom -- 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: Diana Duncan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How long will 8.0.6 be supported?
I can't get into Metalink. Can anyone tell me how long 8.0.6 will be supported? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBMS_OUTPUT.PUT_LINE
Roland - Depending on how your inserts are being generated, why don't you use a counter or the ROWCOUNT function? Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth "Bunyamin K.Karadeniz" wrote: I looked at the documentation and could not see a function giving that . But you can declare a variable and increase it after each insert ( if you do the inserts in a loop , it is good). Then dbms_output.put_line(variable_name); Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 3:50 PM Hello, Anyone who has a suggestion how to write the DBMS_OUTPUT.PUT_LINE command if I want to display the numbers of inserts done in that script? Would appreciate it very much if anyone could help.. Roland Skldblom -- 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: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Insert without telling column names
On Tue, 20 Mar 2001 [EMAIL PROTECTED] wrote: Hallo, How can I create an insert statement without telling all the names of the columns? Give an example, please. Roland Sköldblom Roland, You can omit column names only if you are inserting into all columns of the table, in the same order that they appear in the data dictionary. e.g. create table mytab ( col1 number, col2 date, col3 number); valid: insert into mytab values(1, sysdate, 2); invalid: insert into mytab values( 1, sysdate ); ERROR at line 1: ORA-00947: not enough values invalid: insert into mytab values( 1,2,sysdate); ERROR at line 1: ORA-00932: inconsistent datatypes Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Someone changed INTERNAL password URGENT
If you are on unix - you do not need internal password if you log in as member of dba group. On NT before 8.1 you need internal password but you can change it recreating password file or recreating instance using oradim. Alex Hillman -Original Message- From: Murali Vallath [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 9:18 AM To: Multiple recipients of list ORACLE-L Subject:Someone changed INTERNAL password URGENT URGENT, Someone changed the internal password. How do you connnect or change the internal password, if not able to find it? Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Someone changed INTERNAL password URGENT
There is not internal password, per se. If you are using unix, you need to be part of the DBA group to connect internal. I'm not sure how it works on NT. -Original Message- Sent: Tuesday, March 20, 2001 9:18 AM To: Multiple recipients of list ORACLE-L URGENT, Someone changed the internal password. How do you connnect or change the internal password, if not able to find it? Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How long will 8.0.6 be supported?
Oct 2001 -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Subject: How long will 8.0.6 be supported? I can't get into Metalink. Can anyone tell me how long 8.0.6 will be supported? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malkuns, Skip INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Insert without telling column names
Here is what my sqlplus training (Oracle) says: Inserting New Rows Insert a new tow containing values for each column. Optionally lisgt the columsn in the INSERT clause. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 9:31 AM Hallo, How can I create an insert statement without telling all the names of the columns? Give an example, please. Roland Skldblom -- 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
They do sweets over here - kind of like hard boiled sweets - or the famous British Rock - which is basically a long stick of hard sweet. The rhubarb sort is more commonly known to me in the form of a "Rhubarb Custard" flavoured sweet (small hard boiled kind of things :) Lucozade was another of my favourites when I was younger, but as Lee pointed out - I only EVER drink it now as an aid when I am flat on my back in bed ill! Sports people do use it as an energy giving drink - but the only sport I subscribe to is golf:) Mark -Original Message- Carmichael Sent: Tuesday, March 20, 2001 01:26 To: Multiple recipients of list ORACLE-L rhubarb flavored rock I'm working on a tentative assumption here that you don't mean actual rocks... translation please! From: lerobe - Lee Robertson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Tue, 20 Mar 2001 00:05:25 -0800 Been drinking it in the UK for most of my 37 years !!! Used to be a plain old pick me up for years (if you ever had to go into hospital or indeed went visiting, you were either given or giving a bottle). Nowadays it is used by sportsmen etc for exactly what you have described. Regards Lee (one of the original Lucozade kids) PS. This was one of my mothers cravings when she was pregnant with me - however she could only drink it whilst eating rhubarb flavoured rock - WEIRD !! -Original Message- Sent: 19 March 2001 20:41 To: Multiple recipients of list ORACLE-L Speaking of sugar... I just returned from Trinidad (on a mission trip to build a church in Toco). While working in the 95 degree sun all day we often walked up to the corner store and bought water and cokes (the coca cola was much sweeter there than in the US, but also less carbonated). What we also found was a product called Lucozade (http://www.lucozade.com/). This was a sport drink essentially made of glucose syrup. From their website - "When you drink it, the glucose gets rapidly absorbed into your bloodstream and gives you a quick burst of energy. Glucose is the natural preferred fuel for the body becuase of the speed with which it can be digested and absorbed. Once absorbed it is a readily available source of fuel, whic all cells of the body can utilise." Official drink of on-call DBAs. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack C. Applewhite Sent: Monday, March 19, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Kimberley, I'd be surprised if you can get "real" raw sugar in stores. When I was in the U.S. Peace Corps in Belize in the mid '70s, raw sugar was readily available, since sugar was a primary export from that beautiful little country. If you let a couple of pounds of raw sugar sit in a brown paper bag for a day or two, the molasses would settle to the bottom and puddle - a jar, shaken occasionally, was a better storage option. It was delicious! There's nothing quite like a peanut butter and raw sugar sandwich! Ironically, the Belizians preferred refined, white sugar, since it was considered more "upscale" than the raw sugar. BTW, other advantages to living in a sugar-exporting country included very cheap soft drinks and rum!...Oh, and Reggae! ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Kimberly Smith Sent: Monday, March 19, 2001 9:33 AM To: Multiple recipients of list ORACLE-L Recipe Hey, found out that muscavado sugar is raw sugar. Hopefully I can find it in the stores. If not I am going to Second Cup and "borrowing" a whole bunch of little packets;-) 375g dark muscovado sugar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services--
RE: Lemon Juice in Ants Pooh-Poohed
Paul, you are in deep trouble :-). Somebody will sure "remind" you in that you have delete button etc. Alex Hillman -Original Message- From: Paul Baumgartel [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 9:31 AM To: Multiple recipients of list ORACLE-L Subject:RE: Lemon Juice in Ants Pooh-Poohed Can't the list members PUH-LEEZE stick (mostly) to messages germane to the purpose of this list? I don't mind the occasional off-topic post, but, for crying out loud, how about a little restraint? The original recipe posting(s) have given rise to a plethora of messages about chocolate, sugar, ants, travel, etc. etc. I open list messages as they arrive and I don't appreciate the cumulative waste of my time in reading all of this nonsense. If you all MUST ventilate at length about eating chocolate-covered ants, let's adopt a convention of including "OFF-TOPIC" in the message header, at least, so it's possible to filter them out. And no, I am not a grouch, curmudgeon, in need of lightening up, etc. Sometimes enough is enough, already. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Just like Christmas
Kimberly, Enjoy the N class boxes, especially in 64 bit mode. They really cook compared to a K. Dick Goulet Reply Separator Author: Kimberly Smith [EMAIL PROTECTED] Date: 3/20/2001 8:15 AM Two brand spanking new N-Class servers arrived yesterday as I was leaving work. Sure look nicer then the K-Class's we currently run on. Can't wait to get my hands on it. Plus I got a brand new NT server just waiting for me as well (although its awfully hard to get excited about that one let me tell you). Kimberly Smith Database Administrator EDS - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lemon Juice in Ants Pooh-Poohed
Paul, you are in big trouble :-). Somebody will sure remind (with !) you that you have delete button. Alex Hillman -Original Message- From: Paul Baumgartel [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 9:31 AM To: Multiple recipients of list ORACLE-L Subject:RE: Lemon Juice in Ants Pooh-Poohed Can't the list members PUH-LEEZE stick (mostly) to messages germane to the purpose of this list? I don't mind the occasional off-topic post, but, for crying out loud, how about a little restraint? The original recipe posting(s) have given rise to a plethora of messages about chocolate, sugar, ants, travel, etc. etc. I open list messages as they arrive and I don't appreciate the cumulative waste of my time in reading all of this nonsense. If you all MUST ventilate at length about eating chocolate-covered ants, let's adopt a convention of including "OFF-TOPIC" in the message header, at least, so it's possible to filter them out. And no, I am not a grouch, curmudgeon, in need of lightening up, etc. Sometimes enough is enough, already. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS_OUTPUT.PUT_LINE
Won't that continuously print:
Inserted 1 rows.
Inserted 1 rows.
...
(well, as long as you don't get a primary/foreign key exception) :)
Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX
-Original Message-
Sent: Tuesday, March 20, 2001 10:11 AM
To: Multiple recipients of list ORACLE-L
Roland,
The only trick with dbms_output.put_line is to set your serveroutput on.
The following is a sample script to be run in SQL*Plus. Warning: it's a
stupid script, you'd never want to do this in real life. :)
set serverout on
declare
cursor some_cursor is
select *
from some_table;
begin
for curRec in some_cursor loop
insert into another_table (col1, col2)
values (curRec.col1, curRec.col2);
dbms_output.put_line('Inserted ' || SQL%rowcount || '
rows.');
end loop;
end;
/
Diana
-Original Message-
Sent: Tuesday, March 20, 2001 8:51 AM
To: Multiple recipients of list ORACLE-L
Hello,
Anyone who has a suggestion how to write the DBMS_OUTPUT.PUT_LINE command
if I want to display the numbers of inserts done in that script?
Would appreciate it very much if anyone could help..
Roland Skldblom
--
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: Diana Duncan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Jeffery Stevenson
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Someone changed INTERNAL password SOLVED..
We do not have a practice to give password for the internal account. So when it promoted it sounded like someone had assigned a password. Apparently there was a parameter SQLNET.AUTHENTICATION_SERVICES parameter added to the sqlnet.ora file. when I commented this out. It worked. Thanks for your help Murali Vallath Reply-To: [EMAIL PROTECTED] To: 'Murali Vallath ' [EMAIL PROTECTED] Date: Tue, 20 Mar 2001 10:30:16 -0600 Hi! If you are using windows nt... use orapw to re-change it... if you are using unix: you connect with svrmgrl!!! Hope this help! -Original Message- To: Multiple recipients of list ORACLE-L Sent: 3/20/01 8:17 AM URGENT, Someone changed the internal password. How do you connnect or change the internal password, if not able to find it? Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Free Oracle DBA tests on the web
Hi DBAs ! I'm looking for some FREE Oracle DBA / developer resources on the web : self-tests , OCP preparations materials , articles , books , etc ... Please share your resources ! Thanks a lot in advance . Andrey .
RE: Insert without telling column names
Title: RE: Insert without telling column names -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] How can I create an insert statement without telling all the names of the columns? Give an example, please. As Jared mentioned, if you are inserting into all the columns in a table, you don't need to specify the column names. But this is a BAD IDEA, because if someone adds a column to the table all your insert statements written without column names will fail unless you add values for the new column to the insert statement. So while this might be OK when typing in SQL for one-time use, don't use this method in any programs/scripts that will be used more than once. -- any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer. Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
RE: RE: RE: OT: Rachel in Vietnam
Title: RE: RE: RE: OT: Rachel in Vietnam Dick , Didn't you know? Rachel WAS in Nam. But she never talks about it. I think it had to do with the bugs. Just a thought. Ross -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 8:32 AM To: Multiple recipients of list ORACLE-L Subject: Re:RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Re Rachel, If you were given one, as I was in Nam, you'd not know the difference. Looks like, tastes like a crunch bar for the most part, except for the logo on top. It just crunches better. Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 3/19/2001 4:10 PM but Moom, the icky bugs TOUCHED the chocolate! :) From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Mon, 19 Mar 2001 13:45:29 -0800 You could just lick the chocolate off. -Original Message- Sent: Monday, March 19, 2001 10:11 AM To: Multiple recipients of list ORACLE-L shudder I have a phobia about bugs... what a waste of perfectly good chocolate From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Mon, 19 Mar 2001 09:11:20 -0800 OK you chocaholics try this on for size: Reuters Monday, March 19, 2001 Chocolate-Coated Bugs Are Latest Treat LONDON (Reuters) - Ants, crickets and scorpions, baked, coated in chocolate and promoted as a high-protein snack, are proving popular among peckish Londoners. Designer Todd Dalton, who trained as a chef in Louisiana and acquired a taste for cooked insects on his travels in Asia and central America, says he has sold 5,000 chocolate-coated bugs since he began marketing them in December. They are very high in protein and very low in fat. They have a higher percentage of protein than any meat or fish that we commonly eat, he told Reuters. The creepy-crawly chocs sell for between three and 3.50 pounds ($4.30-$5.00) at upmarket London stores such as Selfridges and the Conran Shop and will soon be appearingin shops in Munich and Zurich. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.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
RE: Someone changed INTERNAL password URGENT
Hi,
Pl. check in {ORACLE_HOME}/database directory there is a file
PWDSID NAME.ora.
Just move this file some where and try to connect.
Bye
-Original Message-
Sent: Tuesday, March 20, 2001 4:18 PM
To: Multiple recipients of list ORACLE-L
URGENT,
Someone changed the internal password. How do you connnect or
change the
internal password, if not able to find it?
Murali Vallath
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Murali Vallath
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Harsh Agrawal
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
Sorry Lee, it looks like Rachel is too much of a chocoholic to be up on her hard candy nomenclature. In the US its refered to as Rock candy, basically colored, flavored, crystaline sugar (sucrose, not glucose) available in various shapes and sizes though I haven't seen much of it lately. [It's probably gone the way of ribbon candy and other treats of yesteryear... (Norman Rockwell moment).] The most common US seaside confection is Saltwater taffy, or cotton candy. Confectionarily yours, Mike -Original Message- Sent: Tuesday, March 20, 2001 10:16 AM To: Multiple recipients of list ORACLE-L ermI don't know how this travels. Like a sugary candy which is extremely hard, you do have candy canes in the States for Christmas trees etc ?? Sort of thicker, straighter version and normally minty in the UK - very popular at Seaside resorts where the sweet is manufactured with the name of the resort printed all the way through the middle. Oh God - this is sounding more weird, the more I try and describe it. Any other Brits who have lived/worked extensively in the States care to offer a better translation ?? Cheers Lee -Original Message- Sent: 20 March 2001 13:26 To: Multiple recipients of list ORACLE-L rhubarb flavored rock I'm working on a tentative assumption here that you don't mean actual rocks... translation please! From: lerobe - Lee Robertson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Tue, 20 Mar 2001 00:05:25 -0800 Been drinking it in the UK for most of my 37 years !!! Used to be a plain old pick me up for years (if you ever had to go into hospital or indeed went visiting, you were either given or giving a bottle). Nowadays it is used by sportsmen etc for exactly what you have described. Regards Lee (one of the original Lucozade kids) PS. This was one of my mothers cravings when she was pregnant with me - however she could only drink it whilst eating rhubarb flavoured rock - WEIRD !! -Original Message- Sent: 19 March 2001 20:41 To: Multiple recipients of list ORACLE-L Speaking of sugar... I just returned from Trinidad (on a mission trip to build a church in Toco). While working in the 95 degree sun all day we often walked up to the corner store and bought water and cokes (the coca cola was much sweeter there than in the US, but also less carbonated). What we also found was a product called Lucozade (http://www.lucozade.com/). This was a sport drink essentially made of glucose syrup. From their website - "When you drink it, the glucose gets rapidly absorbed into your bloodstream and gives you a quick burst of energy. Glucose is the natural preferred fuel for the body becuase of the speed with which it can be digested and absorbed. Once absorbed it is a readily available source of fuel, whic all cells of the body can utilise." Official drink of on-call DBAs. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack C. Applewhite Sent: Monday, March 19, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Kimberley, I'd be surprised if you can get "real" raw sugar in stores. When I was in the U.S. Peace Corps in Belize in the mid '70s, raw sugar was readily available, since sugar was a primary export from that beautiful little country. If you let a couple of pounds of raw sugar sit in a brown paper bag for a day or two, the molasses would settle to the bottom and puddle - a jar, shaken occasionally, was a better storage option. It was delicious! There's nothing quite like a peanut butter and raw sugar sandwich! Ironically, the Belizians preferred refined, white sugar, since it was considered more "upscale" than the raw sugar. BTW, other advantages to living in a sugar-exporting country included very cheap soft drinks and rum!...Oh, and Reggae! ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Kimberly Smith Sent: Monday, March 19, 2001 9:33 AM To: Multiple recipients of list ORACLE-L Recipe Hey, found out that muscavado sugar is raw sugar. Hopefully I can find it in the stores. If not I am going to Second Cup and "borrowing" a whole bunch of little packets;-) 375g dark muscovado sugar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
Just like Christmas
Two brand spanking new N-Class servers arrived yesterday as I was leaving work. Sure look nicer then the K-Class's we currently run on. Can't wait to get my hands on it. Plus I got a brand new NT server just waiting for me as well (although its awfully hard to get excited about that one let me tell you). Kimberly Smith Database Administrator EDS - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Someone changed INTERNAL password URGENT
You can use the orapwd utility to recreate password file with new internal password. Rick -Original Message- From: Murali Vallath [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 9:17 AM To: Multiple recipients of list ORACLE-L Subject: Someone changed INTERNAL password URGENT URGENT, Someone changed the internal password. How do you connnect or change the internal password, if not able to find it? Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AUDITING - DEFAULT FOR CONNECT INTERNAL
Hi Folks , When I was tracing connect internal in sqlplus I came across this quirk and of course I have to investigate Guess what I found...: ) Bookmark Fixed font Go to End Doc ID: Note:107842.1 Audit Trail: Connect Internal Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 06-MAY-2000 Last Revision Date: 06-JUN-2000 Language: USAENG PURPOSE --- Assist in resolving why Application Log may be filling up, and/or why Events auditing connects are frequently written to the Application Log. SCOPE APPLICATION --- This article is intended for Oracle Support Analysts and Customers to assist in troubleshooting frequent connect events in the Application Log. Application Log is Full with Event ID 34 : Audit Trail: Connect Internal In Oracle8i on Windows NT, auditing can be configured so that audit trail actions are written to the Application Log in the Windows NT Event Viewer. These Events will be logged into the Application Log with Event ID 34. Most of these Events are not logged unless the INIT.ORA parameter AUDIT_TRAIL is set to either OS or DB. The default for this parameter is NONE. However, auditing of the Events for Connect Internal and/or Connect as SYSDBA or SYSOPER is enabled by default and cannot be disabled. Therefore, regardless of whether you have set the AUDIT_TRAIL parameter in the init.ora, Oracle will still log Events to the Event Viewer every time a Connect Internal or Connect as SYSDBA/SYSOPER occurs. What you will see in the Application Log in the Event Viewer is an Event with ID 34 and the Source will be Oracle.sidname. Clicking on the Event will give you a description such as: Audit trail: ACTION : 'connect internal' OSPRIV : DBA CLIENT USER: SJESSE\SJESSE CLIENT TERMINAL: SJESSE. This is no cause for concern unless you detect that an unauthorized client has made a connection. In most cases, a connect internal is a fairly infrequent occurrence. However, in instances where frequent connects occur, this can be an annoyance. Depending on how frequently a Connect Internal Occurs, you may see a number of these actions in your Application Log. This can cause particular problems when running Oracle Failsafe. Oracle Failsafe has a polling machanism which does a Connect Internal at a specified Polling Interval to check if the database is up. By default, this polling interval is once every minute. Therefore, when running Oracle Failsafe, because of the auditing of a Connect Internal, the Application Log is likely to fill up very rapidly with these messages. Since there is currently no way to disable these audit actions, you will have to work around this problem. This can be done in a couple of different ways: 1. Increase the size of the application log. By default, this is only 512k. It can be increased to an appropriate size by choosing 'Log Settings' under the LOG menu in the Event Viewer, and then entering an appropriate number for Maximum Log Size. 2. Also in the Log Settings Menu, you can specify if Events should be overwritten, and if so, how frequently. Choosing the option to 'Overwrite Events as Needed' will prevent the Log from filling up. However, be sure to make the Maximum Log Size large enough to avoid overwriting critical events before the log can be checked. 3. If running Oracle Failsafe, you can reduce the frequency of the polling, and therefore the frequency of connects, by increasing the "Is Alive" Interval. As Noted above, this defaults to 6 Milliseconds, or 1 Minute. To increase this Interval: a. Log on to Failsafe Manager b. Find your group and expand it by clicking on the (+) beside it. c. Drill down and find the database and highlight it. d. With the database highlighted, choose the policies tab on the right-hand side and type in a new number for the "Is Alive" Interval. Note that you do NOT need to change the "Looks Alive" Interval as the polling done for this check does NOT do a Connect Internal. (Click on the Help button in the policies tab for more information on "Is Alive" and "Looks Alive" Polling.) Note also that if you are running in a Failsafe Environment and you choose to change the Log Settings for the Application Log, you should make these changes on all nodes in the cluster. RELATED DOCUMENTS - For More information on how Oracle uses the Windows NT Event Viewer for auditing, refer to the following Notes: [NOTE:67868.1] [NOTE:99137.1] See also the Oracle 8i (Release 8.1.6) Administrator's Guide for Windows NT or the Oracle 8i (Release 8.1.5) Getting Started Guide for Windows NT . Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of
RE: Lemon Juice in Ants Pooh-Poohed/Redo Log Switching
While I've stayed away from the discussions about offended dieties and the like where people espouse their philosophies of life, I could not let an assertion which was clearly mistaken stand. In fairness to Mr. Steven, ants will have some citric acid in their bodies; it is an intermediate step in the oxidation of glucose. Now for an Oracle question. It is often touted that redo logs should switch every 15 minutes to 30 minutes. Are these the lower and upper limits, should the average time to switch logs be within that range, or should the median be between that range? Ian MacGregor Stanford Linear Accelerator [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 20, 2001 6:31 AM To: Multiple recipients of list ORACLE-L Can't the list members PUH-LEEZE stick (mostly) to messages germane to the purpose of this list? I don't mind the occasional off-topic post, but, for crying out loud, how about a little restraint? The original recipe posting(s) have given rise to a plethora of messages about chocolate, sugar, ants, travel, etc. etc. I open list messages as they arrive and I don't appreciate the cumulative waste of my time in reading all of this nonsense. If you all MUST ventilate at length about eating chocolate-covered ants, let's adopt a convention of including "OFF-TOPIC" in the message header, at least, so it's possible to filter them out. And no, I am not a grouch, curmudgeon, in need of lightening up, etc. Sometimes enough is enough, already. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Insert without telling column names
Roland,
Check out the SQL manual, the syntax diagram clearly illustrates that you
don't need to explicitly name the column names as long as you are inserting
into all of the columns in the order they are defined in the data
dictionary.
insert into table_A values ('Hi', 'there');
A word of friendly caution -- the list will rapidly recognize you by name
and fail to answer questions when it is obvious that you haven't taken the
time to 1) try it yourself and 2) read the docs. Also, you need to give
more information in your queries. We realize that Oracle is a big, bad
world and there is a lot to know, but most of us don't have the time to
answer every question every newbie has. I, of course, am an exception at
the moment since I am just killing time this week waiting to be laid off...
Regards,
Diana
-Original Message-
Sent: Tuesday, March 20, 2001 9:31 AM
To: Multiple recipients of list ORACLE-L
Hallo,
How can I create an insert statement without telling all the names of the
columns?
Give an example, please.
Roland Skldblom
--
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: Diana Duncan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: DBMS_OUTPUT.PUT_LINE
Yup. Like I said, you'd never want to do this in real life. I was just
illustrating the idea.
-Original Message-
Sent: Tuesday, March 20, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L
Won't that continuously print:
Inserted 1 rows.
Inserted 1 rows.
...
(well, as long as you don't get a primary/foreign key exception) :)
Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX
-Original Message-
Sent: Tuesday, March 20, 2001 10:11 AM
To: Multiple recipients of list ORACLE-L
Roland,
The only trick with dbms_output.put_line is to set your serveroutput on.
The following is a sample script to be run in SQL*Plus. Warning: it's a
stupid script, you'd never want to do this in real life. :)
set serverout on
declare
cursor some_cursor is
select *
from some_table;
begin
for curRec in some_cursor loop
insert into another_table (col1, col2)
values (curRec.col1, curRec.col2);
dbms_output.put_line('Inserted ' || SQL%rowcount || '
rows.');
end loop;
end;
/
Diana
-Original Message-
Sent: Tuesday, March 20, 2001 8:51 AM
To: Multiple recipients of list ORACLE-L
Hello,
Anyone who has a suggestion how to write the DBMS_OUTPUT.PUT_LINE command
if I want to display the numbers of inserts done in that script?
Would appreciate it very much if anyone could help..
Roland Skldblom
--
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: Diana Duncan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Jeffery Stevenson
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Diana Duncan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Lemon Juice in Ants Pooh-Poohed
Everything about them is long except their body's. Oh Man!! If you like'em, come on down to my house this spring and you take all of them out of the pool change room!! They sit in there, on the cieling, on the floor on the walls!! I can't deal, I know they can't hurt me, but they are just so nasty lookin!! -Original Message- Kevin M Sent: Tuesday, March 20, 2001 9:31 AM To: Multiple recipients of list ORACLE-L Kevin, Kevin, Kevin... Don't diss my Cave Crickets. Are you sure they're cave crickets? (They're not even crickets! They're related to the grasshopper) Are the antenea as long as the rest of the body? And even if they are Cave Crickets, they won't bother you. They just come out of the cave to feed. Kevin Toepke Caver and Semi-professional, Semi-competent DBA-type guy P: 614/652-5117 F: 614/652-5401 - The information in this electronic mail message is Cendant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. - The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. - -Original Message- Sent: Tuesday, March 20, 2001 8:26 AM To: Multiple recipients of list ORACLE-L It doesn't matter if they give off a sweet lemony aroma, I am thinking I don't want to eat ants!! The only time I would eat ants is if I was stranded somewhere and had no food. See, I really don't like insects, they bother me, not all of them. A lot of ants sickens me, I am terrified of spiders BIG TIME!! Also, here in Jersey, we have these bugs, they are called cave crickets I believe. Oh man do they freak me out, they look like a mix of a big spider and a cricket!! They jump about 3 feet in the air and are by far one of the ugliest things I have ever seen. I won't go in a room if I know one is in there, I know they can't hurt me, but it's just a phobia. Sorry for getting so far off of the topic! Kev snipsnipouch!snipThat HURTS! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin 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: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: NLS_DATE_FORMAT not effective..help!
Arul In init.ora have you specified MM/DD/ WITHOUT Quotes , as follows simply :- NLS_DATE_FORMAT=MM/DD/ -Original Message- From: Martin Kendall [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 6:36 PM To: Multiple recipients of list ORACLE-L Subject: RE: NLS_DATE_FORMAT not effective..help! Just create a Database on-logon trigger and setup the date as you want it. Then providing any "client" does not do an alter session you will have a standard DB date format. -Original Message- Sent: 20 March 2001 08:36 To: Multiple recipients of list ORACLE-L Hi Gurus, We want to change the default date format of oracle from 'dd-mon-yy' to 'MM/DD/' format for one of our database ( 8.1.6 ). I have set NLS_DATE_FORMAT as "MM/DD/" (also tried for year!) in init file. It doesn't seems to have any effect when i query sysdate (SQL PLUS) from a client PC (Win 95 / Oracle 8 client / SQL PLUS) . Still in SQL PLUS it is displaying the date as 20-MAR-01 ( default format - dd-mon-yy) Ofcourse, after modifying, i bounced the db and listener. Interesting thing is when i query sysdate from SQLPLUS of my server (where Oracle is installed ), it is giving me the date as SELECT SYSDATE FROM DUAL; 03/20/200 ( it should be 03/20/2001 ) What went wrong? Did anyone faced similar problem? Do i need to modify registry in client PCs ( Win 9X)...?? Thank You. Arul. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: FK Constraints
I don't get new user requests.. I get requests from end-users for data. But I understand. And I know that it's a question of coming in with the baseball bat and assorted heavy weaponry and making a stand (or as my CTO is fond of saying "putting a stake in the ground") Just haven't collected all the cudgels yet :) From: Rodd Holman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: FK Constraints Date: Tue, 20 Mar 2001 07:35:32 -0800 Rachel, One way I got this across to my developers and users was in creating new users for the DB. Every time I got a new user request, I would forward it to the director of the group that officially "owns" the data to get his permission to allow them in HIS data. After a few round robins of this the people finally realized that when I said Ops, Acctg, etc. owned the data, I also made them responsible for THEIR data. We still have fun every now and then with "Can you recover this for me" type reqests, but most of the time they recognize that I keep the system going and they keep the data correct. On Monday 19 March 2001 18:10, you wrote: the DBA is not responsible for the data?? Could you PLEASE come to my office and explain that (I'll bring the heavy club) to my developers, users and management? -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.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: Lemon Juice in Ants Pooh-Poohed
It was sarcastic. Alex Hillman -Original Message- From: Kimberly Smith [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Subject:RE: Lemon Juice in Ants Pooh-Poohed Actually, he was very valid in his request. He did not ask that you completely stop but rather add the OFF-TOPIC into the subject so it can be ruled out. It has been a rather long discussion with lots of e-mails (not that I am complaining, just seeing his point). -Original Message- Sent: Tuesday, March 20, 2001 7:57 AM To: Multiple recipients of list ORACLE-L Paul, you are in deep trouble :-). Somebody will sure "remind" you in that you have delete button etc. Alex Hillman -Original Message- From: Paul Baumgartel [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 9:31 AM To: Multiple recipients of list ORACLE-L Subject:RE: Lemon Juice in Ants Pooh-Poohed Can't the list members PUH-LEEZE stick (mostly) to messages germane to the purpose of this list? I don't mind the occasional off-topic post, but, for crying out loud, how about a little restraint? The original recipe posting(s) have given rise to a plethora of messages about chocolate, sugar, ants, travel, etc. etc. I open list messages as they arrive and I don't appreciate the cumulative waste of my time in reading all of this nonsense. If you all MUST ventilate at length about eating chocolate-covered ants, let's adopt a convention of including "OFF-TOPIC" in the message header, at least, so it's possible to filter them out. And no, I am not a grouch, curmudgeon, in need of lightening up, etc. Sometimes enough is enough, already. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: How long will 8.0.6 be supported?
09/30/2001 unless you have Extended Support, then it's 09/30/2004 - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 10:36 AM I can't get into Metalink. Can anyone tell me how long 8.0.6 will be supported? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Gentry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lemon Juice in Ants Pooh-Poohed
Actually, he was very valid in his request. He did not ask that you completely stop but rather add the OFF-TOPIC into the subject so it can be ruled out. It has been a rather long discussion with lots of e-mails (not that I am complaining, just seeing his point). -Original Message- Sent: Tuesday, March 20, 2001 7:57 AM To: Multiple recipients of list ORACLE-L Paul, you are in deep trouble :-). Somebody will sure "remind" you in that you have delete button etc. Alex Hillman -Original Message- From: Paul Baumgartel [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 9:31 AM To: Multiple recipients of list ORACLE-L Subject:RE: Lemon Juice in Ants Pooh-Poohed Can't the list members PUH-LEEZE stick (mostly) to messages germane to the purpose of this list? I don't mind the occasional off-topic post, but, for crying out loud, how about a little restraint? The original recipe posting(s) have given rise to a plethora of messages about chocolate, sugar, ants, travel, etc. etc. I open list messages as they arrive and I don't appreciate the cumulative waste of my time in reading all of this nonsense. If you all MUST ventilate at length about eating chocolate-covered ants, let's adopt a convention of including "OFF-TOPIC" in the message header, at least, so it's possible to filter them out. And no, I am not a grouch, curmudgeon, in need of lightening up, etc. Sometimes enough is enough, already. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Free Oracle DBA tests on the web
Andrey, Here is a partial list that I have. I give credit for these site and their content to the original authors. This is a partial list I have gleaned from this list. ROR mm http://www.stewartmc.com/oracle http://www.stewartmc.com/oracle/tips.html www.oraes.com/scr/expfull.sh http://www.lazydba.com http://cpan.valueclick.com/modules/by-category/07_Database_Interfaces/ http://www.oreilly.com/catalog/orinternals/ www.perl.com http://www.hot-oracle.com/ http://www.pitchmark.freeserve.co.uk/cert.htm http://www.brainbench.com/ http://www.oraclenotes.com/ http://www.selftestsoftware.com http://www.geocities.com/SiliconValley/Heights/1397/index.htm Chris Dempster's site (includes OCP guides) http://www.geocities.com/kgkrish K Gopalakrishnan's site (Details of new 8i OCP) http://cramsession.brainbuzz.com/ http://technet.oracle.com http://www.orafaq.org http://www.lazydba.com http://www.oracle-dba.com http://www.revealnet.com/generator.htm http://ourworld.compuserve.com/homepages/Peter_Koletzke http://www.orafans.com http://www.oreview.com/ http://www.solvit.net/dbscripts http://www.ipass.net/~davesisk/oont.htm http://www.oracle-users.com http://www.oracleguru.com http://www.dbdomain.com http://www.oracletool.com/ http://www.stewartmc.com/oracle/ http://www.teleport.com/~jkstill/util/ http://www.ozemail.com.au/~gpiper/index.html http://homepage.interaccess.com/~akaplan/oracle.html http://www.AppsDBA.com http://www.orapub.com http://www.oramag.com/ http://www.uaex.edu/srea/ http://www.onwe.co.za/frank/faqmain.htm http://www.geocities.com/SiliconValley/Peaks/4535/oracle/ www.mindspring.com/~hayden http://www.jlcomp.demon.co.uk/index.html (scroll down) http://www.webdiego.com/osr http://www.appsdba.com (oracle application orientated) http://www.tusc.com tuning tips-- U may find these white papers useful: "Oracle Performance and Tuning: Overview" http://pillango.sirma.bg/oracle/N014_p%26t_overview.pdf "Performance Tuning - Now You are the V8 Expert" http://pillango.sirma.bg/oracle/N023_tun_all.doc "Identifying Resource Intensive SQL in a production environment" - http://pillango.sirma.bg/oracle/N026_tuning2.pdf "Database Tuning Methodology" - http://pillango.sirma.bg/oracle/N027_DB_Tune.doc "SQL Tuning for the Oracle DBA" - http://pillango.sirma.bg/oracle/N050_tuning.pdf "Practical Tuning Advice for the Oracle8 DBA" - http://pillango.sirma.bg/oracle/N064_tuning.pdf "Finding the Performance Bottlenecks in Your Application" - http://pillango.sirma.bg/oracle/N067_performance.pdf "Inside the Oracle Cost Based Optimizer" - http://pillango.sirma.bg/oracle/N080_optimizer.doc "Seven Deadly SQL Traps and How to Avoid Them" - http://pillango.sirma.bg/oracle/N082_tuning.doc "Secrets of SQL and Application Tuning" - http://pillango.sirma.bg/oracle/N108_tuning.doc You can get the same kind of info on indexes. For sample code see the following: http://www.oracle.com/oramag/code/cod04139.html http://www.solvit.net/dbscripts/resize_db.html http://www.dbasupport.com/scripts/Administration/Session_Management/ HOT BACKUP INFO http://www.wolfenet.com/~jeremiah/hot-backup.html 24X7 oracle http://www.wolfenet.com/~jeremiah/oracle.html "Oracle DBA Checklist" http://pillango.sirma.bg/oracle/N008_dba_checklist.pdf "DBA101: A Refresher Course" http://pillango.sirma.bg/oracle/N092_dba.doc http://harbinger.sirma.bg/Oracle Here's a newer (v1.3) version of the same document. http://www.geocities.com/tbcox23/dba_checklist13.doc http://technet.oracle.com/software/products/oem/software_index.htm http://technet.oracle.com/cgi-bin/go?oem21-full Account administration guidelines. The table of contents: http://www.oreilly.com/catalog/orasec/toc.html and here is a sample chapter, "Developing a Database Security Plan": http://www.oreilly.com/catalog/orasec/chapter/ch07.html FREE SPACE SCRIPT Take a look at OraSnap : http://www.stewartmc.com/oracle/orasnap/ RAID INFO http://sw.expert.com REPORT.TXT info Try send a few sample report files to http://www.oraperf.com/. CRAMMSESSION ORACLE 8i UPGRADE http://cramsession.brainbuzz.com/cramsession/oracle/Oracle8iupgrade EXCEL to ORACLE http://www.oraxcel.com STATUS REPORT TIPS www.arikaplan.com REDO LOG INFO For info on the log block size, please see http://www.ixora.com.au/tips/creation/raw_log_files.htm. For the answer on redo wastage please see http://www.ixora.com.au/q+a/1999_09.htm and scroll down to the entry from 25 September 1999. [EMAIL PROTECTED] 03/20/01 12:36PM Hi DBAs ! I'm looking for some FREE Oracle DBA / developer resources on the web : self-tests , OCP preparations materials , articles , books , etc ... Please share your resources ! Thanks a lot in advance . Andrey . -- 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
Re: Insert without telling column names
At 08:36 AM 3/20/01 -0800, you wrote:
Roland,
You can't. There are a number of ways to really cut down on the code
required to do an insert, but if you think about it, how will Oracle
know where the data is supposed to go if you don't give it the column
name(at some point)?
Of course you can. The only caveat is Oracle will assume you are filling
all the columns in order, therefore you must provide a value for every
column, ie
For Table T1(firstname, lastname, telephone, fax, email)
insert into T1 values('John','Smith','4849910','','[EMAIL PROTECTED]')
Note the '' in place of a fax number. I could also have used null.
I never use this method in applications or procedures, of course, because
then if you change the table definition it no longer works, but for testing
stuff, or something I'm only going to run once it's a decent shortcut.
If you're using 8i, there is a direct load insert, but as far as I'm
aware, this will work only for a select * from another table.
Dynamic SQL works pretty well for this kind of stuff. What are you
trying to do?
Regards,
David A. Barbour
Oracle DBA
Formerly with the now defunct and bankrupt ConnectSouth
[EMAIL PROTECTED] wrote:
Hallo,
How can I create an insert statement without telling all the names of
the columns?
Give an example, please.
Roland Skldblom
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Regina Harter
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
32bit vs 64bit (was: Just like Christmas)
Interesting. We've got a 4-way K570 w/3GB mem that we'll be moving from HPUX 10.20 to HPUX 11.0 this weekend (8 hours of watching tape spin), which means I can FINALLY get us to 8i! YAY! So, why or why not should one go to 64bit? Here's my perception: Pros --- Should be faster (moving 2x as many bits around) Cons --- Requires major downtime to go from 32 to 64. Patches don't seem to come as quickly as 32bit versions on HP. Unknowns (for me) - How much faster, if at all, and in what areas (mem, I/O, disk)? Possible client problems? Our clients are all 8.0.5 for now. Any difference/disadvantage if 3rd party OCI programs are not recompiled? TIA, Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:06 To: Multiple recipients of list ORACLE-L Subject: Re:Just like Christmas Kimberly, Enjoy the N class boxes, especially in 64 bit mode. They really cook compared to a K. This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How long will 8.0.6 be supported?
Title: RE: How long will 8.0.6 be supported? According to a spreadsheet I've got normal support ends 30-Sep-2001 Extended Assistance Support ends 30-Sep-2004 Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Subject: How long will 8.0.6 be supported? I can't get into Metalink. Can anyone tell me how long 8.0.6 will be supported? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT -- Canada Rules!
Well, group- I have completely enjoyed the discussion on Canada, especially since I make my first trip to Toronto this April. But can someone tell me what Smarties are? And Crispy Crunch/Coffee Crisp? Thanks- Kathe -- Kathe C. Newsome Centenary College of Louisiana Sr. Software Manager/Database Administrator Email : [EMAIL PROTECTED] Telephone : 318.869.5213 Fax : 318.869.5004 Cols. 1:9 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathe Newsome INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- A humorous reply to the Canada rulz
U, Is this kinda like Mr. Sulu on Star Trek who was sure that the Russians invented everything? I might be wrong (happens all the time), but I thought Baseball and Basketball were distinctly inventions of the USA. You might be able to tell I'm a rabid fan of neither. Penicillin and the telephone?? Other delusions of grandeur? How about the only country that can't decide if they're English or French? How about the US's biggest colony via cultural conquest(ohh, that's a low blow). How about never saw a bikini except in National Geographic? I could go on, but I'm not sure my humor translates all that well, and the firewall has Babelfish blocked. Dan "not about to give up my day job" -Original Message- Sent: Tuesday, March 20, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Sorry about this, but someone sent me this and I thought it might be relevant to the Canada and US discussion that took place last week. With all the recipes going around, I thought it wouldn't do any harm. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- So, what do Canadians have to be proud of? * Smarties * Crispy Crunch Coffee Crisp * The size of our footballs fields and one less Down * Baseball is Canadian * Lacrosse is Canadian * Hockey is Canadian * Basketball is Canadian * Apple pie is Canadian * Mr. Dress-up kicks Mr. Rogers ass * Tim Hortons kicks Dunkin' Donuts ass * In the war of 1812, started by America, Canadians pushed the Americans back...past their 'White House'. Then we burned it... and most of Washington, under the command of William Lyon McKenzie who was insane and hammered all the time. We got bored because they ran away, so we came home and partied ... Go figure... * Canada has the largest French population that never surrendered to Germany. * We have the largest English population that never ever surrendered or withdrew during any war to anyone, anywhere. * Our civil war was a bar fight that lasted a little over an hour. * The only person who was arrested in our civil war was an American mercenary, who slept in and missed the whole thing...but showed up just in time to get caught. * We knew plaid was cool far before Seattle caught on. * The Hudsons Bay Company once owned over 10% of the earth's surface and is still around as the worlds oldest company * The average dog sled team can kill and devour a full grown human in under 3 minutes. * We still know what to do with all the parts of a buffalo. * We don't marry our kin-folk. * We invented ski-doos, jet-skis, velcro, zippers, insulin, penicillin, zambonis, the telephone and short wave radios that save countless lives each year * We ALL have frozen our tongues to something metal and lived to tell about it. * BUT MOST IMPORTANT! * the handles on our beer cases are big enough to fit your hands with mitts on. ooh Canada!! Oh yeah... and our elections only take one day. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SUN vs. HP
Hi, we are currently in the process of evaluating a high availiability cluster for our production database. The final two solutions are: SunCluster 2x420R 2Gig 2x450Mhz Storage 100Gig Hewlett Packard MC ServiceGuard 2xL-Class 2x440Mhz 2Gig Storage VA 7100 100Gig Based on our criterias (scalability, performance, TCO, price, reliability, support, in house experience ...) it looks like a dead race... Any suggestions or thoughts would be help full cheers alex -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Canada Rules! (fwd)
Yeah, but we could kick your XXX!! Not to mention that American Hockey players are just as good if not better than Canadians! -Original Message- Patrice J Sent: Tuesday, March 20, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Sorry about this, but someone sent me this and I thought it might be relevant to the Canada and US discussion that took place last week. With all the recipes going around, I thought it wouldn't do any harm. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- So, what do Canadians have to be proud of? * Smarties * Crispy Crunch Coffee Crisp * The size of our footballs fields and one less Down * Baseball is Canadian * Lacrosse is Canadian * Hockey is Canadian * Basketball is Canadian * Apple pie is Canadian * Mr. Dress-up kicks Mr. Rogers ass * Tim Hortons kicks Dunkin' Donuts ass * In the war of 1812, started by America, Canadians pushed the Americans back...past their 'White House'. Then we burned it... and most of Washington, under the command of William Lyon McKenzie who was insane and hammered all the time. We got bored because they ran away, so we came home and partied ... Go figure... * Canada has the largest French population that never surrendered to Germany. * We have the largest English population that never ever surrendered or withdrew during any war to anyone, anywhere. * Our civil war was a bar fight that lasted a little over an hour. * The only person who was arrested in our civil war was an American mercenary, who slept in and missed the whole thing...but showed up just in time to get caught. * We knew plaid was cool far before Seattle caught on. * The Hudsons Bay Company once owned over 10% of the earth's surface and is still around as the worlds oldest company * The average dog sled team can kill and devour a full grown human in under 3 minutes. * We still know what to do with all the parts of a buffalo. * We don't marry our kin-folk. * We invented ski-doos, jet-skis, velcro, zippers, insulin, penicillin, zambonis, the telephone and short wave radios that save countless lives each year * We ALL have frozen our tongues to something metal and lived to tell about it. * BUT MOST IMPORTANT! * the handles on our beer cases are big enough to fit your hands with mitts on. ooh Canada!! Oh yeah... and our elections only take one day. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: redo log timing
Ian, This is one of those where you can get the old "it depends" answer. What type of database is this? What level of transaction activity do you have? How big are your redo logs if you switch every 15 min, 20 min, 30 min? How critical is recovery to the current time to you? If you don't want the overhead of lots of log switches and you can stand to have a possible loss of 30 minutes of data on a recovery then 2/hr would work. (Possiblity of data loss based on losing all logs and mirror logs in a recovery scenario). Others may have differing opinions on this, but I normally keep mine running in the 15-20 minute range. The overhead difference between 2 switches/hour and 3 or 4 per/hour is generally not noticeable. It makes for smaller archives which makes the gzip of the log run faster and take up less cpu time. (I run a cron job that compresses the archived logs to save disk space). On Tuesday 20 March 2001 11:36, you wrote: Now for an Oracle question. It is often touted that redo logs should switch every 15 minutes to 30 minutes. Are these the lower and upper limits, should the average time to switch logs be within that range, or should the median be between that range? Ian MacGregor Stanford Linear Accelerator [EMAIL PROTECTED] -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Free Oracle DBA tests on the web
Andrey ' Electronic books can be found at: RUSSIAN FREE BOOKS HTML FORMAT_+++ http://docs.rinet.ru/ ROR mm [EMAIL PROTECTED] 03/20/01 12:36PM Hi DBAs ! I'm looking for some FREE Oracle DBA / developer resources on the web : self-tests , OCP preparations materials , articles , books , etc ... Please share your resources ! Thanks a lot in advance . Andrey . -- 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).
OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz
First off, I had no idea that a Canadian had invented baseball but a Canadian most definitely invented Basketball. Go look it up. However, he was in the States when he invented it. Once we get rid of Quebec we will have no issues as to what language we are. We are bilingual. Except for Quebec we are accepting of that. Another Canadian trait. As for bikini's, it can actually get quite warm in Canada. I have seen many a bikini. Personally I don't wear one but I would not be cold if I did wear one in the summer. Did you know that there are parts of Canada that are further south then the USA. I actually went up quite a few degrees when I moved from Halifax, NS to Portland, OR. Check it out. And as for us being culturally like the US, don't see it man. We are not nearly as paranoid (generalizing here on in) as Americans. We pay so much more taxes, and we do complain, but the people here bring it to a whole new level. I hear that we are friendlier but I am not so sure of that one. Maybe initially it seems like that because we are not so paranoid and trust right away. Lets see, how many school shooting did we have last year. I know of one but there might have been more. Never been to a school with a metal detector but I do know of one high school that is bigger then a lot of Universities that does have a cop on site. We are much more accepting of technology. Got that one out of the news many times, plus it amazes me some of the things you guys just don't do in the States that we have been doing for years. Our banks carry foreign currency and are much easier to deal with. Almost like they like customers. That has been a big problem for me here in Portland. I could go on but I am sure I pissed many Americans off already. Don't get me wrong, I like the States and am enjoying my time here but we are not Americans! Nor do we want to be. I just want the money:-) -Original Message- Sent: Tuesday, March 20, 2001 10:07 AM To: Multiple recipients of list ORACLE-L U, Is this kinda like Mr. Sulu on Star Trek who was sure that the Russians invented everything? I might be wrong (happens all the time), but I thought Baseball and Basketball were distinctly inventions of the USA. You might be able to tell I'm a rabid fan of neither. Penicillin and the telephone?? Other delusions of grandeur? How about the only country that can't decide if they're English or French? How about the US's biggest colony via cultural conquest(ohh, that's a low blow). How about never saw a bikini except in National Geographic? I could go on, but I'm not sure my humor translates all that well, and the firewall has Babelfish blocked. Dan "not about to give up my day job" -Original Message- Sent: Tuesday, March 20, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Sorry about this, but someone sent me this and I thought it might be relevant to the Canada and US discussion that took place last week. With all the recipes going around, I thought it wouldn't do any harm. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- So, what do Canadians have to be proud of? * Smarties * Crispy Crunch Coffee Crisp * The size of our footballs fields and one less Down * Baseball is Canadian * Lacrosse is Canadian * Hockey is Canadian * Basketball is Canadian * Apple pie is Canadian * Mr. Dress-up kicks Mr. Rogers ass * Tim Hortons kicks Dunkin' Donuts ass * In the war of 1812, started by America, Canadians pushed the Americans back...past their 'White House'. Then we burned it... and most of Washington, under the command of William Lyon McKenzie who was insane and hammered all the time. We got bored because they ran away, so we came home and partied ... Go figure... * Canada has the largest French population that never surrendered to Germany. * We have the largest English population that never ever surrendered or withdrew during any war to anyone, anywhere. * Our civil war was a bar fight that lasted a little over an hour. * The only person who was arrested in our civil war was an American mercenary, who slept in and missed the whole thing...but showed up just in time to get caught. * We knew plaid was cool far before Seattle caught on. * The Hudsons Bay Company once owned over 10% of the earth's surface and is still around as the worlds oldest company * The average dog sled team can kill and devour a full grown human in under 3 minutes. * We still know what to do with all the parts of a buffalo. * We don't marry our kin-folk. * We invented ski-doos, jet-skis, velcro, zippers, insulin, penicillin, zambonis, the telephone and short wave radios that save countless lives each year * We ALL have frozen our
RE: OT -- A humorous reply to the Canada rulz
Wow that was good!! You know, I don't really like baseball, but I am pretty sure that when you drive into Hoboken it says on a sign "Home of Baseball and Frank Sinatra". hmm Canada invented hockey, but they also invented curling didn't they. Yeah, isn't that like the Canadian version of shuffle board? -Original Message- Sent: Tuesday, March 20, 2001 1:07 PM To: Multiple recipients of list ORACLE-L U, Is this kinda like Mr. Sulu on Star Trek who was sure that the Russians invented everything? I might be wrong (happens all the time), but I thought Baseball and Basketball were distinctly inventions of the USA. You might be able to tell I'm a rabid fan of neither. Penicillin and the telephone?? Other delusions of grandeur? How about the only country that can't decide if they're English or French? How about the US's biggest colony via cultural conquest(ohh, that's a low blow). How about never saw a bikini except in National Geographic? I could go on, but I'm not sure my humor translates all that well, and the firewall has Babelfish blocked. Dan "not about to give up my day job" -Original Message- Sent: Tuesday, March 20, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Sorry about this, but someone sent me this and I thought it might be relevant to the Canada and US discussion that took place last week. With all the recipes going around, I thought it wouldn't do any harm. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- So, what do Canadians have to be proud of? * Smarties * Crispy Crunch Coffee Crisp * The size of our footballs fields and one less Down * Baseball is Canadian * Lacrosse is Canadian * Hockey is Canadian * Basketball is Canadian * Apple pie is Canadian * Mr. Dress-up kicks Mr. Rogers ass * Tim Hortons kicks Dunkin' Donuts ass * In the war of 1812, started by America, Canadians pushed the Americans back...past their 'White House'. Then we burned it... and most of Washington, under the command of William Lyon McKenzie who was insane and hammered all the time. We got bored because they ran away, so we came home and partied ... Go figure... * Canada has the largest French population that never surrendered to Germany. * We have the largest English population that never ever surrendered or withdrew during any war to anyone, anywhere. * Our civil war was a bar fight that lasted a little over an hour. * The only person who was arrested in our civil war was an American mercenary, who slept in and missed the whole thing...but showed up just in time to get caught. * We knew plaid was cool far before Seattle caught on. * The Hudsons Bay Company once owned over 10% of the earth's surface and is still around as the worlds oldest company * The average dog sled team can kill and devour a full grown human in under 3 minutes. * We still know what to do with all the parts of a buffalo. * We don't marry our kin-folk. * We invented ski-doos, jet-skis, velcro, zippers, insulin, penicillin, zambonis, the telephone and short wave radios that save countless lives each year * We ALL have frozen our tongues to something metal and lived to tell about it. * BUT MOST IMPORTANT! * the handles on our beer cases are big enough to fit your hands with mitts on. ooh Canada!! Oh yeah... and our elections only take one day. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
RE: 32bit vs 64bit (was: Just like Christmas)
We are going 64-bit for HP but keeping Oracle at 32-bit. We really had no choice for the HP side. We just need the memory that 32 bit could not support. We have 9 K-class servers here that have been running 11-64-bit for quite some time (relatively speaking). But we are getting rid of all our K-class servers. The model we are running have been nothing but trouble. We hate to turn one off because it seems like every time we reboot hardware dies. Other fabs have been having the same issue. So we are going N-class for the database cluster and A-class for the remaining. Since your K-class servers are new they probably don't have the same hardware issues we have. HP even owned up to having issues. -Original Message- Sent: Tuesday, March 20, 2001 10:16 AM To: Multiple recipients of list ORACLE-L Interesting. We've got a 4-way K570 w/3GB mem that we'll be moving from HPUX 10.20 to HPUX 11.0 this weekend (8 hours of watching tape spin), which means I can FINALLY get us to 8i! YAY! So, why or why not should one go to 64bit? Here's my perception: Pros --- Should be faster (moving 2x as many bits around) Cons --- Requires major downtime to go from 32 to 64. Patches don't seem to come as quickly as 32bit versions on HP. Unknowns (for me) - How much faster, if at all, and in what areas (mem, I/O, disk)? Possible client problems? Our clients are all 8.0.5 for now. Any difference/disadvantage if 3rd party OCI programs are not recompiled? TIA, Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:06 To: Multiple recipients of list ORACLE-L Subject: Re:Just like Christmas Kimberly, Enjoy the N class boxes, especially in 64 bit mode. They really cook compared to a K. This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: RE: OT: Rachel in Vietnam
I'm old but not THAT old :) would not have been draftable even at the end of the war (even if I were male!) From: "Mohan, Ross" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: RE: OT: Rachel in Vietnam Date: Tue, 20 Mar 2001 08:02:26 -0800 Dick , Didn't you know? Rachel WAS in Nam. But she never talks about it. I think it had to do with the bugs. Just a thought. Ross -Original Message- Sent: Tuesday, March 20, 2001 8:32 AM To: Multiple recipients of list ORACLE-L Rachel, If you were given one, as I was in Nam, you'd not know the difference. Looks like, tastes like a crunch bar for the most part, except for the logo on top. It just crunches better. Dick Goulet Reply Separator Author: "Rachel Carmichael" [EMAIL PROTECTED] Date: 3/19/2001 4:10 PM but Moom, the icky bugs TOUCHED the chocolate! :) From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Mon, 19 Mar 2001 13:45:29 -0800 You could just lick the chocolate off. -Original Message- Sent: Monday, March 19, 2001 10:11 AM To: Multiple recipients of list ORACLE-L shudder I have a phobia about bugs... what a waste of perfectly good chocolate From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Mon, 19 Mar 2001 09:11:20 -0800 OK you chocaholics try this on for size: Reuters Monday, March 19, 2001 Chocolate-Coated Bugs Are Latest Treat LONDON (Reuters) - Ants, crickets and scorpions, baked, coated in chocolate and promoted as a high-protein snack, are proving popular among peckish Londoners. Designer Todd Dalton, who trained as a chef in Louisiana and acquired a taste for cooked insects on his travels in Asia and central America, says he has sold 5,000 chocolate-coated bugs since he began marketing them in December. "They are very high in protein and very low in fat. They have a higher percentage of protein than any meat or fish that we commonly eat," he told Reuters. The creepy-crawly chocs sell for between three and 3.50 pounds ($4.30-$5.00) at upmarket London stores such as Selfridges and the Conran Shop and will soon be appearingin shops in Munich and Zurich. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City
RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
I thought it was that, but figured it was better to ask... you can find rock candy these days in the fancier candy stores masquerading as coffee stir sticks :) From: "Hand, Michael T" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Tue, 20 Mar 2001 09:30:27 -0800 Sorry Lee, it looks like Rachel is too much of a chocoholic to be up on her hard candy nomenclature. In the US its refered to as Rock candy, basically colored, flavored, crystaline sugar (sucrose, not glucose) available in various shapes and sizes though I haven't seen much of it lately. [It's probably gone the way of ribbon candy and other treats of yesteryear... (Norman Rockwell moment).] The most common US seaside confection is Saltwater taffy, or cotton candy. Confectionarily yours, Mike -Original Message- Sent: Tuesday, March 20, 2001 10:16 AM To: Multiple recipients of list ORACLE-L ermI don't know how this travels. Like a sugary candy which is extremely hard, you do have candy canes in the States for Christmas trees etc ?? Sort of thicker, straighter version and normally minty in the UK - very popular at Seaside resorts where the sweet is manufactured with the name of the resort printed all the way through the middle. Oh God - this is sounding more weird, the more I try and describe it. Any other Brits who have lived/worked extensively in the States care to offer a better translation ?? Cheers Lee -Original Message- Sent: 20 March 2001 13:26 To: Multiple recipients of list ORACLE-L rhubarb flavored rock I'm working on a tentative assumption here that you don't mean actual rocks... translation please! From: lerobe - Lee Robertson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Tue, 20 Mar 2001 00:05:25 -0800 Been drinking it in the UK for most of my 37 years !!! Used to be a plain old pick me up for years (if you ever had to go into hospital or indeed went visiting, you were either given or giving a bottle). Nowadays it is used by sportsmen etc for exactly what you have described. Regards Lee (one of the original Lucozade kids) PS. This was one of my mothers cravings when she was pregnant with me - however she could only drink it whilst eating rhubarb flavoured rock - WEIRD !! -Original Message- Sent: 19 March 2001 20:41 To: Multiple recipients of list ORACLE-L Speaking of sugar... I just returned from Trinidad (on a mission trip to build a church in Toco). While working in the 95 degree sun all day we often walked up to the corner store and bought water and cokes (the coca cola was much sweeter there than in the US, but also less carbonated). What we also found was a product called Lucozade (http://www.lucozade.com/). This was a sport drink essentially made of glucose syrup. From their website - "When you drink it, the glucose gets rapidly absorbed into your bloodstream and gives you a quick burst of energy. Glucose is the natural preferred fuel for the body becuase of the speed with which it can be digested and absorbed. Once absorbed it is a readily available source of fuel, whic all cells of the body can utilise." Official drink of on-call DBAs. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack C. Applewhite Sent: Monday, March 19, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Kimberley, I'd be surprised if you can get "real" raw sugar in stores. When I was in the U.S. Peace Corps in Belize in the mid '70s, raw sugar was readily available, since sugar was a primary export from that beautiful little country. If you let a couple of pounds of raw sugar sit in a brown paper bag for a day or two, the molasses would settle to the bottom and puddle - a jar, shaken occasionally, was a better storage option. It was delicious! There's nothing quite like a peanut butter and raw sugar sandwich! Ironically, the Belizians preferred refined, white sugar, since it was considered more "upscale" than the raw sugar. BTW, other advantages to living in a sugar-exporting country included very cheap soft drinks and rum!...Oh, and Reggae! ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Kimberly Smith Sent: Monday, March 19, 2001 9:33 AM To: Multiple recipients of list ORACLE-L Recipe Hey, found out that muscavado sugar is raw sugar. Hopefully I can find it
RE: OT -- Canada Rules!
Smarties rule. Much better then MM's. And for those of you who think that Smarties are those sugar candies, its not that man. People here at work had no clues either so I had my mom ship up a whole wack of them. I don't like Crispy Crunch bars but the Coffee Crisp bars are pretty good. Personally I am a Snickers fan though so I am not suffering in that area. -Original Message- Sent: Tuesday, March 20, 2001 10:16 AM To: Multiple recipients of list ORACLE-L Well, group- I have completely enjoyed the discussion on Canada, especially since I make my first trip to Toronto this April. But can someone tell me what Smarties are? And Crispy Crunch/Coffee Crisp? Thanks- Kathe -- Kathe C. Newsome Centenary College of Louisiana Sr. Software Manager/Database Administrator Email : [EMAIL PROTECTED] Telephone : 318.869.5213 Fax : 318.869.5004 Cols. 1:9 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathe Newsome INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Canada Rules! (fwd)
Do you know that all most of the top ranked American/European hockey players actually played in the CHL. They start by getting drafted in the major junior leagues. So ya, you could be just as good as an American, as long as you train in Canada. In Canada if you are playing hockey for your University team that is pretty much the end of your career (unless you want to play senior). -Original Message- Sent: Tuesday, March 20, 2001 10:41 AM To: Multiple recipients of list ORACLE-L Yeah, but we could kick your XXX!! Not to mention that American Hockey players are just as good if not better than Canadians! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SUN vs. HP
I have no experience with the Sun cluster but I do have experience with the HP ServiceGuard as its what we run here. We have even had it fail. We do have a Sun server here with a database on it and although I like the server and have no complaints I am much happier with HP. There are just little things that drive me crazy on the Sun side. If you have any specific questions on the HP side though them out. If I don't know the answer the sys. admin. team is in the cube beside me. I do know that they are happy with support from both companies, which is very important. -Original Message- Sent: Tuesday, March 20, 2001 10:32 AM To: Multiple recipients of list ORACLE-L Hi, we are currently in the process of evaluating a high availiability cluster for our production database. The final two solutions are: SunCluster 2x420R 2Gig 2x450Mhz Storage 100Gig Hewlett Packard MC ServiceGuard 2xL-Class 2x440Mhz 2Gig Storage VA 7100 100Gig Based on our criterias (scalability, performance, TCO, price, reliability, support, in house experience ...) it looks like a dead race... Any suggestions or thoughts would be help full cheers alex -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SUN vs. HP
Check the numbers again, especially the software. Having done the same study 1.5 yrs ago, HP was a little more expensive in the HW but much cheaper in SW. Reason being Sun uses Veritas Trusted Cluster (expensive $100k) for HA and HP uses MCServiceguard. I've worked 5 yrs w/ Sun and 1.5 yrs w/ HP equipment. They were both good, but if I had to choose, HP gave you many more tools whereas w/ Sun you buy everything. My last flavor of unix to conquer is IBM AIX. They do it differently also. For that matter, so did DEC OSF/1, now Compaq Tru64 unix (hard to say compaq unix). Just my $.02. Gene Sais PS. Lets not forget OpenVMS, dam good OS! [EMAIL PROTECTED] 03/20/01 01:31PM Hi, we are currently in the process of evaluating a high availiability cluster for our production database. The final two solutions are: SunCluster 2x420R 2Gig 2x450Mhz Storage 100Gig Hewlett Packard MC ServiceGuard 2xL-Class 2x440Mhz 2Gig Storage VA 7100 100Gig Based on our criterias (scalability, performance, TCO, price, reliability, support, in house experience ...) it looks like a dead race... Any suggestions or thoughts would be help full cheers alex -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Find special characters in the database
Can someone give me a guideline as to how I should draw a script to find special characters in the database and replace them with blanks. TIA Shakeel Qureshi [EMAIL PROTECTED] __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shakeel Qureshi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Canada Rules! / Chocolate ...
Kathe, I thought every red-blooded American knew what Smarties where. And since I have become the newest OCP (Other Confection Professional), I will enlighten you. Smarties are a "penny" candy, sour in taste about the size of an MM vended in plastic wrap of 12-15 in a stack. I think Crispy Crunch is similar to our Cracker Jacks, but I'll let some of our northern neighbors confirm that. More importantly what was this War of 1812 I keep hearing about ;) Mike -Original Message- Sent: Tuesday, March 20, 2001 1:16 PM To: Multiple recipients of list ORACLE-L Well, group- I have completely enjoyed the discussion on Canada, especially since I make my first trip to Toronto this April. But can someone tell me what Smarties are? And Crispy Crunch/Coffee Crisp? Thanks- Kathe -- Kathe C. Newsome Centenary College of Louisiana Sr. Software Manager/Database Administrator Email : [EMAIL PROTECTED] Telephone : 318.869.5213 Fax : 318.869.5004 Cols. 1:9 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathe Newsome INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- A humorous reply to the Canada rulz
Dan, You've made one of the only mortal sins of the Internet, it's not dis'ing the Canadians. It's making an inaccurate Star Trek reference. The ensign of Russian-descent was Pavel Checkov played by . . . joined the cast in episode # ... entitled ... Your penance should be long and severe. Mike -Original Message- Sent: Tuesday, March 20, 2001 1:07 PM To: Multiple recipients of list ORACLE-L U, Is this kinda like Mr. Sulu on Star Trek who was sure that the Russians invented everything? I might be wrong (happens all the time), but I thought Baseball and Basketball were distinctly inventions of the USA. You might be able to tell I'm a rabid fan of neither. Penicillin and the telephone?? Other delusions of grandeur? How about the only country that can't decide if they're English or French? How about the US's biggest colony via cultural conquest(ohh, that's a low blow). How about never saw a bikini except in National Geographic? I could go on, but I'm not sure my humor translates all that well, and the firewall has Babelfish blocked. Dan "not about to give up my day job" -Original Message- Sent: Tuesday, March 20, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Sorry about this, but someone sent me this and I thought it might be relevant to the Canada and US discussion that took place last week. With all the recipes going around, I thought it wouldn't do any harm. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- So, what do Canadians have to be proud of? * Smarties * Crispy Crunch Coffee Crisp * The size of our footballs fields and one less Down * Baseball is Canadian * Lacrosse is Canadian * Hockey is Canadian * Basketball is Canadian * Apple pie is Canadian * Mr. Dress-up kicks Mr. Rogers ass * Tim Hortons kicks Dunkin' Donuts ass * In the war of 1812, started by America, Canadians pushed the Americans back...past their 'White House'. Then we burned it... and most of Washington, under the command of William Lyon McKenzie who was insane and hammered all the time. We got bored because they ran away, so we came home and partied ... Go figure... * Canada has the largest French population that never surrendered to Germany. * We have the largest English population that never ever surrendered or withdrew during any war to anyone, anywhere. * Our civil war was a bar fight that lasted a little over an hour. * The only person who was arrested in our civil war was an American mercenary, who slept in and missed the whole thing...but showed up just in time to get caught. * We knew plaid was cool far before Seattle caught on. * The Hudsons Bay Company once owned over 10% of the earth's surface and is still around as the worlds oldest company * The average dog sled team can kill and devour a full grown human in under 3 minutes. * We still know what to do with all the parts of a buffalo. * We don't marry our kin-folk. * We invented ski-doos, jet-skis, velcro, zippers, insulin, penicillin, zambonis, the telephone and short wave radios that save countless lives each year * We ALL have frozen our tongues to something metal and lived to tell about it. * BUT MOST IMPORTANT! * the handles on our beer cases are big enough to fit your hands with mitts on. ooh Canada!! Oh yeah... and our elections only take one day. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an
Indexes and tablespaces
Hello,
I have a partitioned historical table in tablespace TS1 with 8 local
indexes.
I'm not sure how is better to:
- put the eight indexes in separate tablespaces (with small extents) or
- create just one big tablespace (with larger extents) for all indexes.
Other concerns include:
- a formula to calculate extents for indexes, tablespaces and data files
associated.
- is there a tool to help?
Thanks, alex.
Below the definitions for table and indexes (don't laugh too much!), using
just one big tablespace UC_OP_TSIX_200103.
CREATE TABLESPACE UC_OP_TS_200103
DATAFILE
'D:\ORANT\DATABASE\UC_OP_TS_200103_1.ORA' SIZE 512M AUTOEXTEND ON NEXT
512M
, 'D:\ORANT\DATABASE\UC_OP_TS_200103_2.ORA' SIZE 512M AUTOEXTEND ON NEXT
512M
SIZE 1024M AUTOEXTEND ON NEXT 1024M;
CREATE TABLESPACE UC_OP_TSIX_200103
DATAFILE 'D:\ORANT\DATABASE\UC_OP_TSIX_200103_1.ORA' SIZE 512M AUTOEXTEND
ON NEXT 512M
, DATAFILE 'D:\ORANT\DATABASE\UC_OP_TSIX_200103_2.ORA' SIZE 512M AUTOEXTEND
ON NEXT 512M
, DATAFILE 'D:\ORANT\DATABASE\UC_OP_TSIX_200103_3.ORA' SIZE 512M AUTOEXTEND
ON NEXT 512M
SIZE 512M AUTOEXTEND ON NEXT 512M;
CREATE TABLE OPERAZIONE (
ID NUMBER(13) NOT NULL,
ABI VARCHAR2(5) NULL,
CAB VARCHAR2(5) NULL,
PERSONALE_MATRICOLA VARCHAR2(10) NOT NULL,
DIPENDENZA NUMBER(5) NOT NULL,
TERMINALENUMBER(3) NOT NULL,
NUMERO NUMBER(7) NOT NULL,
DATA_CONTABILE DATE NOT NULL,
DATA_DATE NOT NULL,
DATA_DISPONIBILITA DATE NULL,
DATA_VALUTA DATE NULL,
COD_TRANSAZIONE VARCHAR2(8) NULL,
DIVISA_UIC NUMBER(3) NOT NULL,
IMPORTO NUMBER(18,3) NOT NULL,
TIPO VARCHAR2(1) NOT NULL,
NUM_RIFERIMENTO NUMBER(10) NULL,
COD_CAUSALE NUMBER(3) NULL,
CONTO_DIPENDENZA NUMBER(5) NULL,
CONTO_CATEGORIA NUMBER(3) NULL,
CONTO_NUMERO NUMBER(7) NULL,
DESCRIZIONE VARCHAR2(50) NULL,
DATA_IMPORTAZIONEDATE NOT NULL,
BUSTA_ID NUMBER(11) NULL,
IMMAGINE_ID NUMBER(11) NULL
)
PARTITION BY RANGE( DATA_ )
(
PARTITION OP_P_200103 VALUES LESS THAN(TO_DATE('01-04-2001
00:00:00','DD-MM- HH24:MI:SS'))
TABLESPACE UC_OP_TS_200103
PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
CREATE INDEX OPERAZIONE_IX_ID ON OPERAZIONE
(
ID ASC
)
LOCAL
(
PARTITION OP_P_200103 TABLESPACE UC_OP_TSIX_200103
PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
CREATE INDEX OPERAZIONE_IX_BUSTA_ID ON OPERAZIONE
(
BUSTA_ID ASC
)
LOCAL
(
PARTITION OP_P_200103 TABLESPACE UC_OP_TSIX_200103
PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
CREATE INDEX OPERAZIONE_IX_IMMAGINE_ID ON OPERAZIONE
(
IMMAGINE_IDASC
)
LOCAL
(
PARTITION OP_P_200103 TABLESPACE UC_OP_TSIX_200103
PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
CREATE INDEX OPERAZIONE_IX_DIPENDENZA ON OPERAZIONE
(
DATA_ ASC,
DIPENDENZA ASC,
PERSONALE_MATRICOLAASC
)
LOCAL
(
PARTITION OP_P_200103 TABLESPACE UC_OP_TSIX_200103
PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
CREATE INDEX OPERAZIONE_IX_IMPORTO ON OPERAZIONE
(
DATA_ ASC,
DIPENDENZA ASC,
IMPORTOASC
)
LOCAL
(
PARTITION OP_P_200103 TABLESPACE UC_OP_TSIX_200103
PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
CREATE INDEX OPERAZIONE_IX_CONTO ON OPERAZIONE
(
CONTO_NUMERO ASC,
CONTO_DIPENDENZA ASC,
CONTO_CATEGORIAASC
)
LOCAL
(
PARTITION OP_P_200103 TABLESPACE UC_OP_TSIX_200103
PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
CREATE INDEX OPERAZIONE_IX_RIFERIMENTO ON OPERAZIONE
(
DATA_ ASC,
NUM_RIFERIMENTOASC
)
LOCAL
(
PARTITION OP_P_200103 TABLESPACE UC_OP_TSIX_200103
PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Berindei Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing
RE: OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz - s
WoooHooo, this could really get things hot down here. Again, I have no idea of what I'm talking about. Just a bunch of stuff that I "know" which is probably wrong. Additionally, I imagine people in Miami think Philadelphia is the Great White North, so the whole bikini thing was a jab at the stereotype, not the reality, and I do hear the Hortons rule, but look out for Krispy Kreme hehe. Quebec, is that like the crazy Uncle no one wants to talk about? The cultural thing is from some vague newspaper dropping of a story I kind of vaguely remember from 6 years ago :) Dan looking forward to a Tim Horton -Original Message- Sent: Tuesday, March 20, 2001 1:57 PM To: Multiple recipients of list ORACLE-L First off, I had no idea that a Canadian had invented baseball but a Canadian most definitely invented Basketball. Go look it up. However, he was in the States when he invented it. Once we get rid of Quebec we will have no issues as to what language we are. We are bilingual. Except for Quebec we are accepting of that. Another Canadian trait. As for bikini's, it can actually get quite warm in Canada. I have seen many a bikini. Personally I don't wear one but I would not be cold if I did wear one in the summer. Did you know that there are parts of Canada that are further south then the USA. I actually went up quite a few degrees when I moved from Halifax, NS to Portland, OR. Check it out. And as for us being culturally like the US, don't see it man. We are not nearly as paranoid (generalizing here on in) as Americans. We pay so much more taxes, and we do complain, but the people here bring it to a whole new level. I hear that we are friendlier but I am not so sure of that one. Maybe initially it seems like that because we are not so paranoid and trust right away. Lets see, how many school shooting did we have last year. I know of one but there might have been more. Never been to a school with a metal detector but I do know of one high school that is bigger then a lot of Universities that does have a cop on site. We are much more accepting of technology. Got that one out of the news many times, plus it amazes me some of the things you guys just don't do in the States that we have been doing for years. Our banks carry foreign currency and are much easier to deal with. Almost like they like customers. That has been a big problem for me here in Portland. I could go on but I am sure I pissed many Americans off already. Don't get me wrong, I like the States and am enjoying my time here but we are not Americans! Nor do we want to be. I just want the money:-) -Original Message- Sent: Tuesday, March 20, 2001 10:07 AM To: Multiple recipients of list ORACLE-L U, Is this kinda like Mr. Sulu on Star Trek who was sure that the Russians invented everything? I might be wrong (happens all the time), but I thought Baseball and Basketball were distinctly inventions of the USA. You might be able to tell I'm a rabid fan of neither. Penicillin and the telephone?? Other delusions of grandeur? How about the only country that can't decide if they're English or French? How about the US's biggest colony via cultural conquest(ohh, that's a low blow). How about never saw a bikini except in National Geographic? I could go on, but I'm not sure my humor translates all that well, and the firewall has Babelfish blocked. Dan "not about to give up my day job" -Original Message- Sent: Tuesday, March 20, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Sorry about this, but someone sent me this and I thought it might be relevant to the Canada and US discussion that took place last week. With all the recipes going around, I thought it wouldn't do any harm. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- So, what do Canadians have to be proud of? * Smarties * Crispy Crunch Coffee Crisp * The size of our footballs fields and one less Down * Baseball is Canadian * Lacrosse is Canadian * Hockey is Canadian * Basketball is Canadian * Apple pie is Canadian * Mr. Dress-up kicks Mr. Rogers ass * Tim Hortons kicks Dunkin' Donuts ass * In the war of 1812, started by America, Canadians pushed the Americans back...past their 'White House'. Then we burned it... and most of Washington, under the command of William Lyon McKenzie who was insane and hammered all the time. We got bored because they ran away, so we came home and partied ... Go figure... * Canada has the largest French population that never surrendered to Germany. * We have the largest English population that never ever surrendered or withdrew during any war to anyone, anywhere. * Our civil war was a bar fight that lasted a little over an hour. * The only person who was arrested
Re: Free Oracle DBA tests on the web
Hi Andrey, Hi DBAs ! I'm looking for some FREE Oracle DBA / developer resources on the web : self-tests , OCP preparations materials , articles , books , etc ... Please share your resources ! Thanks a lot in advance . cheap_salesman_hey_a_guys_gotta_eat Check out the links in Table 1-1 on the following page: = http://www.oreilly.com/catalog/oracleopen/chapter/ch01.html It took me and Sean Hull a ridiculous period of time to collect all of those (too much to mention). If you'd like to read about how we did it, why we did it, and get as much installation/user documentation on them all, as we could physically squeeze into 500 pages, please book your copy now, of: = http://www.oreilly.com/catalog/oracleopen/ (out around April 15th) /cheap_salesman_hey_a_guys_gotta_eat :-) Rgds, AndyD PS The cheque's in the post. = [EMAIL PROTECTED] O'Reilly's "Oracle and Open Source": = http://www.oreilly.com/catalog/oracleopen/ Orac, Perl/Tk and Perl DBI Database DBA Development Tool: = http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/ __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy Duncan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RE: Lemon Juice in Ants Pooh-Poohed
OH GOD THAT'S IT!!! I can't even look at the thing on my monitor...man I have problems! -Original Message- Travis Sent: Tuesday, March 20, 2001 1:51 PM To: Multiple recipients of list ORACLE-L I think what you are referring to is the camel [back] cricket, which is also known as the cave cricket. Look here -- http://entweb.clemson.edu/cuentres/cesheets/hhold/ce190.htm and http://www.ent.iastate.edu/ipm/iiin/ccamelcr.html We had alot of them in our basement - and boy, can they jump! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Toepke, Kevin M Sent: Tuesday, March 20, 2001 9:31 AM To: Multiple recipients of list ORACLE-L Subject: RE: Lemon Juice in Ants Pooh-Poohed Kevin, Kevin, Kevin... Don't diss my Cave Crickets. Are you sure they're cave crickets? (They're not even crickets! They're related to the grasshopper) Are the antenea as long as the rest of the body? And even if they are Cave Crickets, they won't bother you. They just come out of the cave to feed. Kevin Toepke Caver and Semi-professional, Semi-competent DBA-type guy P: 614/652-5117 F: 614/652-5401 - The information in this electronic mail message is Cendant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. - The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. - -Original Message- Sent: Tuesday, March 20, 2001 8:26 AM To: Multiple recipients of list ORACLE-L It doesn't matter if they give off a sweet lemony aroma, I am thinking I don't want to eat ants!! The only time I would eat ants is if I was stranded somewhere and had no food. See, I really don't like insects, they bother me, not all of them. A lot of ants sickens me, I am terrified of spiders BIG TIME!! Also, here in Jersey, we have these bugs, they are called cave crickets I believe. Oh man do they freak me out, they look like a mix of a big spider and a cricket!! They jump about 3 feet in the air and are by far one of the ugliest things I have ever seen. I won't go in a room if I know one is in there, I know they can't hurt me, but it's just a phobia. Sorry for getting so far off of the topic! Kev snipsnipouch!snipThat HURTS! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin 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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RE: OT -- A humorous reply to the Canada rulz
Answered your own question, we have more money!!! It's fun to go to Canada and feel like a "wealthy" american. Jeez, I wished I lived in Buffalo, I would go to Canada and hang out and spend less money! hahaah jk, not trying to pick a fight USA RULES -Original Message- Smith Sent: Tuesday, March 20, 2001 1:57 PM To: Multiple recipients of list ORACLE-L First off, I had no idea that a Canadian had invented baseball but a Canadian most definitely invented Basketball. Go look it up. However, he was in the States when he invented it. Once we get rid of Quebec we will have no issues as to what language we are. We are bilingual. Except for Quebec we are accepting of that. Another Canadian trait. As for bikini's, it can actually get quite warm in Canada. I have seen many a bikini. Personally I don't wear one but I would not be cold if I did wear one in the summer. Did you know that there are parts of Canada that are further south then the USA. I actually went up quite a few degrees when I moved from Halifax, NS to Portland, OR. Check it out. And as for us being culturally like the US, don't see it man. We are not nearly as paranoid (generalizing here on in) as Americans. We pay so much more taxes, and we do complain, but the people here bring it to a whole new level. I hear that we are friendlier but I am not so sure of that one. Maybe initially it seems like that because we are not so paranoid and trust right away. Lets see, how many school shooting did we have last year. I know of one but there might have been more. Never been to a school with a metal detector but I do know of one high school that is bigger then a lot of Universities that does have a cop on site. We are much more accepting of technology. Got that one out of the news many times, plus it amazes me some of the things you guys just don't do in the States that we have been doing for years. Our banks carry foreign currency and are much easier to deal with. Almost like they like customers. That has been a big problem for me here in Portland. I could go on but I am sure I pissed many Americans off already. Don't get me wrong, I like the States and am enjoying my time here but we are not Americans! Nor do we want to be. I just want the money:-) -Original Message- Sent: Tuesday, March 20, 2001 10:07 AM To: Multiple recipients of list ORACLE-L U, Is this kinda like Mr. Sulu on Star Trek who was sure that the Russians invented everything? I might be wrong (happens all the time), but I thought Baseball and Basketball were distinctly inventions of the USA. You might be able to tell I'm a rabid fan of neither. Penicillin and the telephone?? Other delusions of grandeur? How about the only country that can't decide if they're English or French? How about the US's biggest colony via cultural conquest(ohh, that's a low blow). How about never saw a bikini except in National Geographic? I could go on, but I'm not sure my humor translates all that well, and the firewall has Babelfish blocked. Dan "not about to give up my day job" -Original Message- Sent: Tuesday, March 20, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Sorry about this, but someone sent me this and I thought it might be relevant to the Canada and US discussion that took place last week. With all the recipes going around, I thought it wouldn't do any harm. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- So, what do Canadians have to be proud of? * Smarties * Crispy Crunch Coffee Crisp * The size of our footballs fields and one less Down * Baseball is Canadian * Lacrosse is Canadian * Hockey is Canadian * Basketball is Canadian * Apple pie is Canadian * Mr. Dress-up kicks Mr. Rogers ass * Tim Hortons kicks Dunkin' Donuts ass * In the war of 1812, started by America, Canadians pushed the Americans back...past their 'White House'. Then we burned it... and most of Washington, under the command of William Lyon McKenzie who was insane and hammered all the time. We got bored because they ran away, so we came home and partied ... Go figure... * Canada has the largest French population that never surrendered to Germany. * We have the largest English population that never ever surrendered or withdrew during any war to anyone, anywhere. * Our civil war was a bar fight that lasted a little over an hour. * The only person who was arrested in our civil war was an American mercenary, who slept in and missed the whole thing...but showed up just in time to get caught. * We knew plaid was cool far before Seattle caught on. * The Hudsons Bay Company once owned over 10% of the earth's surface and is still around as the worlds oldest company * The average dog sled team can kill and devour a full
RE: OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz
And like a lot of Canadian doctors he became an U.S. citizen -Original Message- Sent: Tuesday, March 20, 2001 12:57 PM To: Multiple recipients of list ORACLE-L First off, I had no idea that a Canadian had invented baseball but a Canadian most definitely invented Basketball. Go look it up. However, he was in the States when he invented it. Once we get rid of Quebec we will have no issues as to what language we are. We are bilingual. Except for Quebec we are accepting of that. Another Canadian trait. As for bikini's, it can actually get quite warm in Canada. I have seen many a bikini. Personally I don't wear one but I would not be cold if I did wear one in the summer. Did you know that there are parts of Canada that are further south then the USA. I actually went up quite a few degrees when I moved from Halifax, NS to Portland, OR. Check it out. And as for us being culturally like the US, don't see it man. We are not nearly as paranoid (generalizing here on in) as Americans. We pay so much more taxes, and we do complain, but the people here bring it to a whole new level. I hear that we are friendlier but I am not so sure of that one. Maybe initially it seems like that because we are not so paranoid and trust right away. Lets see, how many school shooting did we have last year. I know of one but there might have been more. Never been to a school with a metal detector but I do know of one high school that is bigger then a lot of Universities that does have a cop on site. We are much more accepting of technology. Got that one out of the news many times, plus it amazes me some of the things you guys just don't do in the States that we have been doing for years. Our banks carry foreign currency and are much easier to deal with. Almost like they like customers. That has been a big problem for me here in Portland. I could go on but I am sure I pissed many Americans off already. Don't get me wrong, I like the States and am enjoying my time here but we are not Americans! Nor do we want to be. I just want the money:-) -Original Message- Sent: Tuesday, March 20, 2001 10:07 AM To: Multiple recipients of list ORACLE-L U, Is this kinda like Mr. Sulu on Star Trek who was sure that the Russians invented everything? I might be wrong (happens all the time), but I thought Baseball and Basketball were distinctly inventions of the USA. You might be able to tell I'm a rabid fan of neither. Penicillin and the telephone?? Other delusions of grandeur? How about the only country that can't decide if they're English or French? How about the US's biggest colony via cultural conquest(ohh, that's a low blow). How about never saw a bikini except in National Geographic? I could go on, but I'm not sure my humor translates all that well, and the firewall has Babelfish blocked. Dan "not about to give up my day job" -Original Message- Sent: Tuesday, March 20, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Sorry about this, but someone sent me this and I thought it might be relevant to the Canada and US discussion that took place last week. With all the recipes going around, I thought it wouldn't do any harm. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- So, what do Canadians have to be proud of? * Smarties * Crispy Crunch Coffee Crisp * The size of our footballs fields and one less Down * Baseball is Canadian * Lacrosse is Canadian * Hockey is Canadian * Basketball is Canadian * Apple pie is Canadian * Mr. Dress-up kicks Mr. Rogers ass * Tim Hortons kicks Dunkin' Donuts ass * In the war of 1812, started by America, Canadians pushed the Americans back...past their 'White House'. Then we burned it... and most of Washington, under the command of William Lyon McKenzie who was insane and hammered all the time. We got bored because they ran away, so we came home and partied ... Go figure... * Canada has the largest French population that never surrendered to Germany. * We have the largest English population that never ever surrendered or withdrew during any war to anyone, anywhere. * Our civil war was a bar fight that lasted a little over an hour. * The only person who was arrested in our civil war was an American mercenary, who slept in and missed the whole thing...but showed up just in time to get caught. * We knew plaid was cool far before Seattle caught on. * The Hudsons Bay Company once owned over 10% of the earth's surface and is still around as the worlds oldest company * The average dog sled team can kill and devour a full grown human in under 3 minutes. * We still know what to do with all the parts of a buffalo. * We don't marry our kin-folk. * We invented
RE: OT -- Canada Rules! / Chocolate ...
The Smarties we are talking about in Canada are much different. Candy covered chocolate. No sour taste at all. Crispy Crunch is a chocolate bar (forget what the inside is, maybe peanut butter). -Original Message- Sent: Tuesday, March 20, 2001 1:30 PM To: Multiple recipients of list ORACLE-L Kathe, I thought every red-blooded American knew what Smarties where. And since I have become the newest OCP (Other Confection Professional), I will enlighten you. Smarties are a "penny" candy, sour in taste about the size of an MM vended in plastic wrap of 12-15 in a stack. I think Crispy Crunch is similar to our Cracker Jacks, but I'll let some of our northern neighbors confirm that. More importantly what was this War of 1812 I keep hearing about ;) Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
