RE: Hi!!
Teresita, The first thing I would do is to make sure and make full, coldbackups by shutting down the database and doing a tape backup of the disk your database files are on. This will keep you out of trouble immediately. Then, since you said you were using Oracle 9.2.0.2,set up yourbackups to go every night using RMAN, straight to the tape device. Oracle RMAN handles this. It includes a driver for Veritas. There is an excellent book on RMAN. It's called Oracle9i RMAN Backup Recovery by Robert G. Freeman and Matthew Hart. It's an Oracle Press book that you can get on amazon.com or Borders, Barnes Noble, etc. That will guide you through the process. Here is the link: http://www.amazon.com/exec/obidos/tg/detail/-/0072226625/qid=1074186675/sr=1-2/ref=sr_1_2/103-6635244-7274242?v=glances=books You can do this. Just start with protecting your data immediately with cold backups, then move on to using RMAN for full backups. Then move on to incremental backups. I hope that helps. Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.
RE: Hi!! Veritas Backup Question
Hi!! TheCD's that we have saidOracle 9.2.0.1.0, but I did not see any that said RMAN,( when I asked the DBA the version of Oracle that we have and he said 9.2.0.2.1.) the RMAN is inside a specify CD? [EMAIL PROTECTED] 01/14/04 09:49PM Teresita, What your DBA is talking about is Oracle's RMAN backup utility. There us an interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian for the backups. The first thing I'd suggest is finding out what version of Oracle your using. There are significant differences in using and setting up the RMAN and Veritas software between the two. Check out the documentation CD on RMAN that shipped with your database. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: Hi!! Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - ?-- ?-- ? ?- ?- Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
RE: Hi!! Veritas Backup Question
Teresita, One of the CD's is titled documentation. You'll find the RMAN manual thereon. There are two, Recovery Manager Quick Reference and Recovery Manager Reference. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Thursday, January 15, 2004 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Hi!! Veritas Backup Question Hi!! TheCD's that we have saidOracle 9.2.0.1.0, but I did not see any that said RMAN,( when I asked the DBA the version of Oracle that we have and he said 9.2.0.2.1.) the RMAN is inside a specify CD? [EMAIL PROTECTED] 01/14/04 09:49PM Teresita, What your DBA is talking about is Oracle's RMAN backup utility. There us an interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian for the backups. The first thing I'd suggest is finding out what version of Oracle your using. There are significant differences in using and setting up the RMAN and Veritas software between the two. Check out the documentation CD on RMAN that shipped with your database. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: Hi!! Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - -- -- - - Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
RE: Hi!! Veritas Backup Question
Thanks I saw that CD. [EMAIL PROTECTED] 01/15/04 01:04PM Teresita, One of the CD's is titled documentation. You'll find the RMAN manual thereon. There are two, Recovery Manager Quick Reference and Recovery Manager Reference. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Thursday, January 15, 2004 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Hi!! Veritas Backup Question Hi!! TheCD's that we have saidOracle 9.2.0.1.0, but I did not see any that said RMAN,( when I asked the DBA the version of Oracle that we have and he said 9.2.0.2.1.) the RMAN is inside a specify CD? [EMAIL PROTECTED] 01/14/04 09:49PM Teresita, What your DBA is talking about is Oracle's RMAN backup utility. There us an interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian for the backups. The first thing I'd suggest is finding out what version of Oracle your using. There are significant differences in using and setting up the RMAN and Veritas software between the two. Check out the documentation CD on RMAN that shipped with your database. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: Hi!! Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - ?-- ?-- ? ?- ?- Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
RE: Hi!! Veritas Backup Question
Thanks I saw that CD. [EMAIL PROTECTED] 01/15/04 01:04PM Teresita, One of the CD's is titled documentation. You'll find the RMAN manual thereon. There are two, Recovery Manager Quick Reference and Recovery Manager Reference. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Thursday, January 15, 2004 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Hi!! Veritas Backup Question Hi!! TheCD's that we have saidOracle 9.2.0.1.0, but I did not see any that said RMAN,( when I asked the DBA the version of Oracle that we have and he said 9.2.0.2.1.) the RMAN is inside a specify CD? [EMAIL PROTECTED] 01/14/04 09:49PM Teresita, What your DBA is talking about is Oracle's RMAN backup utility. There us an interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian for the backups. The first thing I'd suggest is finding out what version of Oracle your using. There are significant differences in using and setting up the RMAN and Veritas software between the two. Check out the documentation CD on RMAN that shipped with your database. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: Hi!! Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - ?-- ?-- ? ?- ?- Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
RE: Hi!!
Teresita, What your DBA is talking about is Oracle's RMAN backup utility. There us an interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian for the backups. The first thing I'd suggest is finding out what version of Oracle your using. There are significant differences in using and setting up the RMAN and Veritas software between the two. Check out the documentation CD on RMAN that shipped with your database. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: Hi!! Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - -- -- - - Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
RE: Hi list
Congratulations. I know the feeling! Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, January 03, 2004 3:15 PM To: Multiple recipients of list ORACLE-L List, thanks to all of you I finally completed my OCP exams (thought they would never end) Thanks for your help -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hi Honey I'm Home!
Bambi, welcome back! -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bellow, Bambi Sent: Thursday, September 25, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Subject: Hi Honey I'm Home! Friends -- Just a quick hello (before I get back to this stupid ora-27100 issue) to let you know that since I'm on a job where I'm a DBA rather than a scripter, I'm back on the list. See ya! Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hi Honey I'm Home!
Bambi, we missed ya. joe Bellow, Bambi wrote: Friends -- Just a quick hello (before I get back to this stupid ora-27100 issue) to let you know that since I'm on a job where I'm a DBA rather than a scripter, I'm back on the list. See ya! Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hi Honey I'm Home!
Welcome back. (how's Eclectricity?) Henry -Original Message- Bellow, Bambi Sent: Thursday, September 25, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Friends -- Just a quick hello (before I get back to this stupid ora-27100 issue) to let you know that since I'm on a job where I'm a DBA rather than a scripter, I'm back on the list. See ya! Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hi Honey I'm Home!
Henry -- Eclecticity is doing great. 4 years and going strong. Thanks for asking! Bambi. -Original Message- Sent: Thursday, September 25, 2003 3:50 PM To: Multiple recipients of list ORACLE-L Welcome back. (how's Eclectricity?) Henry -Original Message- Bellow, Bambi Sent: Thursday, September 25, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Friends -- Just a quick hello (before I get back to this stupid ora-27100 issue) to let you know that since I'm on a job where I'm a DBA rather than a scripter, I'm back on the list. See ya! Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: hi i'm back amongst the living
Come On Walt... I thought you installed Windozz first to allow the Oracle to install without a hitch and then upgraded your pc to Linux. Nt first, SP4,SP5,SP6 then Oracle 8.0, migrate to 8.1.6, upgrade to 8.1.7, patch up to 8.1.7.3, and if your lucky migrate to 9.0.1. When all is said and done and the database is working flawless you install the Linux release you desire. This way you eliminate the glibc and JDK patch for oracle's GUI installers. Is it correct that next year the IOUG conference will be in Orlando again??? I can afford it again.. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/19/02 12:33AM Joe, Glad you had a good time. Sorry I didn't make it, my company pulled funding at the last minute. As far as Oracle and Linux is concerned, I have a lot of experience. You have to install Linux first. That makes everything else a lot easier. --Walt Weaver Bozeman, Montana -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/18/2002 6:38 PM Lots of good stuff at IOUG conference this year, the food sucked, blah. Technical sessions were good(the few i went to), met some people been talking to for years on this forum. Party was as sea world, it was ok. We thought maybe Shamu was going to eat Rich N, but that didnt happen. For those of you who didnt make it :(, maybe next year in Orlando, FL at the Swan/Dolphin hotel, april 27-may 1st. Lots of first time presenters and for those of you who know Marlene Theriault, she did her last IOUG presentation this time around, she's officially retiring from the Oracle world. She's doing the european one and then she's quitting, no more books either. We'll miss her dearly. So for those of you who've contemplated presenting before a conference, call for papers should be in jul/aug at latest for Orlando. I think i'm done with logminer, milked it for too many years, next year i'm toying around with a couple of ideas: 1. Recovery Concepts: Let's blow up a database and do live recovery during the presentation 2. Linux: Can I really do a no-brainer install of linux and oracle?, Here are the steps. Oh well, off to dinner and chillin for one more day. For those who didn't make it, we missed you. Joe -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: hi i'm back amongst the living
Yes next year back to orlando. joe Ron Rogers wrote: Come On Walt... I thought you installed Windozz first to allow the Oracle to install without a hitch and then upgraded your pc to Linux. Nt first, SP4,SP5,SP6 then Oracle 8.0, migrate to 8.1.6, upgrade to 8.1.7, patch up to 8.1.7.3, and if your lucky migrate to 9.0.1. When all is said and done and the database is working flawless you install the Linux release you desire. This way you eliminate the glibc and JDK patch for oracle's GUI installers. Is it correct that next year the IOUG conference will be in Orlando again??? I can afford it again.. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/19/02 12:33AM Joe, Glad you had a good time. Sorry I didn't make it, my company pulled funding at the last minute. As far as Oracle and Linux is concerned, I have a lot of experience. You have to install Linux first. That makes everything else a lot easier. --Walt Weaver Bozeman, Montana -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/18/2002 6:38 PM Lots of good stuff at IOUG conference this year, the food sucked, blah. Technical sessions were good(the few i went to), met some people been talking to for years on this forum. Party was as sea world, it was ok. We thought maybe Shamu was going to eat Rich N, but that didnt happen. For those of you who didnt make it :(, maybe next year in Orlando, FL at the Swan/Dolphin hotel, april 27-may 1st. Lots of first time presenters and for those of you who know Marlene Theriault, she did her last IOUG presentation this time around, she's officially retiring from the Oracle world. She's doing the european one and then she's quitting, no more books either. We'll miss her dearly. So for those of you who've contemplated presenting before a conference, call for papers should be in jul/aug at latest for Orlando. I think i'm done with logminer, milked it for too many years, next year i'm toying around with a couple of ideas: 1. Recovery Concepts: Let's blow up a database and do live recovery during the presentation 2. Linux: Can I really do a no-brainer install of linux and oracle?, Here are the steps. Oh well, off to dinner and chillin for one more day. For those who didn't make it, we missed you. Joe -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S 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: hi i'm back amongst the living
Joe, Glad you had a good time. Sorry I didn't make it, my company pulled funding at the last minute. As far as Oracle and Linux is concerned, I have a lot of experience. You have to install Linux first. That makes everything else a lot easier. --Walt Weaver Bozeman, Montana -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/18/2002 6:38 PM Lots of good stuff at IOUG conference this year, the food sucked, blah. Technical sessions were good(the few i went to), met some people been talking to for years on this forum. Party was as sea world, it was ok. We thought maybe Shamu was going to eat Rich N, but that didnt happen. For those of you who didnt make it :(, maybe next year in Orlando, FL at the Swan/Dolphin hotel, april 27-may 1st. Lots of first time presenters and for those of you who know Marlene Theriault, she did her last IOUG presentation this time around, she's officially retiring from the Oracle world. She's doing the european one and then she's quitting, no more books either. We'll miss her dearly. So for those of you who've contemplated presenting before a conference, call for papers should be in jul/aug at latest for Orlando. I think i'm done with logminer, milked it for too many years, next year i'm toying around with a couple of ideas: 1. Recovery Concepts: Let's blow up a database and do live recovery during the presentation 2. Linux: Can I really do a no-brainer install of linux and oracle?, Here are the steps. Oh well, off to dinner and chillin for one more day. For those who didn't make it, we missed you. Joe -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hi
This is a virus. [EMAIL PROTECTED] 12/04/01 03:05PM How are you ? When I saw this screen saver, I immediately thought about you I am in a harry, I promise you will love it! -- 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).
Re: Hi
This is a new virus. Do not open the attachment. virus text** How are you ? When I saw this screen saver, I immediately thought about you I am in a harry, I promise you will love it! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wilfred Li, Ph.D. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hi
Everyone: The email from Alan had the newest Internet worm on it! Please don't open ANY scr files. Here's a link to the virus info: http:[EMAIL PROTECTED] Have a great evening. adam Alan Dewey wrote: How are you ? When I saw this screen saver, I immediately thought about you I am in a harry, I promise you will love it! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adam Bultman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hi what is CUBE Function
The cube function is part of the new analytic sql stuff. It computes subtotals for all the combinations of the dimensions. --- Dhanasekar [EMAIL PROTECTED] a écrit : Hi.. Can anyone explain me what is a CUBE Function In Oracle.. Dhanasekar ATTACHMENT part 2 image/bmp name=skyblue.bmp = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hi what is CUBE Function
Dhanasekar, Visit http://www.bijoos.com/oratom/ot_200011.htm http://www.bijoos.com/oratom/ot_200011.htm There is some explanation on CUBE. HTH Suhen Hi.. Can anyone explain me what is a CUBE Function In Oracle.. Dhanasekar -- 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: Hi what is CUBE Function
have u read the docs, there is great info on how it asnd rollup works. joe Dhanasekar wrote: Hi.. Can anyone explain me what is a CUBE Function In Oracle.. Dhanasekar -- Joe Testa http://www.oracle-dba.com 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: Hi need some please
hi bill, Why cann't you try with 'MINUS' set operator exists in sql?. Select * from table_b minus Select * from table_a Hope that this will help you. Nirmal. -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Sunday, May 20, 2001 7:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: Hi need some please Depending if you mean rows or individual columns but this shouldnt' be to difficult with PL/SQL. With SQL it will be a little more difficult but doable. Unfortunately I don't know a site with this as I never had needed to. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/18/01 2:41 PM Hi All, Does anyone have a script that will compare table_a to table_b and delete the dups in table_b, or a site that might have one? Thanks Very Much for any ideas. -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hi need some please
Depending if you mean rows or individual columns but this shouldnt' be to difficult with PL/SQL. With SQL it will be a little more difficult but doable. Unfortunately I don't know a site with this as I never had needed to. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/18/01 2:41 PM Hi All, Does anyone have a script that will compare table_a to table_b and delete the dups in table_b, or a site that might have one? Thanks Very Much for any ideas. -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hi need some please
Title: RE: Hi need some please Is what your trying to do as simple as?... delete from TAB_B B where exists (select 'x' from TAB_A A where A.col1 = B.col1 and A.col2 = B.col2 and A.etc = B.etc ); -Original Message- From: Bill Conner [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 11:42 AM To: Multiple recipients of list ORACLE-L Subject: Hi need some please Hi All, Does anyone have a script that will compare table_a to table_b and delete the dups in table_b, or a site that might have one? Thanks Very Much for any ideas. -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).