RE: Insert from text file
Another option would be to use perl/VB/shell and format the data into sql insert statements then apply these thru sqlplus. Very low tech and cheesy - but it works. -Original Message- Sent: Tuesday, October 02, 2001 3:14 PM To: Multiple recipients of list ORACLE-L Hi listers, I want to insert a text file in my client machine (Win NT) into emp (empno,ename, salary) table in unix machine from my client. I don't have sqlloader in my machine (client). How to do that ? Can we used utl_file package ? If yes , please give an example because I'm new for utl_file package. The columns in text file are (empno, ename, salary) : A 3000 B 5000 C 4000 Thanks for any clue. Aldi _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: For i (Select..)
The 'For I in...' is an implicit cursor To define/declare a cursor is explicit. I've used both. The 'For i in...' is down, dirty and very fast. -Original Message- Sent: Monday, October 01, 2001 3:50 PM To: Multiple recipients of list ORACLE-L the code IS a cursor --- Csillag Zsolt [EMAIL PROTECTED] wrote: Hi, I've read in Tom Kyte's book the following technique: For i in (Select statement ) Loop Process records here End Loop ; I have tried it and it works great. The question is that what is the difference betwen a cursor and the code above? Which is more efficient? Thank you Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: For i (Select..)
I think you have more 'control' over the explicit cursor. I've seen some nifty little tricks with explicit cursors. -Original Message- Sent: Monday, October 01, 2001 4:15 PM To: Multiple recipients of list ORACLE-L Hi, If this code is a cursor then why doesn't everybody use it this way? For me it seems a lot simplier and easier than declaring a cursor in a normal way. At 14:50 2001.10.01. -0800, you wrote: the code IS a cursor --- Csillag Zsolt [EMAIL PROTECTED] wrote: Hi, I've read in Tom Kyte's book the following technique: For i in (Select statement ) Loop Process records here End Loop ; I have tried it and it works great. The question is that what is the difference betwen a cursor and the code above? Which is more efficient? Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE VS. SYBASE
I've gotten Oracle working with response files on 8.1.7 It does okay. -Original Message- Sent: Monday, September 24, 2001 1:30 PM To: Multiple recipients of list ORACLE-L -- Bryan, Miriam [EMAIL PROTECTED] on 09/24/01 11:53:55 -0800 In your opinion, which one is more robust, better? we need replication and resource management. This comes down to a religious issue in many respects. Each of the databases does things the other doesn't; each does some things differently in ways that make some people [un]happy. I've flushed any use of Oracle until they dump the Universal Installer mainly because it makes getting the product up and running nearly impossible on my systems (try a remote install with it sometime). I'm also not happy that Oracle has replaced quite a few operational methods (e.g., analyze table, svrmgrl) with things that don't seem to work as well on my and other sites. Net resul that they took working methods out of service before the new ones were wrung out the point of production stability. One place to look for traceoffs is the Perl DBI mailing list archives. Even if you don't use DBI itself the list contains good descriptions of what problems people have with various databases. sl -- 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: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Response files for 8.1.7
Anyone have a *working* response file for a minimal install on Linux/Solaris they want to share? The docs are very bare and the error logs are well, not too helpful. TIA john f. lewis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Lots and lots of redo logs
!! Please do not post Off Topic to this List !! AIX has a unique concept of this. Given data spread on a disk. The head will spend more time over the middle tracks as it seeks data that is distributed across the disk. Thus for faster access, place your tablespace on the middle tracks of a disk because the probability that the head will be over it is much greater. Learned this with Syabase on AIX. It may still hold true today. I don't know. Technology had advanced a lot from those day. (But I think the laws of physics are the same ;-)) -Original Message- Sent: Friday, September 14, 2001 10:05 AM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Christopher R. Spence said: Disks are cheap and if you store things on the outer platters performance will suffer? Chris, I'm not sure what you mean here. The concept of Variable Transfer Rate covers this. Stealing a quote from: Optimal Storage Configuration Made Easy, By Juan Loaiza, Oracle Corporation The transfer rate for a disk drive is not the same for all portions of a disk. The outer sectors of a disk drive move by the disk head faster than the inner sections leading to a faster transfer rate for the outer sectors. This is simply because of the circular shape of a disk drive. Scott -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Crabtree INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: more PeopleSoft8 oddities
!! Please do not post Off Topic to this List !! Sheeze! I got a headache just reading your description ;-) -Original Message- Sent: Friday, September 14, 2001 3:02 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! As promised, they just keep coming. Our system was churning out tons of archive logs (at least for us). It was generating about 40-50M an hour at a fairly constant clip throughout the day. We are nowhere near a 24 hour shop so this wasn't user load. It also wasn't scheduled batch jobs (and anyway, those should have shown spikes in log generation). My guess was some wierd chattiness of the application. I took 9 different archive logs ( 3 groups of 3 from different light times. 1,3,4am from 2 days) and loaded them into logminer. I was hoping the same object(s) were being hit over and over again and I could find that via logminer. I also checked to make sure this happened over all loaded logfiles. No such luck, BUT there were only ~2300 DML operations and more than 100,000 commits (about 10/sec). The session_info field in v$logmnr_contents pointed to 3 PeopleSoft processes: PSBRKDSP, PSSUBDSP, PSPUBDSP (I'm glad peoplesoft adds this to their session info). Going to v$sesstat I found that the bulk of 'redo entries', 'redo size', and 'user commits' came from 3 SIDs (The size of user commits was consistent with the 10commits/sec rate, and v$session matched these sids with the same 3 peoplesoft processes). Time for a SQL trace. There were basically 2 pieces of SQL being run over and over (slightly different for each process). A count of 'log file sync' waits in the trace file again matched the commit rate. The SQL for one of the processes was: SELECT TO_CHAR(LASTUPDDTTM,'-MM-DD-HH24.MI.SS.00') FROM PSAPMSGSUBCSYNC WHERE CHNLNAME=:1 SELECT CHNLLOCK FROM PSAPMSGSUBCLOCK WHERE CHNLNAME=:1 FOR UPDATE OF CHNLLOCK Where the bind variables include ACTUAL_TIME APE_INDUSTRY BANK BUDGET_POSITION COMMIT_CNTRL_BUDGET_UPDATE COMPANY_PROPERTY COMPETENCY ... Surprisingly Customer Connection had something on this. It is the default behavior of the Publish/Subscribe feature when configuring the application server. The suggestion is to turn off the Broker servers if your not using them. You can reduce the time interval for which the brokers check in for work... this will reduce the amount of logging but will not eliminate it. To change the Scan interval edit your Domain configuration file, through psadmin, and change the following variable in the dispatcher sections [PSBRKDSP_dflt (publication broker dispatcher), PSSUBDSP_dflt (subscription contract dispatcher) and PSPUBDSP_dflt (publication contract dispatcher)] Scan Interval=10 (currently set to 10 seconds... this is the interval at which the dispatchers check into the database looking for work) Hope this helps. I'm sure they'll be more installments coming. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBAs with 11i and AIX experience needed in Los Angeles
!! Please do not post Off Topic to this List !! I guess I just don't get it. Do they check drivers license at the interview? Would they turn someone down who was willing to move themselves to LA? Could I go and get a fake id? (I had one in high school to buy beer.) You people post the most bizarre things... -Original Message- Sent: Thursday, September 13, 2001 12:00 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! A top manufacturing company located in Westlake Village, California (Greater Los Angeles area) has a requirement for several Oracle DBAs who have 11i and AIX experience to join its' I.T. team. * This company is looking for candidates local to the Greater Los Angeles area only. Candidates not in the LA area cannot be considered. * This position will require 20-30% travel to Asia, so the ability to speak Chinese is a big plus... These are full time staff positions so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. Responsibilities: *Performance tuning, capacity planning and application tuning *Oracle 11, 8 and 8i with Oracle Parallel Server in High Availability AIX environment *Installation and administration of Oracle application databases: Set up of of Oracle databases for custom forms and reports. Set up Oracle applications hot backup, cold backup and disaster recovery. Capacity analysis. User and security administration. Install custom triggers, alerts, reports and forms. Install Oracle network computing architecture, client and server software, and web server. *Install, upgrade, administration, and write shell scripts for Unix-RS6000. Lotus Notes administration is extremely helpful. Requirements: * 4 year degree * 5 years minimum experience in Oracle DBA: * Oracle 11i, 8 and 8i * Parallel Server * AIX experience * Any Lotus Notes administration experience is also a plus. * Willingness for up to 30% overseas travel * U.S. citizenship or permanent residency also required These positions offer: * Stability * The opportunity to become a key member of the team. * Base salary- D.O.E. * Excellent Benefits PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] ph: 1-800 -549-8502 Please use job code One/Westlake/DBA/Tammy All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Quest bought EZSQL
!! Please do not post Off Topic to this List !! I had an email discussion with John Dorn (sp.?), the author, about this. I'll send you the text if you wish? I was really upset about it -Original Message- Sent: Thursday, September 13, 2001 5:05 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Guys, go to www.ezsql.net and read about it. Quest will not sell new licences - apparently EZSQL was bought to suppress competition for TOAD and SQL Navigator. It reminds me Marks explanation about capitalizm - that capitalizm suppress innovations when they are thretening profits. Alex Hillman -- 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: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Any shareware/gnu ER diagramers out there?
Basically looking for something that reads a schema and prints out what tables have FK to what other tables. Dependencies also? I may have a need very soon for one. Thanks - John F. Lewis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Life: is that really OT?
Greg Solomon, Perhaps you're hoping to reach an 'accomodation' with the terrorists? I wonder who Winston Churchill, the great English statesman - who also stood up to terrorists of a different sort - if he were still alive, would he side with your comments? Just wondering. At 05:00 AM 9/12/2001 -0800, you wrote: My deepest sympathies to anyone who has a personal connection to the events that have occurred. It's sad that people are celebrating. Perhaps some of them have their own sorrows and horrors, perhaps some are young and stupid, and perhaps some are just sick or evil or both. But I think we've seen right here on Oracle-L that inappropriate responses are not confined to the Middle East. But saddest of all, IMHO, is the mindview expressed so well by the following comment. We need to be cool, calm, convinced and know what we want to hit - and utterly destroy it. Completely. Well, that's probably a very succinct way of expressing the core beliefs of each of the murderers involved in creating this ghastly mess. To anyone who calls for an air strike anywhere as a result of this, I hope that lots and lots of people stand up and reply, THIS WAS AN AIR STRIKE, YOU IDIOT. This is EXACTLY what you're suggesting should be repeated in someone else's country. Innocent people suffering, lots of them. Many of whom will probably sincerely regret the events of 11th September 2001 and feel no sympathies for those responsible, regardless of what their government may be saying at the time. Perhaps you could be cool, calm, convinced and know what you want your country to ACHIEVE ... and presumably the primary goal is that this tragedy is never repeated, anywhere in the world. I suggest that airport security looks like a good place to start, possibly also the lock on the door from the cabin to the cockpit. Please leave the terror to the terrorists. Again, to those suffering our thoughts are with you. Greg Solomon London UK -Original Message- Sent: Wednesday, 12 September 2001 10:35 To: Multiple recipients of list ORACLE-L Hi Listers Just wanted to express it. Sad about the bombings.. Sadder about people rushing to defend it. Sadder about people rushing to own it! Hope you are all safe. Regards Just another Human -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Greg Solomon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: what is wrong with this timestamp??
Off hand, I'd say you either need to convert the strings to dates or the dates to strings ( to_date/to_char ) -Original Message- Sent: Wednesday, September 12, 2001 2:25 PM To: Multiple recipients of list ORACLE-L set timing on; SELECT SUM(orig_transac_amt), COUNT(1) FROM dsg.ar_open_items WHERE timestamp_date between '06-sep-01 21:22:34' and '06-sep-01 22:01:57' AND user_id_no = 0; Ora-1830?? Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dbms_utility.compile_schema
Ohh... Neat. -Original Message- Sent: Wednesday, September 12, 2001 3:27 PM To: Multiple recipients of list ORACLE-L You know, of course, that 8.1.7 has a script called utlirp.sql, residing in the usual place which compiles ALL INVALID OBJECTS IN THE DATABASE and does so in a logically consistent manner. -Original Message- From: Post, Ethan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 5:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: dbms_utility.compile_schema Excellent solution Charlie! - E -Original Message- Sent: Wednesday, September 12, 2001 1:25 PM To: Multiple recipients of list ORACLE-L When there are mutiple INVALID objects it can be the case that object Z uses object Y which uses object X. If X, Y Z are invalid, you'd need to invoke dbms_utility.compile_schema up to THREE times if the invalid objects are compiled in alphabetical order. My PL/SQL procedure use an invalid object counter and remains in a WHILE LOOP until the current invalid object count equals the previous loop's invalid object count. Once two consecutive dbms_utility.compile_schema results in the same number of invalid objects, then you can exit out of the loop and exit the procedure. Original Message Date: Wed, 12 Sep 2001 10:55:24 -0800 Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Package bodies, procedures, function in packages need to be compiled before packages. DBMS_UTILITY.compile_schemaI believe compiles in Alphabetically order not in functional order. Kathy -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, September 12, 2001 10:11 AM To: Multiple recipients of list ORACLE-L Is there something wrong with dbms_utility.compile_schema . When I tried to use it , I left with few invalid objects . But if I manually compile those objects using alter package *** . they get compiled .Any Idea why ? BIgP Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
RE: STOP THE PRESS!!
The Stealth fighters are an expensive, sad joke. They were developed to counter Soviet tanks rumbling across Germany. The problem is - Who do we strike? It's not like the good ol' days when the enemy all lived in one country and wore the same uniform. Things are very fuzzy now. This is a an attack to frustrate us. To make the the U.S. strike out mindlessly. We need to be cool, calm, convinced and know what we want to hit - and utterly destroy it. Completely. We are not at risk from rougue states with nuclear missles (You just don't get it, George). It's the terrorist fanatics with a suitcase and a warped purpose that's our biggest threat. -Original Message- Sent: Tuesday, September 11, 2001 10:16 AM To: Multiple recipients of list ORACLE-L friend of mine just saw Bush's plane, flying super low and surrounded by *stealth fighters* heading for Andrews' Man, I hope there is a R E S P O N S E to this, and soon. -Original Message- Sent: Tuesday, September 11, 2001 11:50 AM To: Multiple recipients of list ORACLE-L I am wondering whether this was an attack from outside, or from people like Timothy McVeigh. It seems to be awfully well co-ordinated, how could they breach security to that extent. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db engines VS flat files
I think it's one of those things that if you have to ask then... -Original Message- Sent: Sunday, September 09, 2001 12:40 PM To: Multiple recipients of list ORACLE-L I would like to know your opinion about the developments under for example perl for handling large amounts of datas (sets of flats files larger than 50 gigs) vs the option of using oracle for exmaple for doing the same task, wich would be more eficinet? why? cheers 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 do not re-send by any reazon in any way or form any of the informatino here contained. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: agc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: Interesting News..
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Egregious coding
Title: Egregious coding You can put "cursor_sharing=force" in the init file. It forces the reuse of sql even without bind variables. I had the same problem with the "javoids". -Original Message-From: Hagedorn, Linda [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 06, 2001 4:06 PMTo: Multiple recipients of list ORACLE-LSubject: Egregious coding Has anyone thought of a clever way to fail every SQL statement that does not use a bind variable that I could switch on and off as required? I'm looking at hundreds of thousands of queries in the v$sqlarea in production. I've taken engineering management to task over this, and have gotten empty promises in return. I would love to hold a valid threat over their heads that I'm going to shut off every statement that is not coded properly. Any ideas are appreciated. Linda
RE: Oracle DBA Leader Needed in Beaumont, Texas..
As an ex-Texan, and related to many in the Orange-Beaumont-Port Arthur area, I'll excuse myself from this discussion ;-) -Original Message- Sent: Wednesday, September 05, 2001 1:13 PM To: Multiple recipients of list ORACLE-L No thank you. Beware! Beaumont is the arm-pit of hell... --Scott OraStaff wrote: This company is located in Beaumont, Texas and needs an Oracle DBA team leader to join its' I.T. staff. Selected candidate must have leadership skills to lead a team of 4 or 5 developers and junior DBAs'. This company is currently running Oracle 7.3 and 8.0 on VMS and 8.1.5 on NT.. migrating to 8.1.7 on UNIX platforms. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. * Requirements: - 3+ Years Oracle DBA experience - Leadership skills and/or experience - B.S. in Computer Science or related technical discipline. - Oracle certification is a huge plus - U.S. citizenship or Permanent residency is also required These positions offer: * Stability * The opportunity to become a key member of the team. * Base salary-D.O.E. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] ph: 1-800 -549-8502 Please use job code One/Beaumont/DBA Leader/Kari All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Notification when something changes in the DB
For whatever reasons this solutions was found to be not sound by a 3rd party consulting company which reccommended Oracle native technology to perform this check. Hmm... a trigger seem native to me. Perhaps they meant auditing. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 2:33 PM To: Multiple recipients of list ORACLE-L Hello fellow DBAs', I have a weird question that I was asked. My first reaction was to answer: There is no such thing, however I was talked into posting this question here :-) 1. An applicaiton selects certain records (from different tables) from a database.. 2. When time comes to update some of these records in the datbase application needs to know if records that it's about to update have been modified by some other user. 3. Currently this is achieved with via triggers. Before performing an update application checks if trigger updated a certain field in the database which serves as an indication that records/fields of interest have been updated. For whatever reasons this solutions was found to be not sound by a 3rd party consulting company which reccommended Oracle native technology to perform this check. This company is now unreachable and management is requesting to change the application to follow this review. Management explanation of how it needs to be done is based on what ADO would do where if you perform an optimistoc lock and then later on try to update an already updated record it would tell you about this upfront., or you would be able to check upfront WITHOUT requiring the DB. I am not familiar with ADO, that much so I can not comment on it. Can somebody tell me if they can think of way to achieve this? I know it sounds rather weird request -- it is. Thanks in advance for any thoughts on this, Val Gamerman. Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tricky Hierarchical Query
Oracle has a very good section on prior and connect by. These combined level let you walk a tree - so to speak. I use them all the time. Look up the key words. You'll find it. -Original Message- Sent: Friday, August 31, 2001 12:07 PM To: Multiple recipients of list ORACLE-L Hi, I am stumped on how to do a particular hierarchical query. The query needs to be written entirely in SQL. I have a table (ACCOUNT) with 3 columns of interest in it, ACCOUNT_ID, ROOT_ID, PARENT_ID. Every row represents an account. If an account is the root (top-most), then the ROOT_ID and PARENT_ID columns are null. If an account is a parent, then the ROOT_ID is populated but the PARENT_ID is null. Accounts can be nested multiple levels deep. I need to find all of the accounts that belong to the root of the given account but not include any accounts that are children of the given account. Does this make sense? I.e. 5 6 7 8 9 10 11 1213 14 I'm not sure if my tree diagram will be dispalyed properly after I email this but in essence if 8 is the given account number, I want everything returned except for 8, 11 and 12. Thanks in advance! -w __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to Sql Server
Title: Message You may need to do some tweeking of the tables - but most every table/view moves fine. It will not move pl/sql or triggers. -Original Message-From: Walthour, Jon (GEAE, Compaq) [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 10:27 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle to Sql Server Easy. Use SQL*Server's DTS (data transformation services) to pull the data from Oracle into SQL*Server. Jon Walthour -Original Message-From: Apps Sol [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 12:07 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle to Sql Server Hello Folks, I am looking for some cool script to move all the database objects across from Oracle 8.1.7 to Latest Sql Server (ver ???) frequently. Is there any particular way we can do it to automate this ?? BTW: I want to pledge $20 or even willing to pay yearly subscription and it would be a good idea to Send out a Pledge form to everyone . to keep the greens coming.. Cheers RK
RE: Oracle DBA With Internet Experience Needed in Harrisburg, PA
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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/intl.asp -- 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). The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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/intl.asp -- 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: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: financial problems with fatcity.com
Title: RE: financial problems with fatcity.com And.. uh... Ivan, Please don't feel like you have to share any more lap dancing experiences. ;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 29, 2001 9:51 AMTo: Multiple recipients of list ORACLE-LSubject: RE: financial problems with fatcity.com Alex, that is an excellent idea! I second that notion. I have learned just as much if not more from this list than the average $40-80 dba book out there (101 tuning and dba excluded, I've just ordered practical 8i and await that one). I think we can easily come up with the $500 a month figure, and that's this list alone. If you sum up all the rest of the lists...Bruce may be able to bring it down to 6 bucks a year maybe. 12 bucks a yearsh*t (Ladies forgive me here, I'm just a young buck trying to make a point) I've spent more than that for a lap dance and that was only to have someone rub an @ss on me, where you all have saved MY @SS literally more than once!!! This list is invaluable. Put me down for 12 bucks a year. Ivan ps. I by no means wanted to offend anyone, if so I am sorry and please forgive me. ;) Long Live the List! -Original Message- From: Hillman, Alex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Subject: financial problems with fatcity.com I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- 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: !! *Very* important Oracle-L message !!
around being able to generate quite a bit of additional income per month, and very soon. In an effort to be open and up-front with you folks about this, I basically need to generate an additional $500 more per month. Right now that seems daunting, but I've been working hard to line up that additional income, and I believe I can do it. Just not right away. My estimates are that it will take me four or five months to come up to that level. I need to get out there and sell website hosting and list hosting packages, and get new customers. That takes time, unfortunately. I need a buffer to enable me to get past this startup phase. After some discussions with Jared (the list owner), and some encouragement from him, I am coming to you to ask for you help in keeping Fat City financially afloat until I can be self sufficient. I'm not asking for a specific dollar amount from anyone, nor am I *expecting* anything from you folks. But if it is within your power to contribute some money towards this end (and yes, I know these are hard financial times for everyone), I am hoping you can help. If I can get sufficient promise of funds that will see me through the next few months, I am willing to jump in with both feet and make Fat City a viable business. If it looks like the contributions are not sufficient to enable me to do that, I will cease operations within the next 45-60 days. Let me be clear about a few things: If I *do* cease operations, I will give all of my lists time to find new list providers, and will make every effort to aid the shift over to the new provider, provide list dumps, archives, mail forwarding, etc. Even though Rhythms goes out of business on 10-Sep-2001, I have secured service until at least 10-Oct-2001 to enable this to happen. So don't worry about having to rush into your conversion if things don't work out. I would also like to clearly state that this is not some attempt to blackmail or coerce anyone into coming up with money. This will either succeed or fail based on what you folks can comfortably and willingly contribute. If I had the ability to cover this startup period myself, I would definitely do so. If Fat City ultimately goes under, it wil NOT be === message truncated === __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mohammed bhatti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i Linux files are erroring during uncompress...
I had a similar problem getting 817nt from OTN. I had to download the file to linux - run gunzip. then I tar'd it up again and copy to NT - where I used a DOS tar program to un-tar it. Sheeze! Very painful. -Original Message- Sent: Monday, August 27, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Using Windoze, I downloaded the three Oracle 9i Linux files from technet.oracle.com. I then rebooted into Suse, copied the files over, but gunzip is not recognizing the files. I switched back to Windoze and using Winzip it doesnt like the files either. So I redownloaded just the smaller third file and neither will uncompress the file. Am I missing something here? I would download the files from SuSE but I can't get my DSL modem to work, so I have been downloading the files using Windoze. Could that be the problem?? TIA!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i Linux files are erroring during uncompress...
Odd thing is that linux/solaris files come down correctly. And I've down-loaded other zips for NT in the past with no problems. This seems like a recent problem. -Original Message- Sent: Monday, August 27, 2001 11:01 AM To: Multiple recipients of list ORACLE-L If you do not use a download manager like getright, you will almost always download broken files. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, August 27, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Using Windoze, I downloaded the three Oracle 9i Linux files from technet.oracle.com. I then rebooted into Suse, copied the files over, but gunzip is not recognizing the files. I switched back to Windoze and using Winzip it doesnt like the files either. So I redownloaded just the smaller third file and neither will uncompress the file. Am I missing something here? I would download the files from SuSE but I can't get my DSL modem to work, so I have been downloading the files using Windoze. Could that be the problem?? TIA!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do you audit a DBA?
'..fire him, not the trigger.' ver-y clever. -Original Message- Sent: Thursday, August 23, 2001 9:47 AM To: Multiple recipients of list ORACLE-L Oh hell, if you don't trust him, just fire him, not the trigger. -Original Message- Sent: Thursday, August 23, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Anyone who can help, I've been asked if Oracle can somehow audit the DBA ie. Raise an alert if the DBA were to execute DML statements against sensitive tables, this assumes the DBA has the SYS password. I thought this was a pretty reasonable question but couldn't think of an answer. My trail of though was maybe an email alert to a designated member of staff sent via a trigger on the table. Any comments would be very appreciated. Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT:I was thrown out of the list
Was this really necessary? -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 1:16 PMTo: Multiple recipients of list ORACLE-LSubject: Re: OT:I was thrown out of the list it was cozur anoviceOracle Certifiable DBBS joe [EMAIL PROTECTED] 08/09/01 12:44PM Hi, I did not receive a mail for two days, I started smelling rat and sent a test mail to the list. I was told I am not a member. Is it some revamping happening or I was thrown out because did people start receiving viruses from my id ??? list administrator please help jared bruce please explain cozI am anoviceOracle Certifiable DBBS
RE: OT Dorothy Parker :)
We did that about 8 months ago. 'They' promised my load would not increase. Hah! I'm looking for another position now. Problem is, it's a tight market. -Original Message- Sent: Thursday, August 09, 2001 3:36 PM To: Multiple recipients of list ORACLE-L Congratulations on your survival Shrek. Having more work is better than having NO work. -Original Message- Sent: Thursday, August 09, 2001 4:46 PM To: Multiple recipients of list ORACLE-L geez, is it friday yet? i hope so, cuz we just got done laying off 25% of the people here. same work + less people := get-out-of-dodge-NOW. -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] One ping to rule them all, One ping to find them, One ping to bring them all, And in the MUTX bind them. MIPS: Meaningless Indicator of Processor Speed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Documentation for pricing database
That's because what Oracle charges is an intricate formula involving the day of the week, the number of caribou currently calving and your height. (I may have exaggerated about the caribou part) -Original Message- Sent: Wednesday, August 01, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Hi Gurus, Can anyone suggest some kind of documentation I can use to develop a pricing/costing database in Oracle? I have been looking around for a reference manula but they are quite general. Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Can't code for s.... peanuts
I'm no
fucntion guru - BUT - I don't think they are stand-alone. You
need
to use
them in a sql statement.
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 23,
2001 11:27 AMTo: Multiple recipients of list
ORACLE-LSubject: Can't code for s peanuts
Hi again everybody,
I'll try to be as descriptive as possible, sorry
if I leave anything important out.
I have the following function which I'm compiling
using PL/SQL Developer (tnx Djordje).
CREATE OR REPLACE FUNCTION check_for_name
(p_name_to_check VARCHAR)RETURN BOOLEAN
ISCURSOR c_namestbl ISSELECT
lnameFROM namesWHERE lname =
p_name_to_check;v_return_value
BOOLEAN;BEGINOPEN c_namestbl;IF
c_namestbl%NOTFOUND THENv_return_value :=
FALSE;ELSIF C_namestbl%FOUND
THENv_return_value := TRUE; END
IF;RETURN v_return_value;CLOSE
c_namestbl;END check_for_name;
It compiles without errors (now).
The table 'names' is built like this :
SVRMGR DESCRIBE names;Column
Name
Null? Type--
FNAME
VARCHAR2(20)LNAME
VARCHAR2(20)SVRMGR
With data like this :
SVRMGR SELECT * FROM
names;FNAME
LNAME
Bruce
WillisSalma
HayekTom
CruiseElle
McPherson4 rows selected.
But, whenever I try to do this :
EXECUTE check_for_name('Cruise');
so I can run the function from PL/SQL Developer I
get the following error :
"ORA 0900 - Invalid SQL Statment"
However, If I execute the same statement from
SQL*Plus or svrmgrl I get a differant error :
SVRMGR EXECUTE
check_for_name('Cruise');check_for_name('Cruise');*ORA-06550:
line 2, column 2:PLS-00221: 'CHECK_FOR_NAME' is not a procedure or is
undefinedORA-06550: line 2, column 2:PL/SQL: Statement
ignored
I'm running Oracle Enterprise Edition 8.1.5.0.0 on
Windows 2000.
If that's not enough info, please let me know and I
will supply whatever I can.
Thanks for reading this far :)
Michael.
RE: dbassist ???
Make sure you have the solaris memory parameters set properly. If in doubt, generate the scripts - run them one at a time. -Original Message- Sent: Thursday, July 19, 2001 2:41 PM To: Multiple recipients of list ORACLE-L Hi, Does anybody has any luck running 815 dbassist to create a database on Sun 5.6? When I runned it, the first couple of pages work fine, then it stuck at creating database page, the status bar shows 0% for a long while. Eventually I killed it. I used this tool a while ago to save the creating db code in a script, but that script didn't run well either. Any suggestion? Janet __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle listener security patch -
Just installed p1859778_8162_Solaris patch for listener security problems. Before I installed it - everything was hunky-dory. Afterwards the listener wouldn't start any 'services'. Haven't tried metallink yet. Anybody had this problem? (Using 8.1.6.2 on Sun Solaris) TIA - john f. lewis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: alert log is not capturing all errors
You may be thinking of Sybase. That is one neat feature about it. [EMAIL PROTECTED] 07/12/01 12:35PM Hi List,I have encountered a little strange incident. Here is a brief:I ran a package which runs every day early in the morning. I create a logof the process through the spool command.Today my package didn't run. It had an error saying 'ERROR at line 1: ORA-04068: existing state of packages has been discarded' . Anyway, not abig deal. I think I eliminated the error.The thing that puzzles me is that error IS NOT in the alert log. I had animpression that alert log would capture ALL of the errors occurring on thesystem. Isn't it the case?Thank you for your support.Lyuda Hoska-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: 9i standby
') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: * Oracle DBA Needed in Phoenix..
Ditto. This 'renter' thing sounds like some sort of thinly veiled discrimination. -Original Message- Sent: Thursday, July 05, 2001 2:41 PM To: Multiple recipients of list ORACLE-L Thursday, July 05, 2001, 4:15:20 PM, you wrote: O We would like to submit someone who is a renter and who is interested O in Phoenix but has not applied to Phoenix companies and is not working with O other recruiters for Phoenix companies. Now why in the world would any of this matter? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CURSOR_SHARING = FORCE ques.
Ditto here. It solves the re-coding-using-vars problem. The java programmers are such whiners (I hope none of them read this list!). -Original Message- Sent: Monday, July 02, 2001 6:05 PM To: Multiple recipients of list ORACLE-L 2) Anyone out there using it? Does it give that much better performance gains? It seems to me like it's not worth implementing. we're using it, on 8.1.6 No problems so far, and it relieved the problem of not being able to get a chunk of memory for the shared pool and having to flush. My programmers wrote their code using constants... on insert statements in a registration system. So my sqlarea was getting filled with identical statements, except for the value of the constant. Rather than make them recode (trust me, I would have had to get the rack and thumbscrews out to make that happen), I turned on cursor_sharing=force and it's worked like a dream. Rachel _ 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: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Limiting Oracle Memory
Hmmm... Why keep the pl/sql table in memory? Why not just a regular table that's cached (sp.?) -Original Message- Sent: Thursday, June 21, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Hi all, I have a procedure that seems to be bringing my server to it's knees. Winnt, Oracle 817 (Pipe down Ross:)) Anyway, what happens is a pl/sql table is placed into memory and then later on it will be written to the disk. However, by the time the process is about to get to the writing part the machine is dead. The Oracle.exe process is well over 700MBs and the Virtual Memory is over a gig and a half!! Is there anyway for me to limit this, I tried using the registry entry ORA_WORKINGSETMAX, however that doesn't seem to work. Has anyone used this setting? Are you just supposed to put a number in the entry? I put 600 but nothing happens. Any help would be greatly appreciated. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Working from home
How did you handle accountability? If they can't trust you to do your work find another company. And have some set goals you want to accomplish. How did you handle communication between work and home? Email, cellphone What were some of the unforeseen problems that you encountered? Sometimes you can't get an answer unless you're in someones face Were there any specific company benefits? I get more done at home than at work. Especially defined tasks like exp/imp, triggers, procedures etc.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Regarding the Prior thread about SQL/Database tools
I use both Toad and EZSQL. Mostly Toad. Lately I have been drilling down into the many neat things EZSQL does and discovering hidden gems. We paid $500 for Toad and $50 for EZSQL. EZSQL is a true bargain. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Space Estimation (numbers)
Oracle stores the avg_row_length in all_tables view. Use analyze_schema to get the most recent numbers. -Original Message- Sent: Monday, May 21, 2001 12:12 PM To: Multiple recipients of list ORACLE-L Thanks for the info. I know about the VSIZE function, but how do I estimate the amount of space manually? What about negatives, fractional values, etc.? These all require differing amounts of space. Thanks again. Walt --- Toepke, Kevin M [EMAIL PROTECTED] wrote: Walter: You use the VSIZE() function. And you are right about 1 not taking the same amount of size as 9. 1 uses 2 bytes and 9 uses 4. SQL select vsize(1), vsize(9) from dual; VSIZE(1) VSIZE(9) 24 Kevin -Original Message- Sent: Monday, May 21, 2001 1:56 PM To: Multiple recipients of list ORACLE-L Hi, How do I calculate the amount of physical space required for storing a number? (i.e. NUMBER, NUMBER(5), NUMBER(10,5), etc.) I believe Oracle uses 2's compliment for storing numbers. A value of 1 does not seem to take up the same amount of space as 9. TIA! -wk __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ....A drop schema script ??
Login in as system: drop user user_name cascade; -Original Message- Sent: Thursday, May 17, 2001 12:26 PM To: Multiple recipients of list ORACLE-L All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Mean/Median
Thanks to all... -Original Message- Sent: Tuesday, May 15, 2001 10:27 AM To: Multiple recipients of list ORACLE-L geez louise, Median := avg(Max,Min) || -Original Message- || From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] || Sent: Monday, May 14, 2001 10:56 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: Mean/Median || || || || || Any scripts (sql or pl/sql) out there to compute various || statistical things || in Oracle? || || || Would depend on just what you are looking for. A quick look at || Oracle's SQL functions showed avg, st. deviation, and variance || although no median but that should be easier to write than || some of the || others. || ||Pat || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Pat Hildebrand || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: a bit of a brag...
Wonderful. But now I really feel old! -Original Message- Sent: Monday, May 14, 2001 1:51 PM To: Multiple recipients of list ORACLE-L Congratulations. Apparently you did a great job. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Thater, William [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 4:20 PM To: Multiple recipients of list ORACLE-L Subject: OT: a bit of a brag... My eldest graduated from college Saturday. A double major in Spanish and German, cum laude, and a Fullbright scholar. I'm proud of the boy!;-) Follow the link below for a nice picture and a little blurb. http://www.naz.edu/academics/fulbright/scholars.cfm -- 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. ~~ Microwave: Signal from a friendly micro... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anybody Using Veritas Database Edition
We use Veritas. And are very happy with it. I'm not sure which 'flavor'. If you're interested I'll give you the email of our systems guru. Respond to my email. -Original Message- Sent: Wednesday, May 09, 2001 10:27 AM To: Multiple recipients of list ORACLE-L Greetings, We are evaluating Veritas Database Edition and we are scheduled to meet with their technical people for a presentation next week. I have to say it looks pretty good on paper. Has anyone on the list used this product before? I would like to know from the other users how the product perform for a medium shop ( 35 databases sized from 2g to 140g ) like us. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sorry,
Geeze! It's getting a little vicious here. -Original Message- Sent: Monday, May 07, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Learn how to spell! -Original Message- Sent: May 07, 2001 4:53 PM To: Multiple recipients of list ORACLE-L i was trying to get commands from listguru and obviously typed the wrong address ...and no Mr. Hutchins, an idiot would be the jerk who sends that type of misanthropic respone to an obvious error. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hutchins, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: move schema away from system table space
1. Export the user's schema ( exp help=y ) 2. issue in sqlplus: drop user_name cascade; 3. then remake the user with the new table space as the default tablespace ( all permissions there - none elsewhere ). 4. imp the user from the export dump with ignore=y regards - john f. lewis -Original Message- Sent: Tuesday, April 17, 2001 3:50 PM To: Multiple recipients of list ORACLE-L Hi All, I need to move a user/schema away from the system tablespace to a newly created user tablespace. Could somebody point me to the references on how to do the job? Since a production server is running off the schema, is it possible to do the move without having to shut down the server? Thanks a lot. WL __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lwm INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do not belive BUSH and your army goverment so much
Perhaps we should keep ideologies/politics off of this list. If anyone (Chinese or American) wants to debate they are lots of other lists set up for that. Take it there. I'm here for Oracle not bashing. regards - john f. lewis -Original Message- Sent: Monday, April 16, 2001 2:21 PM To: Multiple recipients of list ORACLE-L right now, I understand US people also just belive TV or news. The news always controlled by goverment or service for the goverment. This fact is for sure that US is high-handed and arbitrary. US army fly to all over the world and control all the world. I hate this but I feel so frustrated that US army is No.1 in this world and all over the world can not even say a "NO" to US. Right now, I know many US people do not understand Chinese, Chinese do love peace very much. Many things, these days, China are better than US now. You should go and have a look in China. Do not be so stupid and arbitrary. Do not belive BUSH and your army goverment so much. When the army is so good, they want to invade China or some other coutries. I hate China does not have good people rights. But I hate US is so impolite when they know they will win on every army fight. What I have forcasted are becoming true now. When BUSH was selected as president. I forcasted he would make many bad things and use his army. Today I forcast he will invade China more and put all Chinese in extreme misery. He will because he is the people who care too much about army...He do not care about high-tech, you are losing your good salary now...You have lose you stock options. Just one more fact, yesterday I watched the TV, the announcer used intimidatory voice that made very unhappy, "fuck you", I growl to the TV. Just because you have the No.1 army so you can do all the things? Sorry for this post because it is not about ORACLE. If US and China finish the relationship, at least 10% more of you will lose your job. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 1:20 PM They ought to learn flying their bikes from ET.. leave fighter plane flying to others.. -Kirti -Original Message- From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 2:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: stupid DBA Well, according to the stereotype, they aren't very good drivers, so maybe it was inevitable. ep [EMAIL PROTECTED] 04/14 6:15 PM How was it mean? Considering how well they seem to do their job, it would be a heck of a lot easier to become a Chinese fighter pilot than a nurse. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Canada and U.S. (was: oracle and America)
or other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NOVELL
You'll be using Dr. DOS next. -Original Message- Sent: Tuesday, March 13, 2001 9:46 AM To: Multiple recipients of list ORACLE-L Wow, we've just been bought out by Novell. Novell?? I haven't even thought about them for at least 3-4 years. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Removing files with PL/SQL
Sure. use utl_file utility. Write to a file , that another process reads, have it execute the command. Minor security hole but, it will work. Need to make parse strings so nothing 'bad' gets written to the file. Or Have a process, read a table that has files to be deleted ( we use this in house) -Original Message- Sent: Friday, March 02, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Good suggestion, but 'host' only works within SQLPLUS (unless I am mistaken). Any other ideas? Alan -Original Message- Sent: Friday, March 02, 2001 12:56 PM To: Multiple recipients of list ORACLE-L How about the host command. This will shell out to the os and process the command. host erase c:\my_dir\my_file.txt [EMAIL PROTECTED] 03/02/01 02:32PM Hey listers, Does anyone know of a way to remove files from an O/S file system using PL/SQL without calling a java or an external C routine? Thanks, Alan Alan Aschenbrenner Oracle DBA IHS Group (303)-858-6394 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OFFTOPIC: Spam.
H... "Primative (excessive) but effective" -Original Message- Sent: Thursday, February 15, 2001 12:45 PM To: Multiple recipients of list ORACLE-L I think publishing the spammer's home address and phone number is excessive. What do you think, that we're all going to go over there and picket? Or start calling and asking if he has Prince Albert in a can? Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Thursday, February 15, 2001 3:17 PM To: Multiple recipients of list ORACLE-L No offense all, but I don't see why everyone is so upset about this email. It pertained to Oracle and we recieved it once. It's as if I recieved an interesting email and sent it to all of you, why so upset? -Original Message- Mengler Sent: Thursday, February 15, 2001 2:58 PM To: Multiple recipients of list ORACLE-L AFAIK - The spammer's home info is 800 Michelle Court Lanoka Harbor, NJ 08734-1828 609 971 7296 Below is the reponse I got from my nasty-gram to [EMAIL PROTECTED] I hope that he's learned his lesson won't spam us again. Thank you for your report. While we are not allowed to give out specific information regarding subscriber identity, or specific action taken without legal process, we have identified the offending user and taken appropriate action against this account. For more information regarding our Acceptable Use Policy, please see the following URL: http://www.home.net/aup @Home Network Policy Management Team -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct 858-831-2229 San Diego, CA 92131 HOME DEPOT - The Big Boy's Toy store! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
