Re: completely off-topic question...
hth=hope that helps. joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT:(Unix Q): Re-executing an old command
I'm using ksh. From the Unix prompt I do history which displays the last 170 commands I did. I would like to re-run #55 in the list (which happens to be a rm with a lot of arguments). How do I do it? I tried doing ESC-K then /rm to find it but it didn't. Usually it does. Thanks, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ip restriction help
Hi Gurus, I would like to get your recommendation for connection restriction to the databases via tcp/ip based on ip addresses. The restriction is required for only the databases that is served by one listener, not the other. Any suggestions are welcome: OS, Oracle, network... Sun Solaris 2.7 Oracle EE 8.1.6.3.0 two listeners on the same server: listener1 serves a set of databases that has MTS setup, listener2 listens for a set of databases that is configured for dedicated connections. Thanks, Sharon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xiaohong Yang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Question
select table_name from dba_tables where table_name like 'EDL_WORK_%' and I received the following TABLE_NAME - EDL_WORKSTATION_LOCATION EDL_WORK_AR_ENTITIES Why would I be receiving the first record (EDL_WORKSTATION) if I try EDL_WORK_A% I get the correct result. Is there something about the _% combination ? _ is the wild card for matching any single character. Therefore, as long as there is at least one character _% and % will return the same thing. 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).
Master/master with diff username possible ?
Hello, We are running 8.1.7 on Solaris 8 on E4500. We need to replicate one table from one schema to 3 other schema and the replicate these 3 schemas to other sites. We can't use snapshot on snapshots because Oracle will do a complete refresh each time. Is there any trick to replicate to different schema with master/master. If you have any advice please let me know. Thanks H. Ekenberg --- Experience is a hard teacher because she gives the test first, the lesson afterward. -- Vernon Law H.Ekenberg Anoto AB E-mail :[EMAIL PROTECTED] Tel +46 (0)8 410 78 500 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 -- suggestions to ensure nerdiness in potential IT staff
Title: RE: OT -- suggestions to ensure nerdiness in potential IT staff Sorry for the last email, I didn't mean to send it to the list. If anyone by chance read the whole thing and has any questions, feedback or advice I welcome it all. Again sorry for the long message. Ivan
Re: Import Issue/question
That you have to do on your own by analyzing the tables and indexes after the import is finished. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 01, 2001 4:37 PM What about generating statistics? Mike Hand Polaroid Corp -Original Message- Hi, What is the Import utility doing exactly after it says the rows of a table have been imported? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Management server??
break out the docs on oem. you have to set it up but MOST not all of OEM stuff will run standalone w/o a management server. joe Raghu Kota wrote: Hi Friends When Iam starting my Enterprise Manger console, Its asking Oracle Management server??? What is that?? I tried with giving host name, But it did't work?? How to connect my EPM?? 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) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: truncate during query
Sorry, but when issuing a query, you can drop an index or truncate table. Because select places a LOCK Null. Regards. --- Mark Leith [EMAIL PROTECTED] wrote: It will fail and you will get an : ORA-00054: resource busy and acquire with NOWAIT specified Been there - done that - got the mug and t-shirt..:) HTH Mark -Original Message- Sent: Thursday, August 02, 2001 10:15 To: Multiple recipients of list ORACLE-L Hi What happens if you truncate a table, or drop an index, that is currently in use by a long running query? Does the query fail or does the truncate/drop hang up? Thanks in advance, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Advanced Queues
SET ORACLE-L DIGEST -Original Message- Sent: Friday, August 03, 2001 6:52 AM To: Multiple recipients of list ORACLE-L I just started looking into Advanced Queues and I'm wondering what types of apps they're used for? What would be their biggest advantage? Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: truncate during query
It will fail and you will get an : ORA-00054: resource busy and acquire with NOWAIT specified Been there - done that - got the mug and t-shirt..:) HTH Mark -Original Message- Sent: Thursday, August 02, 2001 10:15 To: Multiple recipients of list ORACLE-L Hi What happens if you truncate a table, or drop an index, that is currently in use by a long running query? Does the query fail or does the truncate/drop hang up? Thanks in advance, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i
9i will give you the option to let them manage the undo tablespace and segments (newspeak does not call them rollback anymore). But you can still define and manage your own From: Kevin Kostyszyn [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 9i Date: Thu, 02 Aug 2001 11:55:34 -0800 Uhhh...I thought that 9i wasn't going to be using rollback segments anymore? Am I wrong, was this alcohol induced dream or something like that? 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). _ 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).
Re: OT -- suggestions to ensure nerdiness in potential IT staff
Title: RE: OT -- suggestions to ensure nerdiness in potential IT staff I think that's awesome Ivan!!! KK - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, August 02, 2001 6:51 PM Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff Famous...I hope at least recognized by my deeds. It's funny this is coming up, I am currently in the middle of starting a dream of mine. Basically I am starting a non profit organization designed to teach these hot in demand IT skills to a resource this country has overlooked-young inner city minorities. I know there are people already trying to do similar stuff and oracle has there program they're working on with high schools, but I feel that my business plan and ideas will be superior to what's currently out there, not to mention that I will have an execution plan these kids will latch onto, different from the traditional high school setting they're tired of. I feel that I am an example of what I can do with them, as I said I didn't go to college for CIS, am not a super brain, but I had an interest in computers and also a hunger to make a good living (legally). In the span of three years I have fully changed around my life. I now make good money (I am currently putting my sister through college) and am living a great clean life. Oracle literally kept me out of jail (no need to go into specifics)! I feel this IT route is a new alternative for inner city youth to make it out of the 'hood. This is a more realistic manner to a good life than the traditional routes of making it big in: sports,music,entertainment or going the wrong route and getting into dealing drugs. I am living just as good as most of the drug dealers I know or have come in contact with and being realistic here, these guys are looked up to by the younger kids in the neighborhood. As a kid I always looked up to them and still see the same thing going on today. If I can get these kids to see a different way to attain the same possessions the dealers have (for the most part, that's what it boils down to-money and material objects) and get some in the IT field, I've done my job. I have been teaching the DBA track here at FSU for the last in preparation for the stated above goal and have started to recruit people for the board and also to teach. Today, in fact I received the conformation that I have been given education consent from the New York State Department of Education (yes!), next comes the 501(c) and I'll be quitting my job hoping to get this thing off the ground. In fact Rachel I have had you in mind to ask to join my board but haven't approach or asked the board for input until I was 'official'. Sorry for ranting, any advice (good or bad) will be greatly appreciated. Thanks. Ivan
Re: Management server??
You need to install it. The Console talks to a Management Server, which in turn manages the agents and other processes that monitor the database etc. You really oughtta read the basic installation manual. Not much, just like the first page or two might help. Raghu Kota wrote: Hi Friends When Iam starting my Enterprise Manger console, Its asking Oracle Management server??? What is that?? I tried with giving host name, But it did't work?? How to connect my EPM?? 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). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: completely off-topic question...
Or Happy To Help ... Also ... YMMV - Your Mileage May Vary (this took me FOREVER to guess) LOL - laughing out loud RTM - read the manual RTFM - read the Fine manual IMHO - in my humble opinion OR in my honest opinion OT - Off topic Babette - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 1:02 AM hope this helps hth yosi Michael wrote: ...which means it's probably going to start a great big thread :) I see a lot of emails with HTH on them, seemingly some sort of way to say thankyou or something... as they're always at the end of somebodies message right before they sign off their name.. I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ? Thanks,Michael. -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: completely off-topic question...
www.acronymfinder.com Hope This Helps! Michael wrote: ...which means it's probably going to start a great big thread :)I see a lot of emails with HTH on them, seemingly some sort of way to say "thankyou" or something... as they're always at the end of somebodies message right before they sign off their name..I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ?Thanks,Michael.
Re: completely off-topic question...
Main Entry: SOS Pronunciation: es-()O-'es Function: noun Date: 1910 1 : an internationally recognized signal of distress in radio code · · · - - - · · · used especially by ships calling for help 2 : a call or request for help or rescue - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 9:40 AM now i thought it meant 'Same Old Sh*t' or what we would have for breakfast in the corp 'Sh*t on Shingle' :) [EMAIL PROTECTED] 08/03/01 08:51AM This Is a simple one: BTW-bye the way. I visited www.acronymfinder.com. Here is something I wanted to share. /SOS [not an acronym] a common misconception is that SOS means Save Our Ship/Souls (a distress call); the letters don't actually stand for anything./ I always wanted to know what SOS really meant. It is not an acronym at all. Cool site. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 4:56 AM ROFL - rolling on the floor laughing I believe there actually is a web site somewhere that keeps track of these acronyms. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Babette Turner-Underwood [SMTP:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 2:25 AM To: Multiple recipients of list ORACLE-L Subject: Re: completely off-topic question... Or Happy To Help ... Also ... YMMV - Your Mileage May Vary (this took me FOREVER to guess) LOL - laughing out loud RTM - read the manual RTFM - read the Fine manual IMHO - in my humble opinion OR in my honest opinion OT - Off topic Babette - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 1:02 AM hope this helps hth yosi Michael wrote: ...which means it's probably going to start a great big thread :) I see a lot of emails with HTH on them, seemingly some sort of way to say thankyou or something... as they're always at the end of somebodies message right before they sign off their name.. I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ? Thanks,Michael. -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You
RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
Well near enough... ;o) We are playing well so.. we should get a good result. Anyway I have heard your name Because I worked with John Hallas and Malcolm Thorns (interv8) So its a very small world... :o) -Original Message- Sent: 03 August 2001 09:55 To: Multiple recipients of list ORACLE-L erm nope... 3 finals . Villa are in one we are in another and two other teams battle it out for the other place. There are three places up for grabs in the UEFA cup. We now play Troyes from France over two legs, the first away and the second back home. Cheers Lee -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 17:01 To: Multiple recipients of list ORACLE-L Toppa result Only Villa to beat and we are in Europe.. -Original Message- Sent: 02 August 2001 13:52 To: Multiple recipients of list ORACLE-L Wahey, Good result last night. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 11:50 To: Multiple recipients of list ORACLE-L The Geordies get everywhere Aa The Blaydon races.. -Original Message- Sent: 02 August 2001 08:00 To: Multiple recipients of list ORACLE-L I guess thats one of the things we have going for us in little old England. Where I live in the North East of England (Northumberland to be precise) there are a whole host of farms where you can go and pick your own within between 5 and 20 minutes drive from my house. Aaaah! Lee -Original Message- Sent: 02 August 2001 01:55 To: Multiple recipients of list ORACLE-L Cherie, You guys are making me soo jealous. (and so hungry for fresh strawberries!) Rachel From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest Date: Wed, 01 Aug 2001 13:38:35 -0800 Rachel, When I worked at Rockwell in Anaheim (Southern California - sort of a suburb of Los Angeles), I used to drive right past a strawberry field every night on my way home from work. Most of the berries would be picked and shipped to market or wherever but there was always a small stand at the edge of the field where you could stop and buy direct from the grower. It was strange to find a strawberry field in the middle of the city. That was fifteen years ago. I'm not sure if it's still there - what with the high price of real estate in that area. Anyway, the taste was just as April described it. Warm and damp and flavorful. The smell alone would make me stop. Every summer I long for those strawberries and I've yet to find anything close here in the Midwest. Cherie Machler nostalgic for a few things about Southern California - like the produce markets Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] carmichr@hotcc: mail.comSubject: RE: OT about to peeve off the vegatarians: RE: OT RE: Sent by: Largest root@fatcity. com 08/01/01 03:15 PM Please respond to ORACLE-L April, Okay, now tell me WHERE I can get those? The ones from the greenmarket are already insanely wonderful, I'm not sure I could stand anything more intense :) Rachel From: April Wells [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest Date: Wed, 01 Aug 2001 10:37:19 -0800 Rachel, You need to try strawberries, warm from the sun, wet from the irrigation system, with the light dusty dirt still crunching on them. April -Original Message- Sent: Wednesday, August 01, 2001 12:17 AM To: Multiple recipients of list ORACLE-L Ian, You have my sympathies for your struggles. And my respect for how you seem to be dealing with them. My husband was a hemophiliac. Just living with that as an adult was hard. To live with a genetic disorder in a child must be infinitely harder. I have an enormous respect for my mother-in-law who raised such a child and did not wrap him in cotton-wool, in case he got hurt. You are in CA, where you can get a much better assortment of non-store-bought produce than I can here in NYC, although I tend to frequent the greenmarkets and try to buy what is in season when I buy in stores. Even then, store-bought doesn't taste as good as fresh-picked. I have converted one person at work to never eating store-bought strawberries again, he tried some from the greenmarket when they were in season and was convinced. Rachel From: MacGregor, Ian A. [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list
RE: completely off-topic question...
Believe it or not, OK is short for Old Knickerbocker which was the local beloved name of Martin Van Buren, our 8th president. He was born in Kinderhook NY, and his mansion is still there, run by the National Parks service. He ran a very successfull farm, and was very organized. He laid out his to-do list every day, and would give his orders to the local workers by initialling everything with OK. I took the house tour last year, and found this quite intersting! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, August 03, 2001 10:16 AM To: Multiple recipients of list ORACLE-L I got one, but I am sure it will be answered in no time. Does anyone know where the terms ok and going the whole nine yards came from. Right now I am a little shady on the ok, but I will remember it soon:) KK - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 8:51 AM This Is a simple one: BTW-bye the way. I visited www.acronymfinder.com. Here is something I wanted to share. /SOS [not an acronym] a common misconception is that SOS means Save Our Ship/Souls (a distress call); the letters don't actually stand for anything./ I always wanted to know what SOS really meant. It is not an acronym at all. Cool site. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 4:56 AM ROFL - rolling on the floor laughing I believe there actually is a web site somewhere that keeps track of these acronyms. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Babette Turner-Underwood [SMTP:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 2:25 AM To: Multiple recipients of list ORACLE-L Subject: Re: completely off-topic question... Or Happy To Help ... Also ... YMMV - Your Mileage May Vary (this took me FOREVER to guess) LOL - laughing out loud RTM - read the manual RTFM - read the Fine manual IMHO - in my humble opinion OR in my honest opinion OT - Off topic Babette - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 1:02 AM hope this helps hth yosi Michael wrote: ...which means it's probably going to start a great big thread :) I see a lot of emails with HTH on them, seemingly some sort of way to say thankyou or something... as they're always at the end of somebodies message right before they sign off their name.. I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ? Thanks,Michael. -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: completely off-topic question...
Here's a piece of trivia I just picked up this week while watching The Ultimate 10 Technological Failures. According to the show the first official transmission of SOS was issued by the captain of the Titanic after it hit an iceberg in the North Atlantic. Now I fear the day when an Internet meltdown makes it to the list. Men are such imperfect creators. Paranoia runs deep... Steve Orr -Original Message- Sent: Friday, August 03, 2001 8:22 AM To: Multiple recipients of list ORACLE-L Main Entry: SOS Pronunciation: es-()O-'es Function: noun Date: 1910 1 : an internationally recognized signal of distress in radio code · · · - - - · · · used especially by ships calling for help 2 : a call or request for help or rescue - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 9:40 AM now i thought it meant 'Same Old Sh*t' or what we would have for breakfast in the corp 'Sh*t on Shingle' :) [EMAIL PROTECTED] 08/03/01 08:51AM This Is a simple one: BTW-bye the way. I visited www.acronymfinder.com. Here is something I wanted to share. /SOS [not an acronym] a common misconception is that SOS means Save Our Ship/Souls (a distress call); the letters don't actually stand for anything./ I always wanted to know what SOS really meant. It is not an acronym at all. Cool site. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 4:56 AM ROFL - rolling on the floor laughing I believe there actually is a web site somewhere that keeps track of these acronyms. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Babette Turner-Underwood [SMTP:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 2:25 AM To: Multiple recipients of list ORACLE-L Subject: Re: completely off-topic question... Or Happy To Help ... Also ... YMMV - Your Mileage May Vary (this took me FOREVER to guess) LOL - laughing out loud RTM - read the manual RTFM - read the Fine manual IMHO - in my humble opinion OR in my honest opinion OT - Off topic Babette - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 1:02 AM hope this helps hth yosi Michael wrote: ...which means it's probably going to start a great big thread :) I see a lot of emails with HTH on them, seemingly some sort of way to say thankyou or something... as they're always at the end of somebodies message right before they sign off their name.. I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ? Thanks,Michael. -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Was: computer history stories - Now: Age discrimination?
Paul, I want to echo your sentiment. Now that I am approaching 40 and feeling dinosaurish, it is nice to know that a large number of dinosaurs (or 'OraSaurus' as Don puts it) still exist. Btw, I keep hearing of Age discrimination in the IT industry. Reading through these notes, is it fair to say that this is less true among DBAs? As far me, started out in 79 in college with IBM 1620/Fortran and punched-card Input/Output trays (used to be able to read Hollerith code once upon a time!). Progressed to Cobol in my first job in 84 and later to XENIX/UNIX, and teaching the User *never* to use 'ior i' to 'startup' the V5 database... John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Paul Baumgartel [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 12:35 PM To: Multiple recipients of list ORACLE-L Subject: computer history stories I just want to thank everyone whose stories indicate that they are at least middle-aged--for a while (especially at my last job where the average age was about 25), I'd been feeling as though I was the last over-40 tech-head left on the East Coast. Now, as long as I'm posting, my how-I-got-started story: I majored in liberal arts and worked as a real-estate property manager for about 5 years. Encouraged by programmer friends, I took some classes, in Fortran, Intro. to Computer Logic, and DG MV/8000 assembly language. My first job, in 1981, was as an assembly language programmer, but not for the MV/8000; rather, writing firmware for the Intel 8085. I couldn't believe how primitive it seemed after programming for the then-state-of-the-art MV/8000. The experience, though, of working from hardware schematics and Intel data books was invaluable. You really know how a computer works when you've learned about asserting ALE (address latch enable) and strobing the address bus! Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] -- 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 Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 -- suggestions to ensure nerdiness in potential IT staff
I know a person in the Cleveland area that has one in his basement that he uses for a print server (and it basically replaced his furnace, too). April Wells wrote: my last company still used pdp-11s -Original Message- Sent: Thursday, August 02, 2001 1:28 PM To: Multiple recipients of list ORACLE-L It was a magical box to a middle-aged me as well and looked much better than my ugly metallic Kaypro. -Original Message- Sent: Thursday, August 02, 2001 11:42 AM To: Multiple recipients of list ORACLE-L yeah, my father still try's to impress me with stories of punch cards and such. It's pretty funny. The oldest computer I know of and still have is a compaq portable computer. It has the old 5 1/4 floppy drives and a little tiny screen. It's basically a suitcase, weighs about 40 pounds, the bottom is the keyboard. Kinda cool, I remember playing games on it as a kid and thinking it was the most amazing thing. Now it makes a good foot rest, but that's about it:) kk -Original Message- Sent: Thursday, August 02, 2001 10:52 AM To: Multiple recipients of list ORACLE-L And just think about the PC being an advanced system for some of us. Wait until we again start talking about using paper tapes and having to use scotch tape to put them back together to run them through. Or even the older guys that talk about switch boards. I am not as old as them. My computer days just go back to the mid 70's. I love this stuff(being a nerd wannabe), but I don't have a frickin clue what any of you are talking about:) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Norwood Bradly 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). 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). -- Scott Canaan
Need opinion on storage and backup solutions.
Hi Fellow DBAs, My company is thinking about dumping EMC (we have everything, symmetrics, connectrix, EDM, cellara etc). In your expert opinion what's a good alternative to go if we really need to replace EMC. Is Hitachi storage good? Does Veritas' backup solution do the stuff EMC/EDM can? What would you pick to replace EMC? Any information is welcome. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Permissions on dump logs
Hello all, In an Oracle 8.1.7 instance that I have inherited on a Soalris 2.7 server, the owner of the logfiles under $ORACLE_BASE/admin/$ORACLE_SID/adump, bdump, cdump and udump is the UNIX ID oracle, group oinstall. The permissions on these files are 640; in other words, only the oracle ID and any ID in the oinstall group can read these log files. We have a backup process that runs under another ID, with a group of dba. The backup process cannot see these log files in order to back them up. Two questions, first one: If the group dba had been chosen as the SYSDBA and/or SYSOP as part of the installation process, would the dba group have read permissions on these files? Question two: Can something be set to make these files readable by other users? I don't think _trace_files_public = true will do it. Thanks, Lou Avrami -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis Avrami INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: computer history stories
Ah ... 8085 ... those fond memories of college ... we knew all the timing diagrams (for each opcode) by heart, most of the op-codes by heart right down to internal steps ALE was a favorite question for quizzing junior students ... (most were pretty sure that you need 5V AC power supply for those 8085 kits). Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! -Original Message- Sent: Thursday, August 02, 2001 3:35 PM To: Multiple recipients of list ORACLE-L ... writing firmware for the Intel 8085. ... You really know how a computer works when you've learned about asserting ALE (address latch enable) and strobing the address bus! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- suggestions to ensure nerdiness in potential IT
I wasn't into westerns... but Red Skelton? oh yeah... and Danny Kaye movies. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT Date: Thu, 02 Aug 2001 11:04:15 -0800 That ran the same time a bullwinkle. How about Fess Parker as Davy Crocket. Or Red Skelton's show with Freddy the freeloader? ROR mô¿ôm [EMAIL PROTECTED] 08/02/01 02:11PM Okay, who remembers Fractured Fairy Tales and the Professor and his boy Sherman? From: Farnsworth, Dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff Date: Thu, 02 Aug 2001 08:41:38 -0800 And the question (still yet to be properly answered) is How many licks does it take to get to the center of a Tootsie Pop? Very nice!! I saw that all the time on my Saturdays watching Rocky and Bullwinkel, Tom and Jerry and my favorite, Bugs Bunny!! Dave -Original Message- Sent: Thursday, August 02, 2001 10:27 AM To: Multiple recipients of list ORACLE-L And the question (still yet to be properly answered) is How many licks does it take to get to the center of a Tootsie Pop? I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ 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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ 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).
Re: OT -- suggestions to ensure nerdiness in potential IT
Or Zorro, or My Friend Flika (westerns with a flair). Terry Rachel Carmichael wrote: I wasn't into westerns... but Red Skelton? oh yeah... and Danny Kaye movies. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT Date: Thu, 02 Aug 2001 11:04:15 -0800 That ran the same time a bullwinkle. How about Fess Parker as Davy Crocket. Or Red Skelton's show with Freddy the freeloader? ROR mô¿ôm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 -- suggestions to ensure nerdiness in potential IT
how else do I get to see my friends and get a free vacation? At this point, the only way I really learn is by going to conferences and talking to people. so I do... and for me, learning IS a vacation -- I get to use my brain. From: JOE TESTA [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT Date: Thu, 02 Aug 2001 09:50:51 -0800 Ivan, if you get the opportunity to attend an IOUG(my preferred one) or an openworld event, there is usually a gettogther of the people from the list, so you can place faces/w email addys :) check with the Goddess(AKA rachel), she's usually at both :) joe [EMAIL PROTECTED] 08/02/01 12:35PM I have to agree with Kevin, this thread is great. However it makes me feel like I really am in the wrong profession, at the wrong time in the wrong place :( . In 1981 I was 5 years old and I've never really touched a computer until about 3 years ago, let alone know any of the answers to any of those questions. You guys are great! I have learned so much from this list. Not only the technical stuff but learning about the IT and dba culture from you all is invaluable! I went to school for psych, so some of this old school talk that us young ones would hear from college cis professors I unfortunately never received, much less the knowledge of that curriculum. I am speechless when I step back and look at this list and realize how diverse this list really is. I mean we have list members from so many parts of the world and from so many different walks of life. Who would have ever thought that this young Puerto Rican punk from the 'hood would have anything in common with you all? I can see us all now at a bar after an oracle event, me in my baggy jeans, timberland boots, Iceberg shirt, etc. enjoying beers with you all. Everyone enjoying and sharing a common bond (dba, oracle) that brings us all together. Most of you all's peers wouldn't even look our way or have two words for me and my friends in our natural environment. But I think I'd feel just as comfortable around you all as I do at a block party in Bed-Stuy or chilling with some of my friends in Liberty City, Miami. All I can say the list is: I GIVE YOU ALL PROPS AND I GOT MAD LOVE FOR YALL! (translation: I hold you all in high esteem and greatly admire and respect you all). Thanks for everything. Ivan _ 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).
Re: OT -- suggestions to ensure nerdiness in potential IT
It look likes there are more of us older folks than one might think. And I loved Bullwinkle, Davy Crockett and Red Skelton and Danny Kaye movies. My husband is into old TV so we go to sleep watching TVLand, especially when The Honeymooners is on. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 02, 2001 5:14 PM I wasn't into westerns... but Red Skelton? oh yeah... and Danny Kaye movies. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT Date: Thu, 02 Aug 2001 11:04:15 -0800 That ran the same time a bullwinkle. How about Fess Parker as Davy Crocket. Or Red Skelton's show with Freddy the freeloader? ROR mô¿ôm [EMAIL PROTECTED] 08/02/01 02:11PM Okay, who remembers Fractured Fairy Tales and the Professor and his boy Sherman? From: Farnsworth, Dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff Date: Thu, 02 Aug 2001 08:41:38 -0800 And the question (still yet to be properly answered) is How many licks does it take to get to the center of a Tootsie Pop? Very nice!! I saw that all the time on my Saturdays watching Rocky and Bullwinkel, Tom and Jerry and my favorite, Bugs Bunny!! Dave -Original Message- Sent: Thursday, August 02, 2001 10:27 AM To: Multiple recipients of list ORACLE-L And the question (still yet to be properly answered) is How many licks does it take to get to the center of a Tootsie Pop? I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ 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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ 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
Re: Temporary Tablespace - Filling up
Look for any process/sql on your system which is resulting in a cartesian join using lot of temp tablespace Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 02 Aug 2001 23:40:24 -0800 Hi Gurus, I have a problem, perhaps someone can shed some light on this, please, I have a temporary Tablespace, which keeps on running out of space. At first I would increase the size, yet it still keeps filling up. Failing to be able to extend, until I increase it again. The object in the tablespace is owned by SYS and is called 11.2 Does anyone have any idea what is causing this and where it originates from, and what the object is, because it is not a table?(As far as I can see). The OS platform is Windows 2000 Oracle Version is 8.1.7. Thank You Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: completely off-topic question...
My favorite is PEBKAC - problem exists between keyboard and computer! Apropos for many users and some duhvelopers. ;-) Linda -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Friday, August 03, 2001 9:47 AMTo: Multiple recipients of list ORACLE-LSubject: RE: completely off-topic question... I was always partial to TANSTAAFL There Ain't No Such Thing AsA Free Lunch It has stuck with me ever since I read it in Ben Bova's book Cities in Flight. Of course, I have heard it many times since then. -Original Message-From: Sara Hoenshell [mailto:[EMAIL PROTECTED]]Sent: Friday, August 03, 2001 9:53 AMTo: Multiple recipients of list ORACLE-LSubject: RE: completely off-topic question... I think it means Hope This Helps. HTH Sara -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of MichaelSent: Friday, August 03, 2001 6:36 AMTo: Multiple recipients of list ORACLE-LSubject: completely off-topic question... ...which means it's probably going to start a great big thread :) I see a lot of emails with HTH on them, seemingly some sort of way to say "thankyou" or something... as they're always at the end of somebodies message right before they sign off their name.. I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ? Thanks, Michael.
RE: computer history stories - Now: Age discrimination?
I don't want you to feel to old, but at last count I have 5 sons and 20 grandchildren. Grandchildren range from 16mo to 16 years old. Birthdays and Christmas are expensive. ROR mª¿ªm [EMAIL PROTECTED] 08/03/01 11:40AM Actually this whole thread is making me feel a whole lot better !!!. I am 37 and was a bit concerned as to the age of many of the people on this list (thinking I may be a lot older than most) I'm glad I appear to be mistaken.. It seems strange but all the DBAs I know in this country as well are in their 30s or older. All the younger guys I know want to be Software Engineers (JAVA etc) and HTML people, they all see the DBA/S.A arena as something that takes too long to learn well and therefore not worth it. Maybe there is a future after all :-)) Lee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Need opinion on storage and backup solutions.
IMHO , HP's XP256 or XP512 is very good alternative . I have been using it for almost 1 and half years and I found it very good. Although , I have to do everything from scratch since HP doesn't have any 'best practices' in it yet ( actually we are the first to purchase it in east coast and I ended up doing a lot of research on it ) Now having finally tuned almost all the issues , I have OLTP with 300 ms response time restriction running on it with 400 TPM rate along with 500 Gigs plus DW . It has all the ( Almost ) features of EMC like BCV etc . BUt down side it I think it is little pricy ( Little..? What an understatement !!) Hope this helps Cheers , RS --- Richard Ji [EMAIL PROTECTED] wrote: Hi Fellow DBAs, My company is thinking about dumping EMC (we have everything, symmetrics, connectrix, EDM, cellara etc). In your expert opinion what's a good alternative to go if we really need to replace EMC. Is Hitachi storage good? Does Veritas' backup solution do the stuff EMC/EDM can? What would you pick to replace EMC? Any information is welcome. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: completely off-topic question...
FUBAR DILLIGAS Also user related problems =) -Original Message- Sent: Friday, August 03, 2001 12:42 PM To: Multiple recipients of list ORACLE-L LOL!!! no no no Lindathere's nothing between kbd and 'puter but a CABLE. It's PEBCAK Problem Exists Between Chair and Keyboard. that isthe user. LoL -Original Message- Sent: Friday, August 03, 2001 12:47 PM To: Multiple recipients of list ORACLE-L My favorite is PEBKAC - problem exists between keyboard and computer! Apropos for many users and some duhvelopers. ;-) Linda -Original Message- Sent: Friday, August 03, 2001 9:47 AM To: Multiple recipients of list ORACLE-L I was always partial to TANSTAAFL There Ain't No Such Thing As A Free Lunch It has stuck with me ever since I read it in Ben Bova's book Cities in Flight. Of course, I have heard it many times since then. -Original Message- Sent: Friday, August 03, 2001 9:53 AM To: Multiple recipients of list ORACLE-L I think it means Hope This Helps. HTH Sara -Original Message- Sent: Friday, August 03, 2001 6:36 AM To: Multiple recipients of list ORACLE-L ...which means it's probably going to start a great big thread :) I see a lot of emails with HTH on them, seemingly some sort of way to say thankyou or something... as they're always at the end of somebodies message right before they sign off their name.. I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ? Thanks, Michael. 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. FUBAR DILLIGAS Also user related problems =) -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Friday, August 03, 2001 12:42 PMTo: Multiple recipients of list ORACLE-LSubject: RE: completely off-topic question... LOL!!! no no no Lindathere's nothing between kbd and 'puter but a CABLE. It's PEBCAK Problem Exists Between Chair and Keyboard. that isthe user. LoL -Original Message-From: Seley, Linda [mailto:[EMAIL PROTECTED]]Sent: Friday, August 03, 2001 12:47 PMTo: Multiple recipients of list ORACLE-LSubject: RE: completely off-topic question... My favorite is PEBKAC - problem exists between keyboard and computer! Apropos for many users and some duhvelopers. ;-) Linda -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Friday, August 03, 2001 9:47 AMTo: Multiple recipients of list ORACLE-LSubject: RE: completely off-topic question... I was always partial to TANSTAAFL There Ain't No Such Thing AsA Free Lunch It has stuck with me ever since I read it in Ben Bova's book Cities in Flight. Of course, I have heard it many times since then. -Original Message-From: Sara Hoenshell [mailto:[EMAIL PROTECTED]]Sent: Friday, August 03, 2001 9:53 AMTo: Multiple recipients of list ORACLE-LSubject: RE: completely off-topic question... I think it means Hope This Helps. HTH Sara -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of MichaelSent: Friday, August 03, 2001 6:36 AMTo: Multiple recipients of list ORACLE-LSubject: completely off-topic question... ...which means it's probably going to start a great big thread :) I see a lot of emails with HTH on them, seemingly some sort of way to say "thankyou" or something... as they're always at the end of somebodies message right before they sign off their name.. I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ? Thanks, Michael.
RE: OT -- suggestions to ensure nerdiness in potential IT
How about the black and white Superman ,Man of Steel shows where Superman wasn't that super after all. Bullets would bounce off him but he would duck when you threw the gun at him. Is that the beginnings of duck-duck-goose? ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- suggestions to ensure nerdiness in potential IT
Actually, Davy Crockett was dead before the invention of TV. But he was played by Fess Parker in the TV movies with the same name. Having said that, I don't beleive that Fess Parker, Red Skelton and Danny Kaye ever together, but I have been know to be wrong before. Terry Gogala, Mladen wrote: Have Bullwinkle,Davy Crockett, Red Skelton and Danny Kaye ever been in the same movie together? What about Rocky, he and Bullwinkle used to be inseparable. I didn't know that Bullwinkle was moonlighting with Danny Kaye and Skelton? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Inserting a Record into a Table
Pre 9i version, you got to insert column by column. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- suggestions to ensure nerdiness in potential IT
-My mom would not let us watch that night. It must be because of those demonic hip gyrations!! What would your mom think of Rob Zombie?? -Original Message- Sent: Friday, August 03, 2001 11:08 AM To: Multiple recipients of list ORACLE-L My mom would not let us watch that night. -Original Message- Sent: Friday, August 03, 2001 7:48 AM To: Multiple recipients of list ORACLE-L Some of us remember Elvis on Ed Sullivan.Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: 9i
Old is Gold...In some respects... I did not work with Oracle4. So don't know what BIF and AIF were (may be befoe image file and after image file ??) - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 8:26 AM To: Deshpande; Kirti; Multiple recipients of list ORACLE-L Subject: Re:RE: 9i AH SO, we go back to the idea of BIF AIF files again?? Sound like old Oracle 4 idea!! Oracle into re-cycling too then!! :) Dick Goulet Reply Separator Subject:RE: 9i Author: Deshpande; Kirti [EMAIL PROTECTED] Date: 8/2/2001 1:14 PM With 9i, we have a choice of using Rollback segments (as we know it till 8.1.7) or the Undo Tablespace (new with 9i). I am a little skeptical about this automagic Undo stuff with the undo_tablespace. But Oracle now says that the 'manual' or current method of using rollback segments for managing undo is being deprecated. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- suggestions to ensure nerdiness in potential IT
My mom would not let us watch that night. -Original Message- Sent: Friday, August 03, 2001 7:48 AM To: Multiple recipients of list ORACLE-L Some of us remember Elvis on Ed Sullivan.Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
connection times...
Anyone know of some quick checks to perform or places to start looking when it starts to take more than 20 seconds to connect to the database to determine what is causing the problem? We're using MTS, Solaris 2.6, v8.1.5... TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: RE: 9i
Give the man a cookie!! Dick Goulet Reply Separator Author: Deshpande; Kirti [EMAIL PROTECTED] Date: 8/3/2001 10:01 AM Old is Gold...In some respects... I did not work with Oracle4. So don't know what BIF and AIF were (may be befoe image file and after image file ??) - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 8:26 AM To: Deshpande; Kirti; Multiple recipients of list ORACLE-L Subject: Re:RE: 9i AH SO, we go back to the idea of BIF AIF files again?? Sound like old Oracle 4 idea!! Oracle into re-cycling too then!! :) Dick Goulet Reply Separator Subject:RE: 9i Author: Deshpande; Kirti [EMAIL PROTECTED] Date: 8/2/2001 1:14 PM With 9i, we have a choice of using Rollback segments (as we know it till 8.1.7) or the Undo Tablespace (new with 9i). I am a little skeptical about this automagic Undo stuff with the undo_tablespace. But Oracle now says that the 'manual' or current method of using rollback segments for managing undo is being deprecated. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: off topic--oracle Vs ms sql
Wow, looks like MySQL is better than Oracle! Oh, apart from the fact that it doesn't have transactions, foreign keys, stored procedures, replication, object type definitions, bitmap indexes, subselects, or indeed, everything else a real database takes for granted. Get it? Granted? It doesn't have roles either, heh heh heh g -Original Message- Sent: Wednesday, August 01, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Try this site... http://www.mysql.com/information/crash-me.php On Mon, 30 Jul 2001 13:29:28 -0800 Ravindra Basavaraja [EMAIL PROTECTED] wrote: Does anyone have any doc or links that compares oracle and ms sql. Also what are the equivalent data types in ms sql for oracle's lobs. Thanks Ravindra __ Dwayne Cox DBA, Development Dept. Info Tech, Inc. [EMAIL PROTECTED] http://www.infotechfl.com ___ The opinions expressed are the author's own unless otherwise stated -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: completely off-topic question...
TANSTAAFL /tan'stah-fl/ [acronym, from Robert Heinlein's classic The Moon is a Harsh Mistress.] There Ain't No Such Thing As A Free Lunch, often invoked when someone is balking at the prospect of using an unpleasantly heavyweight technique, or at the poor quality of some piece of free software, or at the signal-to-noise ratio of unmoderated Usenet newsgroups. What? Don't tell me I have to implement a database back end to get my address book program to work! Well, TANSTAAFL you know. This phrase owes some of its popularity to the high concentration of science-fiction fans and political libertarians in hackerdom. I have read ALL of Heinlein's work multliple times. And, since I read them as they came out, I got the benefit of getting them on the timeline. Terry Kevin Lange wrote: I was always partial to TANSTAAFL There Ain't No Such Thing As A Free Lunch It has stuck with me ever since I read it in Ben Bova's book Cities in Flight. Of course, I have heard it many times since then. -Original Message- From: Sara Hoenshell [mailto:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 9:53 AM To: Multiple recipients of list ORACLE-L Subject: RE: completely off-topic question... I think it means Hope This Helps.HTHSara -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Sent: Friday, August 03, 2001 6:36 AM To: Multiple recipients of list ORACLE-L Subject: completely off-topic question... ...which means it's probably going to start a great big thread :) I see a lot of emails with HTH on them, seemingly some sort of way to say thankyou or something... as they're always at the end of somebodies message right before they sign off their name.. I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ? Thanks,Michael. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Inserting a Record into a Table
If you are (or will be) using 9i, straight from the manual manual Inserting Records into the Database A new PL/SQL-only extension of the INSERT statement lets you insert records into database rows using a single variable of type RECORD or %ROWTYPE instead of a list of fields. That makes your code more readable and maintainable. The record type cannot be nested. Also, the number of fields in the record must equal the number of columns listed in the INTO clause, and corresponding fields and columns must have compatible datatypes. An example follows: DECLARE TYPE EmpRec IS RECORD ( emp_idNUMBER(4), job_title VARCHAR2(9), salaryNUMBER(7,2)); emp_info EmpRec; BEGIN emp_info.emp_id := 7975; emp_info.job_title := 'CLERK'; emp_info.salary := 1500; INSERT INTO emp (empno, job, sal) VALUES (emp_info); END; In the example below, you use a %ROWTYPE record. A column list is not needed because the record contains a field for each column in the database table. DECLARE dept_info dept%ROWTYPE; BEGIN dept_info.dept_num := 70; dept_info.dept_name := 'PERSONNEL'; dept_info.location := 'DALLAS'; INSERT INTO dept VALUES (dept_info); END; /manual HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need opinion on storage and backup solutions.
I second that curiosity - why would you want to replace EMC? If you already have the EMC infrastructure, cost must not be an issue, right? Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Chris Sent: Friday, August 03, 2001 11:25 AM To: Multiple recipients of list ORACLE-L Hmmm...I haven't had the privilege of working with EMC stuff, so I am curious as to why you want to replace it??? Thanks. -Original Message- Sent: Thursday, August 02, 2001 8:11 PM To: Multiple recipients of list ORACLE-L Hi Fellow DBAs, My company is thinking about dumping EMC (we have everything, symmetrics, connectrix, EDM, cellara etc). In your expert opinion what's a good alternative to go if we really need to replace EMC. Is Hitachi storage good? Does Veritas' backup solution do the stuff EMC/EDM can? What would you pick to replace EMC? Any information is welcome. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Need opinion on storage and backup solutions.
Richard, I second that question. We are using EMC storage now (with NT front-end) as well as EDM for Rman backups. Why are you thinking of dumping EMC? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, August 03, 2001 11:25 AM To: Multiple recipients of list ORACLE-L Hmmm...I haven't had the privilege of working with EMC stuff, so I am curious as to why you want to replace it??? Thanks. -Original Message- Sent: Thursday, August 02, 2001 8:11 PM To: Multiple recipients of list ORACLE-L Hi Fellow DBAs, My company is thinking about dumping EMC (we have everything, symmetrics, connectrix, EDM, cellara etc). In your expert opinion what's a good alternative to go if we really need to replace EMC. Is Hitachi storage good? Does Veritas' backup solution do the stuff EMC/EDM can? What would you pick to replace EMC? Any information is welcome. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Inserting a Record into a Table
Thanks a lot. This is what I need . but unfortunately we are on 8.0.5. But this does tell me that I can not do it the way I want. I appreciate the confirmation. Kevin -Original Message- Sent: Friday, August 03, 2001 9:53 AM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' If you are (or will be) using 9i, straight from the manual manual Inserting Records into the Database A new PL/SQL-only extension of the INSERT statement lets you insert records into database rows using a single variable of type RECORD or %ROWTYPE instead of a list of fields. That makes your code more readable and maintainable. The record type cannot be nested. Also, the number of fields in the record must equal the number of columns listed in the INTO clause, and corresponding fields and columns must have compatible datatypes. An example follows: DECLARE TYPE EmpRec IS RECORD ( emp_idNUMBER(4), job_title VARCHAR2(9), salaryNUMBER(7,2)); emp_info EmpRec; BEGIN emp_info.emp_id := 7975; emp_info.job_title := 'CLERK'; emp_info.salary := 1500; INSERT INTO emp (empno, job, sal) VALUES (emp_info); END; In the example below, you use a %ROWTYPE record. A column list is not needed because the record contains a field for each column in the database table. DECLARE dept_info dept%ROWTYPE; BEGIN dept_info.dept_num := 70; dept_info.dept_name := 'PERSONNEL'; dept_info.location := 'DALLAS'; INSERT INTO dept VALUES (dept_info); END; /manual HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: completely off-topic question...
-where the terms ok and going the whole nine yards came from I found this bit on the phrase; The phrase the whole nine yards is commonly used to mean everything or all the way as in, This new minivan has a cell phone, dual climate controls, and a dashboard PEZ dispenser -- the whole nine yards. It's sort of like the whole ball of wax or the whole enchilada. As far as the origin is concerned, that's a bit more difficult to discern. We made the rounds of our Etymology category (under Social Sciences Linguistics and Languages) and dutifully perused the sites that deal with the history of slang expressions. Our first stop, Wilton's Word and Phrase Origins, did indeed have an entry devoted to the whole nine yards, but it offers only theories, no conclusions. Some of the suggested possibilities include: nine yards as the length of cloth needed for a particular garment, nine yards as the length of a machine-gun ammunition belt, and nine yards as the amount of cement held in a typical cement-mixer. Unfortunately, Wilton also notes that these theories are chock full of holes. Next up was Jesse's Word of the Day, a daily column by Jesse Sheidlower, Senior Editor of Random House's Reference Department. Last November, Jesse tackled the question of the whole nine yards and his very succinct answer was I don't know. He does offer some of the same theories as Wilton, and, in the process, shoots them down. Plus he gives some bonus possibilities: football, ship sails, burial shrouds. We particularly enjoyed Jesse's discussion of the logic involved in debunking these theories. Finally, when all else fails, we look to the masses for truly outlandish hypotheses. A quick search of DejaNews, the Usenet discussion search engine, lead us to a spirited debate by the denizens of alt.books.david-weber (a sci-fi author). The latest theory seems to be that nine yards is the amount of fabric required to make a Scotsman's kilt. So we're afraid that the current Internet verdict on the origin of the whole nine yards is a resounding Who knows? There is something to ponder!! Dave -Original Message- Sent: Friday, August 03, 2001 9:16 AM To: Multiple recipients of list ORACLE-L I got one, but I am sure it will be answered in no time. Does anyone know where the terms ok and going the whole nine yards came from. Right now I am a little shady on the ok, but I will remember it soon:) KK - Original Message - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- suggestions to ensure nerdiness in potential IT
But of course. Not bad. Not the original, but not bad. I thought the plot was better than a lot of the remakes being made. They at least had it as though some time had passed and the original Zorro was now an old man training a younger man to take his place. Most remakes just use different actors as the original characters. And for an old fan like me, it kinda grates. Terry Ruth Gramolini wrote: Out of the night, when the full moon is bright, rides a horse man is known as Zorro! Did you happen to catch the recent Zorro movie? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 9:35 AM Or Zorro, or My Friend Flika (westerns with a flair). Terry Rachel Carmichael wrote: I wasn't into westerns... but Red Skelton? oh yeah... and Danny Kaye movies. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT Date: Thu, 02 Aug 2001 11:04:15 -0800 That ran the same time a bullwinkle. How about Fess Parker as Davy Crocket. Or Red Skelton's show with Freddy the freeloader? ROR mô¿ôm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 -- suggestions to ensure nerdiness in potential IT
yup -- I like Anthony Hopkins in anything (okay, not as Hannibal Lecter, I wouldn't like ANYONE as Hannibal Lecter) Banderas was okay. From: Ruth Gramolini [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OT -- suggestions to ensure nerdiness in potential IT Date: Fri, 03 Aug 2001 06:15:40 -0800 Out of the night, when the full moon is bright, rides a horse man is known as Zorro! Did you happen to catch the recent Zorro movie? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 9:35 AM Or Zorro, or My Friend Flika (westerns with a flair). Terry Rachel Carmichael wrote: I wasn't into westerns... but Red Skelton? oh yeah... and Danny Kaye movies. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT Date: Thu, 02 Aug 2001 11:04:15 -0800 That ran the same time a bullwinkle. How about Fess Parker as Davy Crocket. Or Red Skelton's show with Freddy the freeloader? ROR mô¿ôm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ 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).
RE: completely off-topic question...
The human GI tract is about nine yards. -Hannibal -Original Message- Sent: Friday, August 03, 2001 12:01 PM To: Multiple recipients of list ORACLE-L -where the terms ok and going the whole nine yards came from I found this bit on the phrase; The phrase the whole nine yards is commonly used to mean everything or all the way as in, This new minivan has a cell phone, dual climate controls, and a dashboard PEZ dispenser -- the whole nine yards. It's sort of like the whole ball of wax or the whole enchilada. As far as the origin is concerned, that's a bit more difficult to discern. We made the rounds of our Etymology category (under Social Sciences Linguistics and Languages) and dutifully perused the sites that deal with the history of slang expressions. Our first stop, Wilton's Word and Phrase Origins, did indeed have an entry devoted to the whole nine yards, but it offers only theories, no conclusions. Some of the suggested possibilities include: nine yards as the length of cloth needed for a particular garment, nine yards as the length of a machine-gun ammunition belt, and nine yards as the amount of cement held in a typical cement-mixer. Unfortunately, Wilton also notes that these theories are chock full of holes. Next up was Jesse's Word of the Day, a daily column by Jesse Sheidlower, Senior Editor of Random House's Reference Department. Last November, Jesse tackled the question of the whole nine yards and his very succinct answer was I don't know. He does offer some of the same theories as Wilton, and, in the process, shoots them down. Plus he gives some bonus possibilities: football, ship sails, burial shrouds. We particularly enjoyed Jesse's discussion of the logic involved in debunking these theories. Finally, when all else fails, we look to the masses for truly outlandish hypotheses. A quick search of DejaNews, the Usenet discussion search engine, lead us to a spirited debate by the denizens of alt.books.david-weber (a sci-fi author). The latest theory seems to be that nine yards is the amount of fabric required to make a Scotsman's kilt. So we're afraid that the current Internet verdict on the origin of the whole nine yards is a resounding Who knows? There is something to ponder!! Dave -Original Message- Sent: Friday, August 03, 2001 9:16 AM To: Multiple recipients of list ORACLE-L I got one, but I am sure it will be answered in no time. Does anyone know where the terms ok and going the whole nine yards came from. Right now I am a little shady on the ok, but I will remember it soon:) KK - Original Message - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- suggestions to ensure nerdiness in potential IT
But even us older ladies have a different point of view on Sean and Antonio. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 11:17 AM With Sean Connery, Antonio Banderas Katherine Zeta-Jones? It was fun, but pretty predictable. Antonio Katherine together was fun to watch. The sword fight was cute. Did you happen to catch the recent Zorro movie? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, August 03, 2001 10:16 AM To: Multiple recipients of list ORACLE-L Out of the night, when the full moon is bright, rides a horse man is known as Zorro! Did you happen to catch the recent Zorro movie? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 9:35 AM Or Zorro, or My Friend Flika (westerns with a flair). Terry Rachel Carmichael wrote: I wasn't into westerns... but Red Skelton? oh yeah... and Danny Kaye movies. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT Date: Thu, 02 Aug 2001 11:04:15 -0800 That ran the same time a bullwinkle. How about Fess Parker as Davy Crocket. Or Red Skelton's show with Freddy the freeloader? ROR mô¿ôm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- suggestions to ensure nerdiness in potential IT
You're right - it was Anthony. As I was typing Sean Connery, it didn't feel right! -Original Message- Sent: Friday, August 03, 2001 11:17 AM To: Multiple recipients of list ORACLE-L yup -- I like Anthony Hopkins in anything (okay, not as Hannibal Lecter, I wouldn't like ANYONE as Hannibal Lecter) Banderas was okay. From: Ruth Gramolini [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OT -- suggestions to ensure nerdiness in potential IT Date: Fri, 03 Aug 2001 06:15:40 -0800 Out of the night, when the full moon is bright, rides a horse man is known as Zorro! Did you happen to catch the recent Zorro movie? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 9:35 AM Or Zorro, or My Friend Flika (westerns with a flair). Terry Rachel Carmichael wrote: I wasn't into westerns... but Red Skelton? oh yeah... and Danny Kaye movies. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT Date: Thu, 02 Aug 2001 11:04:15 -0800 That ran the same time a bullwinkle. How about Fess Parker as Davy Crocket. Or Red Skelton's show with Freddy the freeloader? ROR mo?om -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- suggestions to ensure nerdiness in potential IT
Ah yes, and then theres Catherine Zeta jones. Just to prove to the world that not every girl who comes out of the UK looks like the bloody Spice Girls -Original Message- Sent: 03 August 2001 16:17 To: Multiple recipients of list ORACLE-L yup -- I like Anthony Hopkins in anything (okay, not as Hannibal Lecter, Iw ouldn't like ANYONE as Hannibal Lecter) Banderas was okay. From: Ruth Gramolini [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OT -- suggestions to ensure nerdiness in potential IT Date: Fri, 03 Aug 2001 06:15:40 -0800 Out of the night, when the full moon is bright, rides a horse man is known as Zorro! Did you happen to catch the recent Zorro movie? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 9:35 AM Or Zorro, or My Friend Flika (westerns with a flair). Terry Rachel Carmichael wrote: I wasn't into westerns... but Red Skelton? oh yeah... and Danny Kaye movies. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT Date: Thu, 02 Aug 2001 11:04:15 -0800 That ran the same time a bullwinkle. How about Fess Parker as Davy Crocket. Or Red Skelton's show with Freddy the freeloader? ROR mô¿ôm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ 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 communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: completely off-topic question...
I was always partial to TANSTAAFL There Ain't No Such Thing AsA Free Lunch It has stuck with me ever since I read it in Ben Bova's book Cities in Flight. Of course, I have heard it many times since then. -Original Message-From: Sara Hoenshell [mailto:[EMAIL PROTECTED]]Sent: Friday, August 03, 2001 9:53 AMTo: Multiple recipients of list ORACLE-LSubject: RE: completely off-topic question... I think it means Hope This Helps. HTH Sara -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of MichaelSent: Friday, August 03, 2001 6:36 AMTo: Multiple recipients of list ORACLE-LSubject: completely off-topic question... ...which means it's probably going to start a great big thread :) I see a lot of emails with HTH on them, seemingly some sort of way to say "thankyou" or something... as they're always at the end of somebodies message right before they sign off their name.. I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ? Thanks, Michael.
RE: part of the table export (incremental?)
So what should you use instead? Steven. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: 02 August 2001 17:21To: Multiple recipients of list ORACLE-LSubject: Re: part of the table export (incremental?) and the incremental/cmulative options in export are only there for backwards compatibility w/scripts, my understanding is they are not really supported anymore. joe [EMAIL PROTECTED] 08/02/01 10:30AM if you are running 8i, you can use a where clause on the export.incremental export does not export only the changed rows but will export the entire table if even as little as one byte in one row has changed.From: "Tatireddy, Shrinivas (MED, Keane)" [EMAIL PROTECTED]Reply-To: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Subject: part of the table export (incremental?)Date: Thu, 02 Aug 2001 02:05:26 -0800Hi dba'scan anybody tell me how to do export part of the table..i.e. incremental data.when i exported at 10 am it has 1000 rows ( i did full exp)100 rows newly added in the 2 hrswhen i do exported at 12 am ( incremental) it exporting all therows(1100) of the tablebut i need only the rows, that are newly inserted.is there any way to do such export?thnx in advsrinivas--Please see the official ORACLE-L FAQ: http://www.orafaq.com--
Re: huge datafiles/need help
Are you rebuilding indexes with unrecoverable/nologging and parallel clause or simple 'alter index index_name rebuild tablespace tbs_name', which is definately slow then using above options500/600MB indexes may take around 30/35 minutes depending of your parallel clause and cpu availability... MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 02 Aug 2001 20:32:35 -0800 Thank you everyone who replied. All suggestions were very helpful. I am bebuilding my indexes in a different tablespace. It runs very very slow.. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 02, 2001 3:51 PM Lyuda; 1. Create a new tablespace for the indexes on a seperate drive. Make sure you do this with a much more reasonable datafile size. (Watch it here maybe they did the big size because they were running out of possible files -- see the max_datafiles parm on the Create Database command) 2. Rebuild the indexes over into the new tablespace. Make sure your initial paramater fits in the initial size of the data files. 3. Drop your old Index Tablespace. As for your ALTER DATABASE DATAFILE RESIZE ... goes; thats what happens when you use all your space. I would suggest at some point to take an outage and reorg that tablespace containing the table as well to get its files down in to a resonably managed size. -Original Message- Sent: Thursday, August 02, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Hi List, I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask me who created such a file because I don't know. I am trying to rescue the database that has multiple problems. Something you've never seen before. Bye the way, did anyone ever run a test how much stuff you can put on your disc before it dyes? Well, yesterday I found a disc which was 99.07 % full. Anyway... The tablespace is ~ 50 % free. The bad news is it doesn't let me to reduce the size of the datafiles by using 'alter database datafile ... resize...';. That tablespace contains 32 indexes. Some of them are as large as 600 -800 M. I need to develop a plan of attack. My options are: 1) drop and recreate the indexes; 2) rebuild the indexes in different tablespace/tablespaces; 3) export/import indexes or may be even tablespace all at once. Is there anyone who has done something similar before? All suggestions are greatly appreciated. That database is screaming for help!! It running Oracle 8.1.6 on NT. 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-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San
RE: SQL Question
Darren, You would need to use the escape character. Try this, select table_name from dba_tables where table_name like 'EDL-_WORK-_%'ESCAPE'-'; Suhen I have a simple query, but the results are somewhat puzzling select table_name from dba_tables where table_name like 'EDL_WORK_%' and I received the following TABLE_NAME - EDL_WORKSTATION_LOCATION EDL_WORK_AR_ENTITIES Why would I be receiving the first record (EDL_WORKSTATION) if I try EDL_WORK_A% I get the correct result. Is there something about the _% combination ? To solve the problem I used the substr command as part of the where clause. Darren - Darren Browett P.EngThis message was transmitted Systems Admin/DBA using 100% recycled electrons Information and Communications Technology. City of Coquitlam P:(604) 927 - 3614 E:[EMAIL PROTECTED] - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Inserting a Record into a Table
hi, try INSERT INTO yournewtable SELECT * FROM youroldtable; if you want to modify value for particular field you can use oracle functions in SELECT clause. in example below I use string function called SUBSTR : SQL insert into newdept 2 select deptno,SUBSTR(dname,1,3) ,loc from olddept; SQL select * from olddept; DEPTNO DNAME LOC - -- - 10ACCOUNTING NEW YORK 20RESEARCH DALLAS 30SALES CHICAGO 40OPERATIONS BOSTON SQL select * from newdept; DEPTNO DNA LOC - -- - 10 ACC NEW YORK 20 RESDALLAS 30 SAL CHICAGO 40 OPEBOSTON hope this help : ) Bambang Setiawan [EMAIL PROTECTED] 08/03/01 06:50 Can you insert an entire record into a table without having to specify each individual field ?? I need to copy multiple rows in a table after I have modified its key. I do not want to have to specify each field. Is there a way just to select the record, modify the particular field, and then insert the record... WITHOUT having to list all the fields or each individual value ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Question
% match any number of chars == * in dos _ match one character == ? in dos joe Browett, Darren wrote: I have a simple query, but the results are somewhat puzzling select table_name from dba_tables where table_name like 'EDL_WORK_%' and I received the following TABLE_NAME - EDL_WORKSTATION_LOCATION EDL_WORK_AR_ENTITIES Why would I be receiving the first record (EDL_WORKSTATION) if I try EDL_WORK_A% I get the correct result. Is there something about the _% combination ? To solve the problem I used the substr command as part of the where clause. Darren - Darren Browett P.EngThis message was transmitted Systems Admin/DBA using 100% recycled electrons Information and Communications Technology. City of Coquitlam P:(604) 927 - 3614 E:[EMAIL PROTECTED] - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Question
Darren, Just as the % character is a wildcard that matches any number of characters, the _ character is a wildcard that matches any single character. So it matches the S in WORKSTATION, and then the % sign matches TATION_LOCATION. hth, Yosi Browett, Darren wrote: I have a simple query, but the results are somewhat puzzling select table_name from dba_tables where table_name like 'EDL_WORK_%' and I received the following TABLE_NAME - EDL_WORKSTATION_LOCATION EDL_WORK_AR_ENTITIES Why would I be receiving the first record (EDL_WORKSTATION) if I try EDL_WORK_A% I get the correct result. Is there something about the _% combination ? To solve the problem I used the substr command as part of the where clause. Darren - Darren Browett P.EngThis message was transmitted Systems Admin/DBA using 100% recycled electrons Information and Communications Technology. City of Coquitlam P:(604) 927 - 3614 E:[EMAIL PROTECTED] - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 9i
the docs are available, i've downloaded most of the .PDFs joe Kevin Kostyszyn wrote: Does anyone know where to get some good docs on 9i. What I have read isn't really telling me any of this stuff that we're discussing here. KK -Original Message- Sent: Thursday, August 02, 2001 4:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] With 9i, we have a choice of using Rollback segments (as we know it till 8.1.7) or the Undo Tablespace (new with 9i). I am a little skeptical about this automagic Undo stuff with the undo_tablespace. But Oracle now says that the 'manual' or current method of using rollback segments for managing undo is being deprecated. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Subject: 9i Uhhh...I thought that 9i wasn't going to be using rollback segments anymore? Am I wrong, was this alcohol induced dream or something like that? 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: 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) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: completely off-topic question...
I've heard (did I hear it from this list?I think I did) it stands for 'Hope It Helps'. Michael, if you'renewto this list be prepared for ajourney HTH, Lyuda - Original Message - From: Michael To: Multiple recipients of list ORACLE-L Sent: Thursday, August 02, 2001 8:45 PM Subject: completely off-topic question... ...which means it's probably going to start a great big thread :) I see a lot of emails with HTH on them, seemingly some sort of way to say "thankyou" or something... as they're always at the end of somebodies message right before they sign off their name.. I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ? Thanks, Michael.
completely off-topic question...
...which means it's probably going to start a great big thread :) I see a lot of emails with HTH on them, seemingly some sort of way to say "thankyou" or something... as they're always at the end of somebodies message right before they sign off their name.. I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ? Thanks, Michael.
Re: huge datafiles/need help
Thank you everyone who replied. All suggestions were very helpful. I am bebuilding my indexes in a different tablespace. It runs very very slow.. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 02, 2001 3:51 PM Lyuda; 1. Create a new tablespace for the indexes on a seperate drive. Make sure you do this with a much more reasonable datafile size. (Watch it here maybe they did the big size because they were running out of possible files -- see the max_datafiles parm on the Create Database command) 2. Rebuild the indexes over into the new tablespace. Make sure your initial paramater fits in the initial size of the data files. 3. Drop your old Index Tablespace. As for your ALTER DATABASE DATAFILE RESIZE ... goes; thats what happens when you use all your space. I would suggest at some point to take an outage and reorg that tablespace containing the table as well to get its files down in to a resonably managed size. -Original Message- Sent: Thursday, August 02, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Hi List, I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask me who created such a file because I don't know. I am trying to rescue the database that has multiple problems. Something you've never seen before. Bye the way, did anyone ever run a test how much stuff you can put on your disc before it dyes? Well, yesterday I found a disc which was 99.07 % full. Anyway... The tablespace is ~ 50 % free. The bad news is it doesn't let me to reduce the size of the datafiles by using 'alter database datafile ... resize...';. That tablespace contains 32 indexes. Some of them are as large as 600 -800 M. I need to develop a plan of attack. My options are: 1) drop and recreate the indexes; 2) rebuild the indexes in different tablespace/tablespaces; 3) export/import indexes or may be even tablespace all at once. Is there anyone who has done something similar before? All suggestions are greatly appreciated. That database is screaming for help!! It running Oracle 8.1.6 on NT. 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-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 -- suggestions to ensure nerdiness in potential IT staff
And this 300/1200 Boud rate modems were without error correction mode resulting lot of garbage in between specially working from subcontinent to dialin in UK or USA machines...Same modems were working well if worked within USA or UKThat was 1990-91 era MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 02 Aug 2001 13:14:57 -0800 Yeah - but then the 1200 baud modems came out - now THOSE were speedy. And after I saw my friend's 1200, my 300 was like molasses. Rachel Carmichael wrote: heck, I did production work over a 300 baud modem -- the one where you had to dial in and then place the handset into the cups :) and I thought it was the speediest thing ever From: Seley, Linda [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff Date: Thu, 02 Aug 2001 10:28:15 -0800 One of those Compaqs was the first portable I took home from work 7 years ago! It sat in my basement until 3 years ago when I lugged it back - we were moving and I didn't want to be responsible for it any more! (Gosh, a 1200k modem?) Same company that is *still* using PL/1 as it's mainframe programming language and APL in the actuarial department. Linda -Original Message- Sent: Thursday, August 02, 2001 10:42 AM To: Multiple recipients of list ORACLE-L yeah, my father still try's to impress me with stories of punch cards and such. It's pretty funny. The oldest computer I know of and still have is a compaq portable computer. It has the old 5 1/4 floppy drives and a little tiny screen. It's basically a suitcase, weighs about 40 pounds, the bottom is the keyboard. Kinda cool, I remember playing games on it as a kid and thinking it was the most amazing thing. Now it makes a good foot rest, but that's about it:) kk -Original Message- Sent: Thursday, August 02, 2001 10:52 AM To: Multiple recipients of list ORACLE-L And just think about the PC being an advanced system for some of us. Wait until we again start talking about using paper tapes and having to use scotch tape to put them back together to run them through. Or even the older guys that talk about switch boards. I am not as old as them. My computer days just go back to the mid 70's. I love this stuff(being a nerd wannabe), but I don't have a frickin clue what any of you are talking about:) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Seley, Linda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re: Your ideas will be helpful
Helen: How about a select statement that will do it for you instead of all the looping? Does this work? select asset_num , decode(min(num), 1, 'DHI', 2, 'AHI', 3, 'CHI', '???') as company_id from (select asset_num , decode(company_id, 'DHI', 1, 'AHI',2, 'CHI', 3, 4) as num from assets)group by asset_num; Hope this helps. Jon Walthour - Original Message - From: Helen rwulfjeq To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 01, 2001 5:12 PM Subject: Your ideas will be helpful Hello, all: I'm import data from schema1.table1 (ASSET_NUM,COMPANY_ID,CONSOLI_ID) to schema2.table2 (ASSET_NUM,COMPANY_ID,CONSOLI_ID)using SQL script on Oracle 8i. The situation is like this: In schema1.table1, it does not has a Primary Key and Table1.ASSET_NUM has duplicated records while values in COMPANY_ID are different. For example: ASSET_NUM COMPANY_ID -- -- AA237334 AHI AA237334 DHI On the other hand, in schema2.table2, the corresponding column Table2.ASSET_NUM is defined as a NOT NULL, Primary Key. These tables' definition can't be modified. So, I need to drop the duplicated ASSET_NUM/records from schema1.table1 and then import into schema2.table2. The rule of drop will depend on the priorities of COMPANY_ID (ranking as Dxx, Axx, Cxx , from Keep to Drop . which means between Axx Dxx, "Dxx" will be imported. For instances, like the above example, record contains 'AHI' will be dropped. This rule is only depended on the first Character -- substr(company_id, 1,1). ) I thought about: 1/ loop a cursor on whole table1? 2/ just duplicate records and then the rest records will be "insert into table2" directly. Then how do I decide which record to drop? Use a second cursor? 3/ screen all the duplicate record into a temp table and create a PK on that table and then decide (this sounds very redundant) Any ideas how can I do this? Thanks in advance Helen Do You Yahoo!?Make international calls for as low as $.04/minute with Yahoo! Messengerhttp://phonecard.yahoo.com/
Fw: huge datafiles/need help
I meant EBUILDING. That is what a long day of slow rebuilding indexes can do to you.:-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 02, 2001 9:32 PM Thank you everyone who replied. All suggestions were very helpful. I am bebuilding my indexes in a different tablespace. It runs very very slow.. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 02, 2001 3:51 PM Lyuda; 1. Create a new tablespace for the indexes on a seperate drive. Make sure you do this with a much more reasonable datafile size. (Watch it here maybe they did the big size because they were running out of possible files -- see the max_datafiles parm on the Create Database command) 2. Rebuild the indexes over into the new tablespace. Make sure your initial paramater fits in the initial size of the data files. 3. Drop your old Index Tablespace. As for your ALTER DATABASE DATAFILE RESIZE ... goes; thats what happens when you use all your space. I would suggest at some point to take an outage and reorg that tablespace containing the table as well to get its files down in to a resonably managed size. -Original Message- Sent: Thursday, August 02, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Hi List, I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask me who created such a file because I don't know. I am trying to rescue the database that has multiple problems. Something you've never seen before. Bye the way, did anyone ever run a test how much stuff you can put on your disc before it dyes? Well, yesterday I found a disc which was 99.07 % full. Anyway... The tablespace is ~ 50 % free. The bad news is it doesn't let me to reduce the size of the datafiles by using 'alter database datafile ... resize...';. That tablespace contains 32 indexes. Some of them are as large as 600 -800 M. I need to develop a plan of attack. My options are: 1) drop and recreate the indexes; 2) rebuild the indexes in different tablespace/tablespaces; 3) export/import indexes or may be even tablespace all at once. Is there anyone who has done something similar before? All suggestions are greatly appreciated. That database is screaming for help!! It running Oracle 8.1.6 on NT. 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-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
Advanced Queues
I just started looking into Advanced Queues and I'm wondering what types of apps they're used for? What would be their biggest advantage? Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Brain dead Friday question
Folks, How can I determine rowids of rows locked by a given SID using V$ or DBA* or X$ views ? Can't think anymore today :-) DB Version is 8.1.6. TIA Srini Chavali Oracle DBA Cummins Inc -- 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).
Management server??
Hi Friends When Iam starting my Enterprise Manger console, Its asking Oracle Management server??? What is that?? I tried with giving host name, But it did't work?? How to connect my EPM?? 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).
Inserting a Record into a Table
Can you insert an entire record into a table without having to specify each individual field ?? I need to copy multiple rows in a table after I have modified its key. I do not want to have to specify each field. Is there a way just to select the record, modify the particular field, and then insert the record... WITHOUT having to list all the fields or each individual value ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Is Oracle-Sun honeymoon over?
Oracle wanted a consolidated infrasture...some junk..and Oracle chose HP is flashing in Oracle website (www.oramag.com) Looks like oracle-sun honeymoon is over.. any one has more info what happened behind the doors? = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 -- suggestions to ensure nerdiness in potential IT
I taught a high school class to program Turbo Pascal running on CP/M. Now that was a program. There was one kid in the class who knew way more about this stuff than I did. They all got As. If I remember correctly, Microsoft bought QDOS from Seattle Computer Works for around $50k so they could have an O/S for IBM's first PC. I cannot remember the name of the guy who owned CP/M, but they would not sign IBM's non-disclosure agreement, and sent IBM to Gates. MS had nothing to lose so they signed and the rest is history. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 -- suggestions to ensure nerdiness in potential IT staff
On Thu, 2 Aug 2001,Rachel Carmichael scribbled on the wall in glitter crayon: -oh yeah. you guys know that they published a book of the Fractured Fairy -Tales? Yes, I have it. You had to ask? yes and no, i expected it.;-) -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] It's got to come from the heart if you want it to work! IBM: Intercourse Beats Masturbation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i
From what I read, Oracle9i supports rollback segments if you want to use them. Using them is now referred to as manual undo management. You also have the option of using an undo tablespace, which is referred to as automatic undo management. I think you need to use undo tablespaces if you wish to use the new flashback query features. Me, whenever I need a flashback, I just go watch old episodes of Kung Fu. Plenty of flashbacks in those. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Thursday, August 02, 2001, 3:55:33 PM, you wrote: KK Uhhh...I thought that 9i wasn't going to be using rollback segments anymore? KK Am I wrong, was this alcohol induced dream or something like that? -- 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).
RE: computer history stories
Paul; There are a lot more of us around than the youngsters like to acknowledge . My first and only programming course was at Texas AM University, a fortran course where we had to do our programs on Punch Cards everything else is self taught. I got my Degrees in Nuclear Engineering and Health Physics instead of programming.From that to Oracle Database Administration in more than one not-so-easy lessonGo figure. -Original Message- Sent: Thursday, August 02, 2001 2:35 PM To: Multiple recipients of list ORACLE-L I just want to thank everyone whose stories indicate that they are at least middle-aged--for a while (especially at my last job where the average age was about 25), I'd been feeling as though I was the last over-40 tech-head left on the East Coast. Now, as long as I'm posting, my how-I-got-started story: I majored in liberal arts and worked as a real-estate property manager for about 5 years. Encouraged by programmer friends, I took some classes, in Fortran, Intro. to Computer Logic, and DG MV/8000 assembly language. My first job, in 1981, was as an assembly language programmer, but not for the MV/8000; rather, writing firmware for the Intel 8085. I couldn't believe how primitive it seemed after programming for the then-state-of-the-art MV/8000. The experience, though, of working from hardware schematics and Intel data books was invaluable. You really know how a computer works when you've learned about asserting ALE (address latch enable) and strobing the address bus! Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] -- 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: huge datafiles/need help
Lyuda; 1. Create a new tablespace for the indexes on a seperate drive. Make sure you do this with a much more reasonable datafile size. (Watch it here maybe they did the big size because they were running out of possible files -- see the max_datafiles parm on the Create Database command) 2. Rebuild the indexes over into the new tablespace. Make sure your initial paramater fits in the initial size of the data files. 3. Drop your old Index Tablespace. As for your ALTER DATABASE DATAFILE RESIZE ... goes; thats what happens when you use all your space. I would suggest at some point to take an outage and reorg that tablespace containing the table as well to get its files down in to a resonably managed size. -Original Message- Sent: Thursday, August 02, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Hi List, I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask me who created such a file because I don't know. I am trying to rescue the database that has multiple problems. Something you've never seen before. Bye the way, did anyone ever run a test how much stuff you can put on your disc before it dyes? Well, yesterday I found a disc which was 99.07 % full. Anyway... The tablespace is ~ 50 % free. The bad news is it doesn't let me to reduce the size of the datafiles by using 'alter database datafile ... resize...';. That tablespace contains 32 indexes. Some of them are as large as 600 -800 M. I need to develop a plan of attack. My options are: 1) drop and recreate the indexes; 2) rebuild the indexes in different tablespace/tablespaces; 3) export/import indexes or may be even tablespace all at once. Is there anyone who has done something similar before? All suggestions are greatly appreciated. That database is screaming for help!! It running Oracle 8.1.6 on NT. 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-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- suggestions to ensure nerdiness in potential IT staff
Fractured Fairy Tales and Mr. Peabody and Sherman on Bullwinkle. -Original Message- Sent: Thursday, August 02, 2001 1:12 PM To: Multiple recipients of list ORACLE-L Okay, who remembers Fractured Fairy Tales and the Professor and his boy Sherman? From: Farnsworth, Dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff Date: Thu, 02 Aug 2001 08:41:38 -0800 And the question (still yet to be properly answered) is How many licks does it take to get to the center of a Tootsie Pop? Very nice!! I saw that all the time on my Saturdays watching Rocky and Bullwinkel, Tom and Jerry and my favorite, Bugs Bunny!! Dave -Original Message- Sent: Thursday, August 02, 2001 10:27 AM To: Multiple recipients of list ORACLE-L And the question (still yet to be properly answered) is How many licks does it take to get to the center of a Tootsie Pop? I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: huge datafiles/need help
Hi Lyuda This is not a nice situation to bee in, but the god new is that oracle can help you since you are using version 8.1.6 ! You can use the ALTER INDEX index-name REBUILD TABLESPACE new-tablespace_name; to move the index to a new tablespace and this can even be don online with ALTER INDEX index-name REBUILD ONLINE TABLESPACE new-tablespace_name; BUT then you have to look out for bug 1475310 that should be fixed in 8.1.7. [EMAIL PROTECTED] wrote: Hi List, I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask me who created such a file because I don't know. I am trying to rescue the database that has multiple problems. Something you've never seen before. Bye the way, did anyone ever run a test how much stuff you can put on your disc before it dyes? Well, yesterday I found a disc which was 99.07 % full. Anyway... The tablespace is ~ 50 % free. The bad news is it doesn't let me to reduce the size of the datafiles by using 'alter database datafile ... resize...';. That tablespace contains 32 indexes. Some of them are as large as 600 -800 M. I need to develop a plan of attack. My options are: 1) drop and recreate the indexes; 2) rebuild the indexes in different tablespace/tablespaces; 3) export/import indexes or may be even tablespace all at once. Is there anyone who has done something similar before? All suggestions are greatly appreciated. That database is screaming for help!! It running Oracle 8.1.6 on NT. 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-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 smime.p7s
Re: 9i
It's an optional either/or thing Kevin. Alchohol induced? I dunno, anything you wanna tell us? ;) Jared On Thursday 02 August 2001 12:55, Kevin Kostyszyn wrote: Uhhh...I thought that 9i wasn't going to be using rollback segments anymore? Am I wrong, was this alcohol induced dream or something like that? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unix terminal question
Hi List, I have turned on the database audit and found that someone from terminal pts/1 deleted a record yesterday. How to know in Unix (Solaris) who (osuser and workstation) was login using pts/1 yesterday ? Or also can we find it from oracle audit (sys.aud$, etc) ? Tia 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).
OT -- suggestions to ensure nerdiness in potential IT staff
computer trivia from the pre-PC days: what computer company had the first huge marketing success advertising its word processing system on TV during the Superbowl football game? -- From: Boivin, Patrice J [EMAIL PROTECTED] Date: Wed, 01 Aug 2001 16:20:48 -0300 Subject: OT -- suggestions to ensure nerdiness in potential IT staff answer spelled backwards: GNAW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- suggestions to ensure nerdiness in potential IT staff
I can't really tell if no more answers are coming in or things are just very slow but I'll try to fill in the answers to my questions that have not been answered. Looks like the questions about the floppy drive (or should I say drives as I had the luxury of dual drives) are the ones that need some answers. The manufacture (now gone) was Micropolis and they later made hard drives that we used on our UNIX boxes when we moved off the main frame about ten years ago. The hard sectored disks had holes to separate the sectors (the holes were much to large to separate tracks). Micropolis used a 16 hard sector floppy and then soft sectored each hard sector into two. They had an ad about never so many tracks that showed railroad tracks. Yes, Logo was based on LISP. It was very bad practice to use loops in APL. They were avoided by using vectors. I calculated some very actuate statistical tables for my husband on a DEC-10 using APL and picking the exact (rather than approximated values) out of the vector in about the time frame that this discussion started with - some time in the early 80s. We also had APL on the CP/M machine (a Vector Graphics if anyone is curious) but it didn't have precision of the DEC-10 and later got a DOS version. I know it was the thing to try to do everything in one line but it was also possible to write readable code (as long as you knew the symbols) and of course there was always the lamp for comments. Speaking of on the CP/M machine and later a DOS version, I would think that the word processor that was being asked about was probably WordStar. We had that one on the CP/M machine (it was considered THE word processor at that time) and then DOS before WordPerfect. Actually had a strange experience installing the DOS version. I can't remember how much memory we had on that machine but it was a lot for it's day and WordStar gave me an error that I had insufficient memory. After checking everything I could think of, I installed a RAM disk to cut the memory down to a size mentioned in the documentation and low and behold the WordStar worked. IBM standard label tapes could actually be cartridges (3480/3490 or are those obsolute now?). The thing about them (besides EBCDIC which no one not on an IBM used) is that they had three files for one logical file. The header and footer(?) contained documention. In addition to the format stuff they could contain: a file name, the operating system under which the file was written, the date, and I think even some sort of machine ID. If the first file, the header also had a volumn ID. I did help to set up a system in perl under AIX that would compare the information in a header with information that we had other places including an Oracle database, did some other things, and put information into the database. It would have been a lot harder without those standard label tapes. Yes, I have used punch cards. The first computer I used was an IBM/1620. My first work with stat packages, SAS, SPSS, BMDP, was on a remote machine where the job was submitted on punch cards and if I remember correctly the jobs were not run when submitted but at a later time so that an out of order card or incorrectly punched one could make things a very slow process. 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).
Re: truncate during query
Ben, You could test this yourself in about a minute. I don't have a db in front of me, but I'm pretty sure the truncate, or any ddl operation, will fail telling you it couldn't get a nowait lock. Try it. Create a table, say t (a varchar2(1)); Then, insert into t ('x'); Then insert into t select * from t; Do this many, many times until it takes several seconds to execute. (If you commit between those inserts, it'll be easier on your rollbacks.) When you have all these rows inserted, open another SQL session. Type truncate table t; but DONT press enter yet. Back in the first window, run a long query on t, maybe union the query with itself a few times, so that the query takes 10 or 11 seconds to execute; that should give you enough time to switch to the truncate window and hit enter. Then see what happens, and you'll have your answer. Simple, no? Ben Poels wrote: Hi What happens if you truncate a table, or drop an index, that is currently in use by a long running query? Does the query fail or does the truncate/drop hang up? Thanks in advance, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT (fwd) Looking to resurrect .ZZZ archive file from Kaypro/CPM days
Since I don't think this got a usable reply on list it came from and it sounds like some people on this list had a Kaypro, I decided to see if we are geeky enough that someone has an answer. The closest I got to finding a solution at the time was someone who said it sounded familiar - didn't have a Kaypro and my CP/M machine is long gone. Most of the people on the list it came from probably would not consider themselves geeks and I'm sure have wondered what I'm good for when I displayed such tendencies. Pat I have a user (professor) who, way back, archived some work in some files with a .ZZZ extension. He has succeeded in transferring them from his old Kaypro (running the CPM OS) to his Windows machine, but he can't find a program that will unzip them (e.g. WinZip won't do it). He doesn't recall the name of the program that created the file - memory fades... For all I know, .ZZZ may have been just what he decided to designate as the file extension, rather than the result of a standard naming convention. But I thought I'd see if the .ZZZ file extension rings any bells with anyone out there. Searching on the web yields lots of documents containing ZZZ in them, but, wading through these, I have been unable to find anything that seems relevant to my question. (This matter of .ZZZ archive files - if it really is a matter at all - seems to fall outside the range of history covered on the web.) I would be grateful if anyone out there could offer some answeres, insights, or suggestions regarding this matter. -- 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).
RE: OT -- suggestions to ensure nerdiness in potential IT
You mean that they didn't have PCs, internet, MS Windows and Night Show with Ed Sullivan back there at Alamo? What in the world has prompted Santa Anna to attack, then? -Original Message- From: Terry Ball [mailto:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Subject: Re: OT -- suggestions to ensure nerdiness in potential IT Actually, Davy Crockett was dead before the invention of TV. But he was played by Fess Parker in the TV movies with the same name. Having said that, I don't beleive that Fess Parker, Red Skelton and Danny Kaye ever together, but I have been know to be wrong before. Terry Gogala, Mladen wrote: Have Bullwinkle,Davy Crockett, Red Skelton and Danny Kaye ever been in the same movie together? What about Rocky, he and Bullwinkle used to be inseparable. I didn't know that Bullwinkle was moonlighting with Danny Kaye and Skelton? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Re: NOARCHIVELOG, ONLINE redolog corrupted - solved
Joe, That's true, but only if the current logs are not needed for instance or media recovery. For example if you want to open from a cold backup and you don't have the online logs you can fake recovery and then open resetlogs and it will recreate them for you: startup mount recover database until cancel -- you should get a message saying media recovery complete or not needed since everything is already in sync if it's a true cold backup alter database open resetlogs; You have to do the recover database until cancel to fake an incomplete recovery so you can then open with resetlogs; otherwise you'll get an error saying resetlogs isn't needed. Whenever you open with resetlogs, new logs will be created if they don't exist. In fact a trick to get a db open quicker when using resetlogs if you have a large # of online log groups and members is to drop all except the bare minimum (2 groups, 1 member each) to open the db. Then once the db is open you can add the additional members and groups. HTH, -- Anita --- Joe Testa [EMAIL PROTECTED] wrote: its been at least a year since this wa sstated but i believe i read(have not tried it), that you could have totally erase your redo logs(like you had a serious failure in which all copies were lost) and a open restelogs would have recreated them. I think that was explained by someone on the list. Would that have helped any? joe Rahul wrote: list , (solaris, 8.1.6) two redolog thread, two member each, one member from each thread on raw while doing import (35 million rows), the raw member of thread 1 was not available, errors in alert log i dropped the raw member of thread 1, and continued import.. lgwr crashed the instance, the ONLY member of the thread 1, (current, online) got corrupted. tried to re-create the controlfiles WITHOUT the corrupted (online) , cannot as that thread is required for recovery tried recovery until change (some SCN in the past) , recovery completed BUT open restlogs will return error. file requiure more media recovery to be consistent. tried media recovery again error... unable to read block nnn ..unix IO error set _allow_resetlogs_corruption = true ABLE TO OPEN THE DB (with errors in alert log) switched the log, dropped the corrupted one.. the _allow_reset parameter was the last resort... was their anything else i could have tried ? regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Exploding the Myths paper
Doh! Never mind. I just discovered how to use the scroll bar on my browser ;-) (I was looking under one of the main all day events and not under the general section) - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: huge datafiles/need help
Lyuda, You didn't say if you have other disk space available or not. If you do I would create the index/indexes tablespace/s on different drives then drop them from the original location. After you get breathing room you can reorg the database to a more comfortable setup. When you have removed the indexes you will have to exp/imp the tables to free up the fragments in the tablespace. Good Luck. ROR mª¿ªm [EMAIL PROTECTED] 08/02/01 03:45PM Hi List, I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask me who created such a file because I don't know. I am trying to rescue the database that has multiple problems. Something you've never seen before. Bye the way, did anyone ever run a test how much stuff you can put on your disc before it dyes? Well, yesterday I found a disc which was 99.07 % full. Anyway... The tablespace is ~ 50 % free. The bad news is it doesn't let me to reduce the size of the datafiles by using 'alter database datafile ... resize...';. That tablespace contains 32 indexes. Some of them are as large as 600 -800 M. I need to develop a plan of attack. My options are: 1) drop and recreate the indexes; 2) rebuild the indexes in different tablespace/tablespaces; 3) export/import indexes or may be even tablespace all at once. Is there anyone who has done something similar before? All suggestions are greatly appreciated. That database is screaming for help!! It running Oracle 8.1.6 on NT. 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-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Exploding the Myths paper
My apologies to the entire list for these last two messages I meant to send them to Rachel personally and I forgot that since the listserv changed a while ago I cannot hit reply (Need to open e-mail, right click properties in the title and get the address) go ahead and flame me all you want, I deserve it ... having one of those totally STUPID days ... Babette - Original Message - To: [EMAIL PROTECTED] Sent: Thursday, August 02, 2001 9:11 PM Doh! Never mind. I just discovered how to use the scroll bar on my browser ;-) (I was looking under one of the main all day events and not under the general section) - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: computer history stories
I joined the USN in 1966 to avoid the draft. I got sent to Data Systems Technician school for computer training. We used a Univac CADET (Can't Add Doesn't Even Try); which used a lookup matrix in place of real adder logic. It had 4K worth of 18 bit word magnetic core RAM. The programs were entered in octal via toggle switches in actual machine code; not even assembler. All too frequently the memory would get zapped by a ship that turned on its radar for testing. :-( After I got out of the Navy went to collge I got to use a real computer, the IBM 360/40 running PCP. My 1st high level language was Fortran 2; which was so MUCH easier to use than machine code. Since then I've worked on/with a decent assortment of hardware, operating systems and programming languages. -- 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).
RE: OT -- suggestions to ensure nerdiness in potential IT staff
Title: RE: OT -- suggestions to ensure nerdiness in potential IT staff Famous...I hope at least recognized by my deeds. It's funny this is coming up, I am currently in the middle of starting a dream of mine. Basically I am starting a non profit organization designed to teach these hot in demand IT skills to a resource this country has overlooked-young inner city minorities. I know there are people already trying to do similar stuff and oracle has there program they're working on with high schools, but I feel that my business plan and ideas will be superior to what's currently out there, not to mention that I will have an execution plan these kids will latch onto, different from the traditional high school setting they're tired of. I feel that I am an example of what I can do with them, as I said I didn't go to college for CIS, am not a super brain, but I had an interest in computers and also a hunger to make a good living (legally). In the span of three years I have fully changed around my life. I now make good money (I am currently putting my sister through college) and am living a great clean life. Oracle literally kept me out of jail (no need to go into specifics)! I feel this IT route is a new alternative for inner city youth to make it out of the 'hood. This is a more realistic manner to a good life than the traditional routes of making it big in: sports,music,entertainment or going the wrong route and getting into dealing drugs. I am living just as good as most of the drug dealers I know or have come in contact with and being realistic here, these guys are looked up to by the younger kids in the neighborhood. As a kid I always looked up to them and still see the same thing going on today. If I can get these kids to see a different way to attain the same possessions the dealers have (for the most part, that's what it boils down to-money and material objects) and get some in the IT field, I've done my job. I have been teaching the DBA track here at FSU for the last in preparation for the stated above goal and have started to recruit people for the board and also to teach. Today, in fact I received the conformation that I have been given education consent from the New York State Department of Education (yes!), next comes the 501(c) and I'll be quitting my job hoping to get this thing off the ground. In fact Rachel I have had you in mind to ask to join my board but haven't approach or asked the board for input until I was 'official'. Sorry for ranting, any advice (good or bad) will be greatly appreciated. Thanks. Ivan
Re: OT -- suggestions to ensure nerdiness in potential IT
3) What company made the first Portable (luggable) computers? It was either Kaypro or Osborne. The Ozzy had a little tiny 40-column screen and dual 5.25 floppies. The Kaypro had an 80-column screen and dual floppies. I had a compaq 'portable' that was the size of an old, big, not-yet invented 486, but had a monitor embedded in the box. 15 years later, my brother tried to use this computer for something real, and I had to explain to him why I couldn't shlep around this thing, and why it wouldn't do that much for him altogether. He probably still has it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Converting Inner join in MS-SQL to Oracle SQL syntax
Cherie, I may be completely wrong on this, but I seem to remember my Intro to SQL instructor at Oracle Ed telling the class that a MS SQL inner join was the same as just a normal join in Oracle. HTH (List please correct me if I'm wrong) Rodd On 03 Aug 2001 09:10:42 -0800, [EMAIL PROTECTED] wrote: A developer has sent me a MS-SQL statement that he recieved from a vendor. He would like to convert this to run on Oracle. It's pretty close already but I'm having trouble with the inner join. Is there a kind soul familiar with MS-SQL that could convert this over to the right 8.0.4 Oracle syntax? select KS_KNOWLEDGEOBJECTID from KS_KNOWLEDGEOBJECT where KS_AVAILABLE = 0 and not exists (select KS_KNOWLEDGEOBJECTID from KS_CONCEPTSTRING inner join KS_CONCEPT on KS_CONCEPTSTRING.KS_CONCEPTID = KS_CONCEPT.KS_CONCEPTID where KS_KNOWLEDGEOBJECT.KS_KNOWLEDGEOBJECTID = KS_CONCEPTSTRING.KS_KNOWLEDGEOBJECTID and KS_CONCEPTTYPEID = '2') Thanks for any assistance, Cherie Machler Oracle DBA Gelco Information Network -- 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: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: completely off-topic question...
Methuselah's Children From: Vergara, Michael (TEM) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: completely off-topic question... Date: Fri, 03 Aug 2001 11:32:47 -0800 ...and...oh PIQQ...I can't remember the name of the book...the History of the Future..you remember...the final short story introduces Woodrow Wilson Smith and Andrew 'Slipstick' Libby... Um...the days are short... --- === Michael P. Vergara | Don't worry about the world ending today; Oracle DBA | it's already tomorrow in Australia. Guidant Corporation | - Charles Schulz -Original Message- Sent: Friday, August 03, 2001 12:01 PM To: Multiple recipients of list ORACLE-L some of his earlier work predates my reading of science fiction. I have however, read all his fiction, multiple times. Time Enough For Love got me through my first (graduation present) trip to Europe -- by the time I got home, the pages were falling out from re-reading. I still re-read him, it's like coming home when I do. So... do you grok? I've read almost all of Asimov's science fiction, I stopped when he started looping the Foundation back into the Daneel series. I don't know of anyone who has read all his works. My mom met him (and got me his autograph) when he spoke at a librarians meeting. Never liked Clarke. Spider Robinson (and Callahan) rules. Still. Rachel From: Terry Ball [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: completely off-topic question... Date: Fri, 03 Aug 2001 08:47:05 -0800 TANSTAAFL /tan'stah-fl/ [acronym, from Robert Heinlein's classic The Moon is a Harsh Mistress.] There Ain't No Such Thing As A Free Lunch, often invoked when someone is balking at the prospect of using an unpleasantly heavyweight technique, or at the poor quality of some piece of free software, or at the signal-to-noise ratio of unmoderated Usenet newsgroups. What? Don't tell me I have to implement a database back end to get my address book program to work! Well, TANSTAAFL you know. This phrase owes some of its popularity to the high concentration of science-fiction fans and political libertarians in hackerdom. I have read ALL of Heinlein's work multliple times. And, since I read them as they came out, I got the benefit of getting them on the timeline. Terry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Re: function as default constraint for column
No, it's not possible - use 'before' trigger. I think, I read you canuse function as defaultin 9i. Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED] - Original Message - From: Harvinder Singh To: Multiple recipients of list ORACLE-L Sent: Friday, August 03, 2001 3:32 PM Subject: function as default constraint for column HI, I have a function which does some manipulation on date and i want to put that function as default value for coulmn. But i am getting error : alter table dd modify(dd date default getutcdate()) * ERROR at line 1: ORA-04044: procedure, function, package, or type is not allowed here Can it be possible to define function as default value..if not some other way to define this.execpt trigger.. Function does not have any IN paramter defined. Thanks Harvinder
RE: OT -- suggestions to ensure nerdiness in potential IT staff
very well carry on:( -Original Message- Carmichael Sent: Thursday, August 02, 2001 3:45 PM To: Multiple recipients of list ORACLE-L young whippersnapper! quiet down and let us old fogies reminisce :) From: Kevin Kostyszyn [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff Date: Thu, 02 Aug 2001 08:41:39 -0800 yeah, my father still try's to impress me with stories of punch cards and such. It's pretty funny. The oldest computer I know of and still have is a compaq portable computer. It has the old 5 1/4 floppy drives and a little tiny screen. It's basically a suitcase, weighs about 40 pounds, the bottom is the keyboard. Kinda cool, I remember playing games on it as a kid and thinking it was the most amazing thing. Now it makes a good foot rest, but that's about it:) kk -Original Message- Sent: Thursday, August 02, 2001 10:52 AM To: Multiple recipients of list ORACLE-L And just think about the PC being an advanced system for some of us. Wait until we again start talking about using paper tapes and having to use scotch tape to put them back together to run them through. Or even the older guys that talk about switch boards. I am not as old as them. My computer days just go back to the mid 70's. I love this stuff(being a nerd wannabe), but I don't have a frickin clue what any of you are talking about:) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). _ 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: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- suggestions to ensure nerdiness in potential IT staff
The sad thing is, it really didn't matter back then! Character mode coming back to a orange or green monitor (at least on the Compaq), it didn't do too bad keeping up with typing. Or so it seemed, until the next boost came out then woohoo! look how fast I can go! Now if I'm not on cable or a T1 I want to go spin the hamster's cage Funny thing - I've just started using IM. I don't like it! When we did similar stuff on a VAX in the late 80's it was screaming, even over a 1200 baud modem, compared to the Yahoo IM. I want my VAX back, whine ;-) Linda -Original Message- Sent: Thursday, August 02, 2001 1:55 PM To: Multiple recipients of list ORACLE-L heck, I did production work over a 300 baud modem -- the one where you had to dial in and then place the handset into the cups :) and I thought it was the speediest thing ever From: Seley, Linda [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff Date: Thu, 02 Aug 2001 10:28:15 -0800 One of those Compaqs was the first portable I took home from work 7 years ago! It sat in my basement until 3 years ago when I lugged it back - we were moving and I didn't want to be responsible for it any more! (Gosh, a 1200k modem?) Same company that is *still* using PL/1 as it's mainframe programming language and APL in the actuarial department. Linda -Original Message- Sent: Thursday, August 02, 2001 10:42 AM To: Multiple recipients of list ORACLE-L yeah, my father still try's to impress me with stories of punch cards and such. It's pretty funny. The oldest computer I know of and still have is a compaq portable computer. It has the old 5 1/4 floppy drives and a little tiny screen. It's basically a suitcase, weighs about 40 pounds, the bottom is the keyboard. Kinda cool, I remember playing games on it as a kid and thinking it was the most amazing thing. Now it makes a good foot rest, but that's about it:) kk -Original Message- Sent: Thursday, August 02, 2001 10:52 AM To: Multiple recipients of list ORACLE-L And just think about the PC being an advanced system for some of us. Wait until we again start talking about using paper tapes and having to use scotch tape to put them back together to run them through. Or even the older guys that talk about switch boards. I am not as old as them. My computer days just go back to the mid 70's. I love this stuff(being a nerd wannabe), but I don't have a frickin clue what any of you are talking about:) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Seley, Linda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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