RE: change a database connection in a stored procedure?
Hi Sergey, I am using dynamic SQL but it is returing error for connect statement. Can u give me some example code. Rgds Kranti -Original Message- Sent: Tuesday, May 07, 2002 7:38 AM To: Multiple recipients of list ORACLE-L Hello kranti, Use dynamic SQL. Monday, May 06, 2002, 8:23:29 PM, you wrote: kp Hi List, kp Can someone tell me is it possible to change a database connection kp in a stored procedure? if so how? kp TIA kp Kranti -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: kranti pushkarna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: change a database connection in a stored procedure?
Hello kranti, I made a mistake. You can't change your database connection at all from stored procedure (there is no such SQL command connect it's a sqlplus directive). When I gave the answer I thought about database link. You can drop and create it using dynamic SQL. Tuesday, May 07, 2002, 2:08:27 PM, you wrote: kp Hi Sergey, kp I am using dynamic SQL but it is returing error for connect statement. Can u kp give me some example code. kp Rgds kp Kranti kp -Original Message- kp Sent: Tuesday, May 07, 2002 7:38 AM kp To: Multiple recipients of list ORACLE-L kp Hello kranti, kp Use dynamic SQL. kp Monday, May 06, 2002, 8:23:29 PM, you wrote: kp Hi List, kp Can someone tell me is it possible to change a database kp connection kp in a stored procedure? if so how? kp TIA kp Kranti -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 8.1.7.3 - Good or Bad?
Bugs in 8.1.7.3 that Can Crash the Box ? What Bug Number is that ? Can you Alternately post Kevin Toepke E-mail OR Specify the Date of His posting ? -Original Message- Sent: Tuesday, May 07, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Oracle Gurus, I seem to be running into memory leaks on an 8.1.7.0 database on Solaris 8. After searching metalink and reading some patch release notes, it looks like we might be having problems with the XML parser and/or LOBs. We are thinking of upgrading to 8.1.7.3, but I am a little leery after Kevin Toepke posted this message a few weeks ago: First of all, there are some serious problems with 8.1.7.3 that can cause database crashes and corruption. One bug (may be solaris specific) can crash the box. I would highly recommend that you only upgrade to 8.1.7.2 unless absolutely necessary. We have downgraded all of our 8.1.7.3 databases to 8.1.7.2 (a *very* painful experience) ... Kevin makes it sound like a terrible patch. What do all of you think that have gone to 8.1.7.3? Was it worth it? Anyone using LOBs and/or XML utilites with this release? Thanks, Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: I need to change the instance name (to Dennis)
Dennis : Thanks for your answer. Well, I need to downgrade my database, changing EE for SE, so ... The most problem is that the v$instance is used in the aplication. I saw in the metalink a document that helps to change the db_name and not the instance_name, understand.. so ... I thought to create the new one, with the new name and migrate to it and after it to change the name to the old one... Like that, i shouldn't change the application . But i hope that the best way is : Deinstall and install the new version. And to migrate it fully. Right ? Regards Eriovaldo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 06, 2002 11:53 AM Eriovaldo - Often the lot of a DBA is to balance value and risk. Here, you must ask yourself - what is the value of retaining the same instance name, and what are the risks to my production environment? If you perceive the value to be high and the risks low, then go for it. But often (especially after you've been stung a few times) it seems that the value wasn't so great after all. How long can you have your production site down? What happens if something goes wrong and you have them down quite a bit longer than you estimated? You can lower the risk to your production site by creating the new instance (different name), and getting it all prepared before you take the production site down for the export. If most of your users access the instance via SQL*Net (Net8), you can put an alias there, so they don't have to change a thing. Of course, if your boss says do it or else, then the value/risk equation changes dramatically. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, May 05, 2002 5:18 AM To: Multiple recipients of list ORACLE-L Actualy, I am confused, because this is my production environment and I need to get sucess in this operation. It is necessary, and i would like to keep the old name of instance, because i will change the BD version. I think the best way is : 1.) backup the software and datafiles 2.) Export all the database 3.) Deinstanll the old software 4.) Install the new version 5.) Create the instance with the old name 6.) Import the database but it will take a while. I am looking for a fast way , Understand ? Thanks Regards Eriovaldo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, May 04, 2002 8:03 PM Its actually the easiest part. However, I don't want to miss a step so you best running off to Metalink. They actually have a note out there on how to do it. Not quite up to date for 9i but close. You need to shutdown your database, change your oracle sid, rename your init, if using an i version change the instance name and if desired the service name. Hum, me thinks that's it. I may be missing something though. I feel like I am missing something. However, the moral of the story is that its quite easy and I have done it a couple of times. You need to make a decision on what to do with your directories structures if you are using the $ORACLE_BASE/admin/sid structure. There is no technical reason to change it except for your own sanity. -Original Message- Andrietta Sent: Saturday, May 04, 2002 12:23 PM To: Multiple recipients of list ORACLE-L Friends : I need to change the instance name. For example it is : DEVELOP and I need to put DEVELOPER. I know how to change the database name , but not the instance name .. Any idea ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
Re: Re[2]: change a database connection in a stored procedure?
Hi Kranti, First of all, think about what you wanna do. This looks like logical mistake if you need session change in PL/SQL. When you change the session, what happens with the first one? Session is establised by client requesting the server, so you can only do it from client. If you just want to perform some action as other user, then you may run procedure from that user scheme declared with AUTHID DEFINER (which is by default). Another solution may be creating database link to itself as another user but that doesn't make much sense. Note that you will make new session with database link from server (as client) to itself as server. Alexandre Gorbatchev Oracle DBA/Developer, OCP [EMAIL PROTECTED] +49 (0) 540 / 550 5177 Avermann Maschinenfabrik GmbH Co. KG http://www.avermann.de - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 10:08 AM Hello kranti, I made a mistake. You can't change your database connection at all from stored procedure (there is no such SQL command connect it's a sqlplus directive). When I gave the answer I thought about database link. You can drop and create it using dynamic SQL. Tuesday, May 07, 2002, 2:08:27 PM, you wrote: kp Hi Sergey, kp I am using dynamic SQL but it is returing error for connect statement. Can u kp give me some example code. kp Rgds kp Kranti kp -Original Message- kp Sent: Tuesday, May 07, 2002 7:38 AM kp To: Multiple recipients of list ORACLE-L kp Hello kranti, kp Use dynamic SQL. kp Monday, May 06, 2002, 8:23:29 PM, you wrote: kp Hi List, kp Can someone tell me is it possible to change a database kp connection kp in a stored procedure? if so how? kp TIA kp Kranti -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Good DBA vs. Bad DBA
Any replies? :-) -Original Message- Sent: Monday, May 06, 2002 10:58 PM To: Multiple recipients of list ORACLE-L Subject:RE: Good DBA vs. Bad DBA Dare I ask... do you have a Good Manager vs. Bad Manager list? ;o) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, May 06, 2002 4:14 PM To: Multiple recipients of list ORACLE-L I posted my list of Good DBA vs. Bad DBA on the DBA Pipeline (www.revealnet.com), and it was suggested I share it here, which I am doing comments most welcome. (If you saw this list on Revealnet, I've made some minor adjustments...) Roberts Rules of Good DBA vs. Bad DBA Good DBA - Proactive Bad DBA - Reactive Good DBA - Knows how to RTFM Bad DBA - Has never cracked the FM Good DBA - Analyzes and comments Bad DBA - Just comments Good DBA - Not always right and admits it Bad DBA - Rarely right and denies it. Good DBA - Never Ever Ever content Bad DBA - More worried about his retirement in 2011 than Oracle RDBMS version 11. Good DBA - Considers, plans and executes Bad DBA - executes and hopes he can recover, after the failure. Good DBA - Knows how to listen, is intuitive and offers value. Bad DBA - Jumps in, Shares all he knows and offers nothing of value. Good DBA - Is SURE he is right before he acts, but is not afraid to call support if he has the least little doubt (or if it's a major problem). Bad DBA - Thinks he has to act and doesn't want to call support for fear of being labeled bad dba. Good DBA - Asks questions before doing Bad DBA - Does and asks questions only if the doing doesn't do it. Good DBA - Knows the answer or how to find it (e.g. Coming here and asking the question). Bad DBA - Knows where the good DBA is at all times, because the good DBA will know the answer and it's easier than figuring it out himself. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Taylor, Shirley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Good DBA vs. Bad DBA
Not yet, but all the California people are still sleeping. Mike is back, I told him that we have to report to helpdesk every morning. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 07, 2002 8:28 AM To: Multiple recipients of list ORACLE-L Any replies? :-) -Original Message- Sent: Monday, May 06, 2002 10:58 PM To: Multiple recipients of list ORACLE-L Subject:RE: Good DBA vs. Bad DBA Dare I ask... do you have a Good Manager vs. Bad Manager list? ;o) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, May 06, 2002 4:14 PM To: Multiple recipients of list ORACLE-L I posted my list of Good DBA vs. Bad DBA on the DBA Pipeline (www.revealnet.com), and it was suggested I share it here, which I am doing comments most welcome. (If you saw this list on Revealnet, I've made some minor adjustments...) Roberts Rules of Good DBA vs. Bad DBA Good DBA - Proactive Bad DBA - Reactive Good DBA - Knows how to RTFM Bad DBA - Has never cracked the FM Good DBA - Analyzes and comments Bad DBA - Just comments Good DBA - Not always right and admits it Bad DBA - Rarely right and denies it. Good DBA - Never Ever Ever content Bad DBA - More worried about his retirement in 2011 than Oracle RDBMS version 11. Good DBA - Considers, plans and executes Bad DBA - executes and hopes he can recover, after the failure. Good DBA - Knows how to listen, is intuitive and offers value. Bad DBA - Jumps in, Shares all he knows and offers nothing of value. Good DBA - Is SURE he is right before he acts, but is not afraid to call support if he has the least little doubt (or if it's a major problem). Bad DBA - Thinks he has to act and doesn't want to call support for fear of being labeled bad dba. Good DBA - Asks questions before doing Bad DBA - Does and asks questions only if the doing doesn't do it. Good DBA - Knows the answer or how to find it (e.g. Coming here and asking the question). Bad DBA - Knows where the good DBA is at all times, because the good DBA will know the answer and it's easier than figuring it out himself. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Taylor, Shirley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: ERD generation tool - Active SCM
I thought that there was a way via schema level triggers? I vaguely remember discussion on this last year -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Kimberly Smith [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: ERD generation tool - Active SCM Hey, how do you give that truncate only privilege -- 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).
{9i New Features: V$SQL_PLAN}
Welcome to the next installment of 9i new features(and yes when 9iR2 is released, we'll start this series all over again, woohoo) In the mean time, here is the scoop on v$sql_plan view. This view provides a way of examining the execution plan for cursors that were recently executed. The view has about the same info as the output of an explain plan and this is intentional, the big difference is output from an explainis in theory what would happen but this view contains the actual plan as to what happened. So is this of any use, probably, think about this, you can now see the plan that was executed. This has some really kewl uses for thoseof us who are still not up to speed in the whole "wait state" tuning concept(which yours truly is included). This help you see that bad code in the database. So of the columns in this view, which one are most useful Address and hash_value join to v$sqlarea.Address,hash_value and child_number join to v$sqlAddress and hash_value join to v$sqltext Most of the rest of the columns are what you'd find in a normal plan table. There's not much else to say about this v$ view, except if nothing else, I've finally now know which columns to join on on those v$sql* views. Like always, send hate mail to /dev/null, all others to [EMAIL PROTECTED]. Joe PS: anyone have any special requests that they'd like to know about but don't have the time, let me know.
Re: Datawarehousing help
[EMAIL PROTECTED] wrote: I was hoping she would figure out the DW hard stuff, then write the book explaining everything with lots of big, colorful pictures...(big grin). If I were to write the book, and she be the tech editor, then she would drive down to Philly and kick myand shove the already burning manuscript down my throat. no, she would gently and emphatically point out your mistakes and suggest corrections to be made RIGHT NOW!;-) i haven't had a chance to do any DW stuff, just the data cleaning that goes before it. and that's a project in and of itself.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Never violate the Prime Directory! C:\ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: change a database connection in a stored procedure?
hi! i don't quite understand the problem, but it seems that while running a script you want to build a second connection you can do this if you build the connection with HOST SQLPLUS xxx/yyy@zzz with the first EXIT you disconnect from connection 2 and with the second one from connection 1 bye daniel kranti pushkarna wrote: Hi Sergey, I am using dynamic SQL but it is returing error for connect statement. Can u give me some example code. Rgds Kranti -Original Message- Sent: Tuesday, May 07, 2002 7:38 AM To: Multiple recipients of list ORACLE-L Hello kranti, Use dynamic SQL. Monday, May 06, 2002, 8:23:29 PM, you wrote: kp Hi List, kp Can someone tell me is it possible to change a database connection kp in a stored procedure? if so how? kp TIA kp Kranti -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: kranti pushkarna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Daniel Wisser, Mag. ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Datawarehousing help
Hello Rachel I am working with SAS on the mainframe (os390) and it works fine. We published a RFP for ETL tool and they are one of the candidates. Their tool looks good on paper but we are still evaluating papers and do not have hands on experience. We do have a SAS/oracle application on NT but I was not involved in the programming side. I checked with the programmer and he told me that in the little testing he did ( system still in test) SAS worked quickly and nicely with oracle, including graphs. SAS has a nice graph generating option. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 06, 2002 4:13 PM Yechiel, have you used their tools? We are trying to decide whether or not to use them, so if anyone has had recent experience with them, I'd appreciate your thoughts on ease of use, understandability, quality of the product, etc Thanks Rachel |+--- || | || | || adaryechiel@h| || otmail.com | || | || 05/05/2002 | || 07:23 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Datawarehousing help| | Hello Dennis SAS has progressed a little in the last years and now offer a complete DW solution, including ETL tools. You can use their tools also to populate and query oracle. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, May 04, 2002 2:48 AM Rachel - I always find it helpful to understand something if I know the origins. I worked with SAS several years ago. At that time it was a statistical analysis package. A scientist or engineer could load a set of test data into it and perform various arithmetic and statistical analyses. Today most of that can be done with Oracle or MS Excel. My point is that I would expect it to be heavily biased toward mathematical capabilities. Like Data Mining, which is all statistics. Learn what that term means. To learn Data Warehousing, I would encourage you to just do some Googling and find good tutorials. An excellent newslist is dwlist. Instructions: For help with list commands, send a message to mailto:[EMAIL PROTECTED] with the word help in the body of the message. The magazine http://www.intelligententerprise.com/ has some excellent information. I would search for Ralph Kimball. He is one of the leading figures in the DW arena. Look for some of his earliest columns on the magazine site. He also answers questions on dwlist from time to time. The main change you need yourself is to forget normalization. DBAs that can't get past that point don't last long in the DW field. In the early days the DW people would patiently explain the reasons to a DBA, but today there are enough DBAs that have made the leap that a hard-headed normalization bigot just isn't tolerated. It is much easier to just ask for a replacement DBA. The reason normalization isn't adhered to in DW is that users will be creating their own queries and they can't understand 10-table joins with outer joins, etc. A DW is usually loaded and then queried. Our DW is loaded each weekend and then queried all week. So a DW is deliberately denormalized and contains redundant data for ease of use. OLTP databases have no concept of time. A DW is all about time. To reconstruct what the situation is at various points of time, the DW has loads of historical data. For example, marketing people need to be able to reconstruct the amount of business they did with a customer over a period of time last year and compare it with the same period this year. So between denormalization and tons of detailed historical data, DWs are normally BIG! Fortunately they are usually read-only. For Oracle, you want Enterprise Edition with the partitioning option. And study Oracle Materialized Views. In schema, a DW is usually a central fact table and 4-6 dimension tables. Less than 4 dimensions and you don't need a DW. More than 6 and marketing people can't understand the model. Normally the fact table is much larger than the others, but not always. One of Wal-Mart's dimension tables is each person in the U.S. Just size each of those tables, and you've got your size. Growth is easy to predict. Ralph Kimball warns that often
Re: 9i Automatic UNDO bugs
I know Joe Testa blew up his DB with it... it was in the initial release and was supposedly fixed in the patchsets |+--- || | || | || optimaldba@ya| || hoo.com | || | || 05/06/2002 | || 05:57 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: 9i Automatic UNDO bugs | | I have heard of 9i AMU bugs that cause database outages, but nothing shows up on metalink. Does anyone have any direct experience with 9i AMU causing database corruption and loss? If so, what platform was this on and what bug was identified as the culprit? Daniel W. Fink __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Datawarehousing help
I worked on a project with an Oracle 7.3.4 database and a SAS OLAP tool. SAS built a datacube using the Oracle database but then the OLAP queries went against the datacube. It worked but we had some very knowledgeable SAS users. Yechiel Adar adaryechiel To: Multiple recipients of list ORACLE-L @hotmail.com[EMAIL PROTECTED] Sent by: rootcc: Subject: Re: Datawarehousing help 05/07/2002 08:58 AM Please respond to ORACLE-L Hello Rachel I am working with SAS on the mainframe (os390) and it works fine. We published a RFP for ETL tool and they are one of the candidates. Their tool looks good on paper but we are still evaluating papers and do not have hands on experience. We do have a SAS/oracle application on NT but I was not involved in the programming side. I checked with the programmer and he told me that in the little testing he did ( system still in test) SAS worked quickly and nicely with oracle, including graphs. SAS has a nice graph generating option. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 06, 2002 4:13 PM Yechiel, have you used their tools? We are trying to decide whether or not to use them, so if anyone has had recent experience with them, I'd appreciate your thoughts on ease of use, understandability, quality of the product, etc Thanks Rachel |+--- || | || | || adaryechiel@h| || otmail.com | || | || 05/05/2002 | || 07:23 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Datawarehousing help| | Hello Dennis SAS has progressed a little in the last years and now offer a complete DW solution, including ETL tools. You can use their tools also to populate and query oracle. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, May 04, 2002 2:48 AM Rachel - I always find it helpful to understand something if I know the origins. I worked with SAS several years ago. At that time it was a statistical analysis package. A scientist or engineer could load a set of test data into it and perform various arithmetic and statistical analyses. Today most of that can be done with Oracle or MS Excel. My point is that I would expect it to be heavily biased toward mathematical capabilities. Like Data Mining, which is all statistics. Learn what that term means. To learn Data Warehousing, I would encourage you to just do some Googling and find good tutorials. An excellent newslist is dwlist. Instructions: For help with list commands, send a message to mailto:[EMAIL PROTECTED] with the word help in the body of the message. The magazine http://www.intelligententerprise.com/ has some excellent information. I would search for Ralph Kimball. He is one of the leading figures in the DW arena. Look for some of his earliest columns on the magazine site. He also answers questions on dwlist from time to time. The main change you need yourself is to forget normalization. DBAs that can't get past that point don't last long in the DW field. In the early days the DW people would patiently explain the reasons to a DBA, but today there are enough DBAs that have made the
RE: Datawarehousing help
won't be me... why don't YOU write one and then talk to me about the joys of authorship (says the woman going blind looking a page proofs that are totally messed up) |+--- || | || | || cgrabowy@fcg.| || com | || | || 05/06/2002 | || 06:13 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | Someone's got to pick up Marlene's slack... -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 5:44 PM To: Multiple recipients of list ORACLE-L nuh uh, for two reasons, the first and foremost being, there already IS one the second is that I have no plans to write any new books |+--- || | || | || cgrabowy@fcg.| || com | || | || 05/06/2002 | || 04:55 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | Cool!! Here comes Oracle Data Warehousing 101... -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Right now I'm collecting information.. I don't KNOW what this will be.. other than a learning experience of course. That which does not kill us makes us strong, right? rachel, anticipating great strength |+--- || | || | || Jared.Still@r| || adisys.com | || | || 05/06/2002 | || 02:23 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | A DW is not simply a collection of data marts. A DW may be a true 'warehouse' of enterprise data from which DM may be built. Extracts go to the DW, DW is used to build DM. A DW may in fact very much resemble an OLTP database, with a temporal component thrown in to track changes to data over time. Users are not (generally) allowed acces to the DW. This is a full blown DW architecture though, and you may only wish to start with some DM to get your feet wet, or maybe that's all that is actually needed. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/06/2002 06:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Datawarehousing help Dennis, Forgetting about normalization won't be a problem, I've always been more practical than by the book. As for amounts of data being collected, I can see them wanting data aggregated hourly. I greatly doubt the tech people will allow adhoc queries, they seem to do things right here. What will happen is that they will be contacted by marketing with an I need this new report NOW request, but tech will generate it. But *my* problem is that the data warehouse will supposedly be only a small part of what I'm responsible for, I don't think they understand the scope of what they are asking for, as yet. They will, I'll make sure of it. Right now, as this is a new internal group, I'm still collecting information on which databases I will be responsible for. Then I just have to remember that when I set deadliines, I am prone to underestimation. :) Rachel |+--- || | || | |
Re: OT: 8i OCP questions
Hi Rick, There is currently no announced date to retire the Oracle8i OCP test. When announced they typically give approximately one year before retirement. What do you mean by time allowed between tests. John [EMAIL PROTECTED] wrote: Hi, I cannot find any info on Oracle web site concerning time allowed between test and plans to retire 8i OCP. Does anyone know or have any links that may state if there is a time limit betweeen test and whether Oracle has plans to retire 8i certification. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Good DBA vs. Bad DBA
[EMAIL PROTECTED] wrote: Dare I ask... do you have a Good Manager vs. Bad Manager list? you mean there is such a thing as a good manager? why don't people tell me these things?;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Never violate the Prime Directory! C:\ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9iR2 Relase date
http://www.infoworld.com/articles/hn/xml/02/01/31/020131hnoradb.xml Kevin Toepke [EMAIL PROTECTED] The information in this electronic mail message is Trilegiant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Trilegiant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Datawarehousing help
you people are soo funny. Writing a book takes time, hard work and more energy than I care to commit to the project.. especially on a subject with which I have zero experience |+--- || | || | || ksmith2@myfir| || stlink.net | || | || 05/06/2002 | || 10:38 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | Oh, good idea! When's it being published Rachel? -Original Message- Chris Sent: Monday, May 06, 2002 1:55 PM To: Multiple recipients of list ORACLE-L Cool!! Here comes Oracle Data Warehousing 101... -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Right now I'm collecting information.. I don't KNOW what this will be.. other than a learning experience of course. That which does not kill us makes us strong, right? rachel, anticipating great strength |+--- || | || | || Jared.Still@r| || adisys.com | || | || 05/06/2002 | || 02:23 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | A DW is not simply a collection of data marts. A DW may be a true 'warehouse' of enterprise data from which DM may be built. Extracts go to the DW, DW is used to build DM. A DW may in fact very much resemble an OLTP database, with a temporal component thrown in to track changes to data over time. Users are not (generally) allowed acces to the DW. This is a full blown DW architecture though, and you may only wish to start with some DM to get your feet wet, or maybe that's all that is actually needed. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/06/2002 06:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Datawarehousing help Dennis, Forgetting about normalization won't be a problem, I've always been more practical than by the book. As for amounts of data being collected, I can see them wanting data aggregated hourly. I greatly doubt the tech people will allow adhoc queries, they seem to do things right here. What will happen is that they will be contacted by marketing with an I need this new report NOW request, but tech will generate it. But *my* problem is that the data warehouse will supposedly be only a small part of what I'm responsible for, I don't think they understand the scope of what they are asking for, as yet. They will, I'll make sure of it. Right now, as this is a new internal group, I'm still collecting information on which databases I will be responsible for. Then I just have to remember that when I set deadliines, I am prone to underestimation. :) Rachel |+--- || | || | || DWILLIAMS@lif| || etouch.com | || | || 05/03/2002 | || 08:48 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | Rachel - I always find it helpful to understand something if I know the origins. I worked with SAS several years ago. At that time it was a statistical analysis package. A scientist or engineer could load a set of test data into it and perform
Logs of SQL
Higurus! Where does the logs of sql get stored? In my case i have one Dll file , i call the standard function which are being exposed by the Dll . Those function must be firing SQl. i want to See those SQls. Thanx in advance... Shishir Kumar MishraAgni Software (P) Ltd.www.agnisoft.com--Vidya Dadaati Viniyam--
RE: Erwin - Does this thing work?
In our case, we had to add the following: In Windows settings, control panel, system, advanced, environment variables, add: Variable = NLS_LANG Value = American_America.UTF8 Rich -Original Message- Sent: Monday, May 06, 2002 10:28 PM To: Multiple recipients of list ORACLE-L There is a way around that pesky FK problem. Unfortunately we are using it... No FK's. And they wonder why they have data problems... -Original Message- [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Hi Lisa, Yes. But its a little convoluted. It took me quite some time to do it. Depends what you want included. IE. storage paramters etc. This is the product I use to generate all of our models and YES, it drives me nuts. They had a bug in the last version that didn't allow the FK constraints ddl to be generated properly! I am still having alot of issues with it but it has the company's STAMP OF APPROVAL, so its what I need to use sigh. Anyway, I use the OPTIONs under Forward Engineer and Created Several Templates (forget what THEY call'em). First I generate scripts for the tables with named PKs. Then the named FKs, then finally the indexes. THis way I can review them in a reasonable way instead of just spewing them all out there. Feel free to shoot me any specific questions. Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Koivu, Lisa [EMAIL PROTECTED] Sent: Monday, May 06, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Subject: OT: Erwin - Does this thing work? Hello all, I spent the weekend screwing around with Erwin. What a waste. I could not believe how poorly it generated DDL. Has anyone gotten this product to generate DDL in a readable, logical manner? I am using Version 4.0, SP1 Lisa Koivu Oracle Database Big Baby Oven Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ERD generation tool - Active SCM
Hello Kieth you wrote: It would have been better to give your developer truncate only privileges, You mean: grant truncate on owner.table to user. No such grant. The closest I could find is: Create procedure that truncate the table as the owner and grant execute on the procedure to the user. Any better ideas? BTW - I did not wrote that he dropped the tables using some developing tool called magic because he forgot to switch back to the regular user after the truncate. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 06, 2002 5:53 PM this is exactly my point. It would have been better to give your developer truncate only privileges, and that too only on a few tables... but NEVER the Oracle schema owner password! NEVER. But, you too gave it away! you too Brutus! Even though you are quite averse to doing so. Think about it, this happens everyday. Whether you like it or not, you have MASTER, TEST, PRODUCTION, DEVELOPMENT, STAGING... instances, and your schema passwords are floating around, and you have no control. And, you promise that you will never give the schema password out ever again, but you know you will... you will be forced to... your director will make you... and if you fight it any win, your developer productivity will be seriously compromised. You need to have a means of giving the schema access without giving away the full house. And the solution is NOT via a read-only user. A read-only user is useless. You cannot do any serious work in a read only user. Been there done that. Giving Oracle privileges, to users, as a case-by-case request, is IMPOSSIBLE for you to manage, UNREASONABLE and NOT FEASIBLE. Anyway, NEVER give the ORACLE PASSWORD away. Only encrypted access. And, let Dom Phoc work right in the owner schema. There will be no problem, if you can GUARANTEE limited access, full audits on everything Dom does via this access, including select statements. Dom Phoc will not be viewing the Salaries, and Credit Card numbers now... not if its being audited. At the expense of sounding like a sales person, let me point this out again for the benefit of the group: And, you certainly need to look at it: http://www.iraje.com/docs/ActiveSecureDesigner.htm I will find forward you some more info. Keith Date: Sun, 05 May 2002 03:48:18 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Well , just to keep things jumping. Last week I deviated from our rule and gave a responsible user that needed truncate on tables the password for the owner of the schema. Guess what? Today he comes to me to recreate 2 tables that he dropped. Go figure. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 03, 2002 5:53 PM Yechiel, Yes, I have been there, done that, over and over... But then, there is a Toyota Corolla solution and maybe a Ferrari Testarosa solution. If we can control Dom Phoc without tieing his hands behind the back, wouldn't that would be the best: white paper: http://www.iraje.com/docs/ActiveSecureDesigner.htm Keith Date: Thu, 02 May 2002 11:48:38 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Well Keith Our solution to the Doom Phoc (and their siblings) is: Do not grant they rights to do any DDL either in test nor in prod. The dab stuff does all the DDL work. Sure it is an added chore, but after tracking down, a few times, tables that were dropped inadvertently by users (their tool did it by itself) we now use the following policy: Every application has two user id's: Owner, with password known only to the DBA group. User with rights for select, insert, update, delete ONLY. It works. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 7:54 PM Lisa, There is only so much you can control via a model, since it remains a process away from the DB, and cannot be enforced via privileges, etc. So, we are always in the hands of Dom Phoc (and their siblings), who can do stuff even in the production database with SQLPLus/TOAD/... Under this schenario, do you sleep well at night? So, we said lets work with our Dom Phoc's. On production databases, we will STRIP them off of the Oracle database passwords. No password, no change. ENFORCED! Now, I can sleep well at night. How? Not via models. Via a solution involving the following, and it seems to be working for us well:
recovery keeps wanting logs
Recently installed a W2k server on a SAN. Using backupexec for W2K. Initial test worked great. This week one final test before moving a production database to it. Backed up the database. Restored the database. Launched recovery, it requested the log from during the backup and then wanted more! - there is no more. Today did a test to see if it is Veritas. - put back saved disk copy of the database- started the database- manually set system, psrbs and pstemp to backup mode- ran ocopy to do the backup- set tablespaces to end backup mode- switched logfile- shutdown database- renamed directory to save- renamed the directory containing the 3 copied tablespaces to "f:\htst"- started the service- recreated the controlfile containing only these 3 tablespaces- did recover until cancel- did the log switched to and then cancelled recovery- alter database open says system needs more logs!!! Therefore, not Veritas problem. Any help appreciated. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: I need to change the instance name (to Dennis)
Right BUT: make sure you do not use any option that does not exist in the standard edition but existed in the enterprise edition. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 12:18 PM Dennis : Thanks for your answer. Well, I need to downgrade my database, changing EE for SE, so ... The most problem is that the v$instance is used in the aplication. I saw in the metalink a document that helps to change the db_name and not the instance_name, understand.. so ... I thought to create the new one, with the new name and migrate to it and after it to change the name to the old one... Like that, i shouldn't change the application . But i hope that the best way is : Deinstall and install the new version. And to migrate it fully. Right ? Regards Eriovaldo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 06, 2002 11:53 AM Eriovaldo - Often the lot of a DBA is to balance value and risk. Here, you must ask yourself - what is the value of retaining the same instance name, and what are the risks to my production environment? If you perceive the value to be high and the risks low, then go for it. But often (especially after you've been stung a few times) it seems that the value wasn't so great after all. How long can you have your production site down? What happens if something goes wrong and you have them down quite a bit longer than you estimated? You can lower the risk to your production site by creating the new instance (different name), and getting it all prepared before you take the production site down for the export. If most of your users access the instance via SQL*Net (Net8), you can put an alias there, so they don't have to change a thing. Of course, if your boss says do it or else, then the value/risk equation changes dramatically. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, May 05, 2002 5:18 AM To: Multiple recipients of list ORACLE-L Actualy, I am confused, because this is my production environment and I need to get sucess in this operation. It is necessary, and i would like to keep the old name of instance, because i will change the BD version. I think the best way is : 1.) backup the software and datafiles 2.) Export all the database 3.) Deinstanll the old software 4.) Install the new version 5.) Create the instance with the old name 6.) Import the database but it will take a while. I am looking for a fast way , Understand ? Thanks Regards Eriovaldo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, May 04, 2002 8:03 PM Its actually the easiest part. However, I don't want to miss a step so you best running off to Metalink. They actually have a note out there on how to do it. Not quite up to date for 9i but close. You need to shutdown your database, change your oracle sid, rename your init, if using an i version change the instance name and if desired the service name. Hum, me thinks that's it. I may be missing something though. I feel like I am missing something. However, the moral of the story is that its quite easy and I have done it a couple of times. You need to make a decision on what to do with your directories structures if you are using the $ORACLE_BASE/admin/sid structure. There is no technical reason to change it except for your own sanity. -Original Message- Andrietta Sent: Saturday, May 04, 2002 12:23 PM To: Multiple recipients of list ORACLE-L Friends : I need to change the instance name. For example it is : DEVELOP and I need to put DEVELOPER. I know how to change the database name , but not the instance name .. Any idea ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
Password Checking
All: I am looking for an algorithm that will verify that a pasword meets minimum requirements (like 8 chars, mix of chars nbrs, != username, etc), but am just feeling too darn lazy to write one myself. Can anyone on the list help me out by pointing me to a good one? Thanks Kevin Toepke [EMAIL PROTECTED] The information in this electronic mail message is Trilegiant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Trilegiant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.7.3 - Good or Bad?
Vivek, Although there is not much more information, here is the complete message from April 17th, 2002: ** Jack: First of all, there are some serious problems with 8.1.7.3 that can cause database crashes and corruption. One bug (may be solaris specific) can crash the box. I would highly recommend that you only upgrade to 8.1.7.2 unless absolutely necessary. We have downgraded all of our 8.1.7.3 databases to 8.1.7.2 (a *very* painful experience) That said, I never had trouble upgrading directly to 8.1.7.2 directly from 8.1.5.x or 8.1.6.x. We have done in development, staging and production without any adverse effects. I don't think I've ever done a 8.0.5 to 8.1.7 directly. Kevin -Original Message- Sent: Wednesday, April 17, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Hi All, we are in the process of upgrading to 8.1.7.3 some of our databases (now 8.0.5) According to the Doc's thsi has to be done in two steps Upgrade to 8.1.7.0.0 followed by and upgrade to 8.1.7.3.0. This means that we have to upgrade all our databases in one go, or install another base 8.1.7 install to do some databases later. On our test system however we have upgraded directly form 8.0.5 and all seems to be fine. Anybody care to comment/share their opinions/experiences TIA Jack ** Can anyone else confirm Kevin's claims about 8.1.7.3??? Alan VIVEK_SHARMA VIVEK_SHARMA@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] infy.comcc: Sent by: Subject: RE: 8.1.7.3 - Good or Bad? [EMAIL PROTECTED] om 05/07/02 02:38 AM Please respond to ORACLE-L Bugs in 8.1.7.3 that Can Crash the Box ? What Bug Number is that ? Can you Alternately post Kevin Toepke E-mail OR Specify the Date of His posting ? -Original Message- Sent: Tuesday, May 07, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Oracle Gurus, I seem to be running into memory leaks on an 8.1.7.0 database on Solaris 8. After searching metalink and reading some patch release notes, it looks like we might be having problems with the XML parser and/or LOBs. We are thinking of upgrading to 8.1.7.3, but I am a little leery after Kevin Toepke posted this message a few weeks ago: First of all, there are some serious problems with 8.1.7.3 that can cause database crashes and corruption. One bug (may be solaris specific) can crash the box. I would highly recommend that you only upgrade to 8.1.7.2 unless absolutely necessary. We have downgraded all of our 8.1.7.3 databases to 8.1.7.2 (a *very* painful experience) ... Kevin makes it sound like a terrible patch. What do all of you think that have gone to 8.1.7.3? Was it worth it? Anyone using LOBs and/or XML utilites with this release? Thanks, Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or
PK - Character vs. Numeric
I'm sure this has been raised in the past, but... Is it better, in terms of performance, to use numeric primary keys versus character/string keys? It is my understanding that this is really a space-savings issue rather than a performance issue. Can someone elaborate more on this? Thanks. -W -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: change a database connection in a stored procedure?
Hi Alexandre, I am writing a procedure to create a user, grant privilleges to the user nad then connect as that user and create schema in that user. I want this whole process to be automated. That is why I want to change a database connection. Anyway I have done it using batch file. Thanks for your response Rgds Kranti -Original Message- Sent: Tuesday, May 07, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Hi Kranti, First of all, think about what you wanna do. This looks like logical mistake if you need session change in PL/SQL. When you change the session, what happens with the first one? Session is establised by client requesting the server, so you can only do it from client. If you just want to perform some action as other user, then you may run procedure from that user scheme declared with AUTHID DEFINER (which is by default). Another solution may be creating database link to itself as another user but that doesn't make much sense. Note that you will make new session with database link from server (as client) to itself as server. Alexandre Gorbatchev Oracle DBA/Developer, OCP [EMAIL PROTECTED] +49 (0) 540 / 550 5177 Avermann Maschinenfabrik GmbH Co. KG http://www.avermann.de - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 10:08 AM Hello kranti, I made a mistake. You can't change your database connection at all from stored procedure (there is no such SQL command connect it's a sqlplus directive). When I gave the answer I thought about database link. You can drop and create it using dynamic SQL. Tuesday, May 07, 2002, 2:08:27 PM, you wrote: kp Hi Sergey, kp I am using dynamic SQL but it is returing error for connect statement. Can u kp give me some example code. kp Rgds kp Kranti kp -Original Message- kp Sent: Tuesday, May 07, 2002 7:38 AM kp To: Multiple recipients of list ORACLE-L kp Hello kranti, kp Use dynamic SQL. kp Monday, May 06, 2002, 8:23:29 PM, you wrote: kp Hi List, kp Can someone tell me is it possible to change a database kp connection kp in a stored procedure? if so how? kp TIA kp Kranti -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: kranti pushkarna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Datawarehousing help
Come on, Rachel! Zero Experence has never stopped anyone from publishing. Just look at academia and MCSE study guides... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 8:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: Datawarehousing help you people are soo funny. Writing a book takes time, hard work and more energy than I care to commit to the project.. especially on a subject with which I have zero experience -- 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).
Online redo sizing and parameters
I'm looking to resize our online redo logs for a particular app and am somewhat confused about the appropriate settings. The current config is 4 groups (2 members each) of 5Mb size. We cycle through a daily average of 750 logs in a 22 hour period. During a more intensize daily batch window of 5 hours there is an average of 100 per hour switches i.e. two thirds of switches are occuring during the batch window. I'm planning to resize the online redo logs to 120Mb based upon rationale of 500Mb per hour in batch window and 4 groups. So switching will happen apporox every 15 minutes. Some Oracle documentation suggests 1 switch per hour is best and others one switch every 30 minutes. So question 1: Does this proposed resize make sense? Our current log_checkpoint_interval = 10,000 which means a checkpoint at approx 39Mb given it's a Win 2k OS with it's OS block size of 4096. So question 2: Does it make sense to leave this setting as is and have approx 3 checkpoints per each redo (timewise every 5 minutes) or is there a better value and why? (Support suggested setting to zero, i.e. effectively ignore!). The log_checkpoint_timeout is currently 1800. Support suggested setting this to zero but the reference manual suggests that this should not be done!. So final question: What would the best value be given the log_checkpoint_interval would probably have a checkpoint every 5 minutes using heavy processing?. Your considered opinions/input re above would be much appreciated. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 New Features: V$SQL_PLAN}
Kewl! Oracle has finally grasped the concept of a slow query log. Glad to see Oracle is at least trying to catch up to MySQL. --Walt Weaver Bozeman, Montana -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 07, 2002 7:48 AMTo: Multiple recipients of list ORACLE-LSubject: {9i New Features: V$SQL_PLAN} Welcome to the next installment of 9i new features(and yes when 9iR2 is released, we'll start this series all over again, woohoo) In the mean time, here is the scoop on v$sql_plan view. This view provides a way of examining the execution plan for cursors that were recently executed. The view has about the same info as the output of an explain plan and this is intentional, the big difference is output from an explainis in theory what would happen but this view contains the actual plan as to what happened. So is this of any use, probably, think about this, you can now see the plan that was executed. This has some really kewl uses for thoseof us who are still not up to speed in the whole "wait state" tuning concept(which yours truly is included). This help you see that bad code in the database. So of the columns in this view, which one are most useful Address and hash_value join to v$sqlarea.Address,hash_value and child_number join to v$sqlAddress and hash_value join to v$sqltext Most of the rest of the columns are what you'd find in a normal plan table. There's not much else to say about this v$ view, except if nothing else, I've finally now know which columns to join on on those v$sql* views. Like always, send hate mail to /dev/null, all others to [EMAIL PROTECTED]. Joe PS: anyone have any special requests that they'd like to know about but don't have the time, let me know.
RE: Erwin - Does this thing work?
I am also using ERWin reluctantly. What exactly is the FK problem you mentioned? I am using v.4.0. Erik -Original Message- From: Kimberly Smith [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: Erwin - Does this thing work? There is a way around that pesky FK problem. Unfortunately we are using it... No FK's. And they wonder why they have data problems... -Original Message- [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Hi Lisa, Yes. But its a little convoluted. It took me quite some time to do it. Depends what you want included. IE. storage paramters etc. This is the product I use to generate all of our models and YES, it drives me nuts. They had a bug in the last version that didn't allow the FK constraints ddl to be generated properly! I am still having alot of issues with it but it has the company's STAMP OF APPROVAL, so its what I need to use sigh. Anyway, I use the OPTIONs under Forward Engineer and Created Several Templates (forget what THEY call'em). First I generate scripts for the tables with named PKs. Then the named FKs, then finally the indexes. THis way I can review them in a reasonable way instead of just spewing them all out there. Feel free to shoot me any specific questions. Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Koivu, Lisa [EMAIL PROTECTED] Sent: Monday, May 06, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Subject:OT: Erwin - Does this thing work? Hello all, I spent the weekend screwing around with Erwin. What a waste. I could not believe how poorly it generated DDL. Has anyone gotten this product to generate DDL in a readable, logical manner? I am using Version 4.0, SP1 Lisa Koivu Oracle Database Big Baby Oven Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Datawarehousing help
nuh uh, for two reasons, the first and foremost being, I was paying attention when you spoke about the joys of authorship. the second is that I was paying attention when you spoke about the joys of authorship... .. . .. ... .. .. .. . -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 9:09 AM To: Multiple recipients of list ORACLE-L won't be me... why don't YOU write one and then talk to me about the joys of authorship (says the woman going blind looking a page proofs that are totally messed up) |+--- || | || | || cgrabowy@fcg.| || com | || | || 05/06/2002 | || 06:13 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | Someone's got to pick up Marlene's slack... -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 5:44 PM To: Multiple recipients of list ORACLE-L nuh uh, for two reasons, the first and foremost being, there already IS one the second is that I have no plans to write any new books |+--- || | || | || cgrabowy@fcg.| || com | || | || 05/06/2002 | || 04:55 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | Cool!! Here comes Oracle Data Warehousing 101... -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Right now I'm collecting information.. I don't KNOW what this will be.. other than a learning experience of course. That which does not kill us makes us strong, right? rachel, anticipating great strength |+--- || | || | || Jared.Still@r| || adisys.com | || | || 05/06/2002 | || 02:23 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | A DW is not simply a collection of data marts. A DW may be a true 'warehouse' of enterprise data from which DM may be built. Extracts go to the DW, DW is used to build DM. A DW may in fact very much resemble an OLTP database, with a temporal component thrown in to track changes to data over time. Users are not (generally) allowed acces to the DW. This is a full blown DW architecture though, and you may only wish to start with some DM to get your feet wet, or maybe that's all that is actually needed. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/06/2002 06:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Datawarehousing help Dennis, Forgetting about normalization won't be a problem, I've always been more practical than by the book. As for amounts of data being collected, I can see them wanting data aggregated hourly. I greatly doubt the tech people will allow adhoc queries, they seem to do things right here. What will happen is that they will be contacted by marketing with an I need this new report NOW request, but tech will generate it. But *my* problem is that the data warehouse will supposedly be only a small part of what I'm responsible for, I don't think they understand the scope of what they are asking for, as
Re: Good DBA vs. Bad DBA
HEY! I resent that. ask the last person who worked for me, I think I was a pretty good manager! |+--- || | || | || bthater2@nets| || cape.net | || | || 05/07/2002 | || 09:08 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Good DBA vs. Bad DBA| | [EMAIL PROTECTED] wrote: Dare I ask... do you have a Good Manager vs. Bad Manager list? you mean there is such a thing as a good manager? why don't people tell me these things?;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Never violate the Prime Directory! C:\ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Good DBA vs. Bad DBA
[EMAIL PROTECTED] wrote: HEY! I resent that. ask the last person who worked for me, I think I was a pretty good manager! but you are the goddess, and i never worked for you. i don't call it damagement for nothing. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Never underestimate the bandwidth of a station wagon full of tapes. - Jackson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Clone Database
I have to refresh a development database every day with the production DB. The size of the DB is 70GB and import last like 7 hours. Does anyone in the list has the steps to clone a database, not using import. TIA Ramon E. Estevez
Listener question. What is PNPKEY?
The default listener.ora file contains an IPC listing with (KEY=PNPKEY). I've searched the documentation and can't find any description of what this is for. Thanks, Keith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Re[2]: pl/sql is INTERPRETED?
Hi Dennis I was just working on a framework to make your dream come true ;). We are going to use a thin abstraction layer to provide peer objects to business objects in order to make them persistent (what a surprise). Old concept, but we didn't even try to do it the one size fits all way. The framework sole purpose is to support OLTP systems, to bundle what would usually be done using several queries by most OR wrappers into either one statement or at least a batch. I tried to make sure that SQL will not be to generic but Oracle specific. This is guaranteed by a pluggable architecture. Time to end this before it gets too confusing ... anyway, the goal is to maintain all the database access at a central point of the application. Regards, Stefan -Ursprüngliche Nachricht- Von: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 6. Mai 2002 16:44 An: Multiple recipients of list ORACLE-L Betreff: RE: Re[2]: pl/sql is INTERPRETED? All - I think one major point has been overlooked in this discussion of how hard it is to learn Java - OOD! Our company has been sending many developers to Java class. Almost everyone reports that the big hurdle is learning Object-Oriented Design. The Java syntax is relatively easy, simpler in fact that other languages. But for experienced designers especially, it takes awhile to get your head around the OOD principles. That was a major complaint about C++. Since it was a hybrid language, it was easy to think you were doing OOD, but actually you were developing procedurally. I think this all has some implications for the DBA. In theory, the database access (SQL) will be sequestered into a few Java classes, not scattered about the application. At least that is my dream. If anyone has experience on that aspect, I would be interested in hearing about it. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 06, 2002 12:13 AM To: Multiple recipients of list ORACLE-L Hello Alex, There are several books like Java in 21 days... You need to learn just basics. You don't need to remember all classes (I think it's not simple task). Therefore I think it's quite possible to learn java even in week or two. Thursday, May 02, 2002, 10:23:33 PM, you wrote: A It took you a week to learn it? Then you obviously do not know it. A Syntax is one thing design is another. I would love to know what you A learned in that week. A On Thu, 2 May 2002, Jared Still wrote: Hold on Lisa! Java is not complex. It's a very simple language actually. It took me a week to learn it, though I'm not using it now: I much prefer Perl. Getting a handle on all of the libraries and API's is another story, but Java as a language is pretty simple. Jared On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: You have a point Chris, but pl/sql is nowhere near as complex as an OO language like java or C++, IMHO. I agree with Tom that pl/sql can be learned fairly easily in comparison to the many other choices out there. However, it takes a bit of database savvy to do it correctly. (Not much tho) I was amazed in my database class in college that the same people failing the simple entity-relationship modeling portion of the class that had aced the Op Systems and networking classes we took. I nearly failed both classes, they were so complex. I was the teacher's pet in the db class because I asked him questions that made him think, and he sometimes couldn't answer. (And I had to wear a skirt - night student, straight from work.) What's easy for who is dependent on the person's strengths. Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: pl/sql is INTERPRETED? IMHO, I don't believe that you can properly learn PL/SQL in a very short period of time, or for that matter, any other language. I attended Steve Feuerstein's presentation at MAOP-AOTC conference, and he tore into many real-life examples of PL/SQL. Supposedly, these were written by developers that knew what they were doing. Granted, if a smart developer sits down and reads Feuerstein's Learning PL/SQL and Best Practices books, then perhaps they will be good. But who the hell has free time? There is no free time on any project or effort that I know of!! I'm struggling with trying to improve my Oracle DBA skills, plus some developers skills so I can speak their language when they blow out OPEN_CURSORS or something. My head is swimming in the stupid technical alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, BC4J, JDBC, SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me
Re: ERD generation tool - Active SCM
Sorry to disappoint you all. I gave him the password so he can connect as the owner and then he can do truncate. I scanned the list later and found the discussion on the subject and I am going to replace that with a procedure that he will be granted execute. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 2:38 PM I thought that there was a way via schema level triggers? I vaguely remember discussion on this last year -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Kimberly Smith [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: ERD generation tool - Active SCM Hey, how do you give that truncate only privilege -- 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Erwin - Does this thing work?
That's one I haven't heard about! -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Ji, Richard [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 11:58 AM To: Multiple recipients of list ORACLE-L Subject: RE: Erwin - Does this thing work? In our case, we had to add the following: In Windows settings, control panel, system, advanced, environment variables, add: Variable = NLS_LANG Value = American_America.UTF8 Rich -Original Message- Sent: Monday, May 06, 2002 10:28 PM To: Multiple recipients of list ORACLE-L There is a way around that pesky FK problem. Unfortunately we are using it... No FK's. And they wonder why they have data problems... -Original Message- [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Hi Lisa, Yes. But its a little convoluted. It took me quite some time to do it. Depends what you want included. IE. storage paramters etc. This is the product I use to generate all of our models and YES, it drives me nuts. They had a bug in the last version that didn't allow the FK constraints ddl to be generated properly! I am still having alot of issues with it but it has the company's STAMP OF APPROVAL, so its what I need to use sigh. Anyway, I use the OPTIONs under Forward Engineer and Created Several Templates (forget what THEY call'em). First I generate scripts for the tables with named PKs. Then the named FKs, then finally the indexes. THis way I can review them in a reasonable way instead of just spewing them all out there. Feel free to shoot me any specific questions. Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Koivu, Lisa [EMAIL PROTECTED] Sent: Monday, May 06, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Subject:OT: Erwin - Does this thing work? Hello all, I spent the weekend screwing around with Erwin. What a waste. I could not believe how poorly it generated DDL. Has anyone gotten this product to generate DDL in a readable, logical manner? I am using Version 4.0, SP1 Lisa Koivu Oracle Database Big Baby Oven Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
iTAR
I've been unsuccessful submitting an iTAR so far this morning. I'd like to hear if other list members have had success or failure opening a new iTAR today. FWIW - It fails using both Netscape IE browsers; but I get different symptoms from eachof them. -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now! -- 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).
CA's Data Dictionary for Oracle v9i Poster
http://ca.com/products/posters/oraclev9i_poster_form.htm Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Datawarehousing help
it stops me. I refuse to deliberately look like an idiot... I do enough damage inadvertently |+--- || | || | || [EMAIL PROTECTED]| || ms.osd.mil | || | || 05/07/2002 12:58 PM | || Please respond to| || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | Come on, Rachel! Zero Experence has never stopped anyone from publishing. Just look at academia and MCSE study guides... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 8:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: Datawarehousing help you people are soo funny. Writing a book takes time, hard work and more energy than I care to commit to the project.. especially on a subject with which I have zero experience -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Good DBA vs. Bad DBA
She was terrible!! I was SO happy when she left!! Talk about micro-management. Checking every single SQL script before I ran it. I couldn't believe she used that baseball bat on the duh-velopers!!! They were all in tears of joy when she left. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 12:38 PM To: Multiple recipients of list ORACLE-L HEY! I resent that. ask the last person who worked for me, I think I was a pretty good manager! |+--- || | || | || bthater2@nets| || cape.net | || | || 05/07/2002 | || 09:08 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Good DBA vs. Bad DBA| | [EMAIL PROTECTED] wrote: Dare I ask... do you have a Good Manager vs. Bad Manager list? you mean there is such a thing as a good manager? why don't people tell me these things?;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Never violate the Prime Directory! C:\ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
catalog maintenance
Hi, Does anyone know of any usefule scripts/tips to effectively maintain the rman catalog?? Most notably to delete very old entries??? Thanks in advance Fwzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 8.1.7.3 - Good or Bad ~~ Upgrade 8.0.5 to 8.1.7.3
Title: RE: Upgrade 8.0.5 to 8.1.7.3 Kevin Can youfindthe Bug Number possibly ? Can you Give us the TAR Number ? This would indeed allow me to STOP our Clients from moving to 8.1.7.3 from 8.1.7.2on SUN Sparc Solaris 8 Thanks Vivek -Original Message-From: Toepke, Kevin M [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 17, 2002 11:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Upgrade 8.0.5 to 8.1.7.3 Matt: I don't have the bug#s. When I opened a TAR on this (now unpublished) the support person called me and told me that I had to downgrade the database to workaround the bug. (All the TAR saysis thatthey called me.)The analyst said thatbug is one that is fixed in 9.0.2. In our case, whenever a specific stored procedure was called with a certain range or parameters, Oracle would use all of the available memory on the server -- causing the server to crash. Kevin -Original Message-From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 17, 2002 11:58 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Upgrade 8.0.5 to 8.1.7.3 Keven, Can you supply bug numbers for these bugs? Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Reason is 6/7ths of treason. - The Xtals -Original Message- From: Toepke, Kevin M [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: Upgrade 8.0.5 to 8.1.7.3 Jack: First of all, there are some serious problems with 8.1.7.3 that can cause database crashes and corruption. One bug (may be solaris specific) can crash the box. I would highly recommend that you "only" upgrade to 8.1.7.2 unless absolutely necessary. We have downgraded all of our 8.1.7.3 databases to 8.1.7.2 (a *very* painful experience) That said, I never had trouble upgrading directly to 8.1.7.2 directly from 8.1.5.x or 8.1.6.x. We have done in development, staging and production without any adverse effects. I don't think I've ever done a 8.0.5 to 8.1.7 directly. Kevin -Original Message- Sent: Wednesday, April 17, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Hi All, we are in the process of upgrading to 8.1.7.3 some of our databases (now 8.0.5) According to the Doc's thsi has to be done in two steps Upgrade to 8.1.7.0.0 followed by and upgrade to 8.1.7.3.0. This means that we have to upgrade all our databases in one go, or install another base 8.1.7 install to do some databases later. On our test system however we have upgraded directly form 8.0.5 and all seems to be fine. Anybody care to comment/share their opinions/experiences TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all
Re: Clone Database
Ramon, There is a paper on my site (http://www.optimaldba.com/library/CreatingOracledbusingphysicalcopy.html) that outlines the procedures to perform this cloning. The document uses 7.3, but the procedures remain the same. I would also recommend using this time to periodically test your production backups by using the backup files to recover to the development database. This can find problems in your backup/recovery process before a production recovery fails. You don't have to do it each time, but once a month would be a good target. Just my $.02 --- Ramon E. Estevez [EMAIL PROTECTED] wrote: I have to refresh a development database every day with the production DB. The size of the DB is 70GB and import last like 7 hours. Does anyone in the list has the steps to clone a database, not using import. TIA Ramon E. Estevez = Daniel W. Fink www.optimaldba.com Do not meddle in the affairs of Dragons. For you are crunchy and taste good with ketchup. __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ERD generation tool - Active SCM
via ActiveDesigner/ActiveChangeManager...just click on icon privileges and grant truncate only ref: http://www.iraje.com/acc_changemanagermain.htm Keith Date: Mon, 06 May 2002 18:28:25 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Hey, how do you give that truncate only privilege -Original Message- Peterson Sent: Monday, May 06, 2002 8:54 AM To: Multiple recipients of list ORACLE-L this is exactly my point. It would have been better to give your developer truncate only privileges, and that too only on a few tables... but NEVER the Oracle schema owner password! NEVER. But, you too gave it away! you too Brutus! Even though you are quite averse to doing so. Think about it, this happens everyday. Whether you like it or not, you have MASTER, TEST, PRODUCTION, DEVELOPMENT, STAGING... instances, and your schema passwords are floating around, and you have no control. And, you promise that you will never give the schema password out ever again, but you know you will... you will be forced to... your director will make you... and if you fight it any win, your developer productivity will be seriously compromised. You need to have a means of giving the schema access without giving away the full house. And the solution is NOT via a read-only user. A read-only user is useless. You cannot do any serious work in a read only user. Been there done that. Giving Oracle privileges, to users, as a case-by-case request, is IMPOSSIBLE for you to manage, UNREASONABLE and NOT FEASIBLE. Anyway, NEVER give the ORACLE PASSWORD away. Only encrypted access. And, let Dom Phoc work right in the owner schema. There will be no problem, if you can GUARANTEE limited access, full audits on everything Dom does via this access, including select statements. Dom Phoc will not be viewing the Salaries, and Credit Card numbers now... not if its being audited. At the expense of sounding like a sales person, let me point this out again for the benefit of the group: And, you certainly need to look at it: http://www.iraje.com/docs/ActiveSecureDesigner.htm I will find forward you some more info. Keith Date: Sun, 05 May 2002 03:48:18 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Well , just to keep things jumping. Last week I deviated from our rule and gave a responsible user that needed truncate on tables the password for the owner of the schema. Guess what? Today he comes to me to recreate 2 tables that he dropped. Go figure. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 03, 2002 5:53 PM Yechiel, Yes, I have been there, done that, over and over... But then, there is a Toyota Corolla solution and maybe a Ferrari Testarosa solution. If we can control Dom Phoc without tieing his hands behind the back, wouldn't that would be the best: white paper: http://www.iraje.com/docs/ActiveSecureDesigner.htm Keith Date: Thu, 02 May 2002 11:48:38 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Well Keith Our solution to the Doom Phoc (and their siblings) is: Do not grant they rights to do any DDL either in test nor in prod. The dab stuff does all the DDL work. Sure it is an added chore, but after tracking down, a few times, tables that were dropped inadvertently by users (their tool did it by itself) we now use the following policy: Every application has two user id's: Owner, with password known only to the DBA group. User with rights for select, insert, update, delete ONLY. It works. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 7:54 PM Lisa, There is only so much you can control via a model, since it remains a process away from the DB, and cannot be enforced via privileges, etc. So, we are always in the hands of Dom Phoc (and their siblings), who can do stuff even in the production database with SQLPLus/TOAD/... Under this schenario, do you sleep well at night? So, we said lets work with our Dom Phoc's. On production databases, we will STRIP them off of the Oracle database passwords. No password, no change. ENFORCED! Now, I can sleep well at night. How? Not via models. Via a solution involving the following, and it seems to be working for us well: ActiveDesigner/ActiveChangeManager/ActiveCompare/A+ White Paper: http://www.iraje.com/docs/ActiveSecureDesigner.htm Take charge of the Dom Phocs in your org! Keith To: '[EMAIL PROTECTED]' [EMAIL PROTECTED],
unknown value
Hi all: This is probably a simple question, but then again may be not. We are developing an application and will be loading data into bunch of tables. We will have a situation where some of the values will not be provided for various reasons. We don't want to make them NULL because some of these fields are part of a PK so we decided to come up with some values to mean unknown. Is there any reason NOT to use a question mark as such a value for char strings? To me it sounds like a character is a characted and question mark shouldn't be treated differently then, say, an X. Is there a situation when having ? in a character field instead of a letter can create problems? thank you Gene __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: iTAR
So far as I have been able to find out... I-tar is broken. The voice mail thing I got at the real person line said they were having system troubles but I got a human fairly fast when I got fed up with waiting for metalink and called and waited in the queue. April Wells -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/7/02 12:58 PM I've been unsuccessful submitting an iTAR so far this morning. I'd like to hear if other list members have had success or failure opening a new iTAR today. FWIW - It fails using both Netscape IE browsers; but I get different symptoms from eachof them. -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now! -- 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). begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE %;G0N#0H end -- 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).
RE: catalog maintenance
Fwzia, I use the following to generate commands to delete old backups (more than 90 days old)from the Rman Catalog. The output from the script (rman_delete.rcv) is fed into Rman to clean up the catalog. I run this job once a month. Hope this helps set heading off set feedback off set newpage 1 set pagesize 999 set linesize 60 spool rman_delete.rcv select 'allocate channel for maintenance type ' || || 'SBT_TAPE' || || ';' from dual; select 'change backuppiece '||bp.bp_key||' delete;' from rc_backup_piece bp,rc_database db where db.name = upper('%1') and bp.db_id = db.dbid and bp.start_time sysdate-90 / select 'exit;' from dual; spool off exit Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, May 07, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Hi, Does anyone know of any usefule scripts/tips to effectively maintain the rman catalog?? Most notably to delete very old entries??? Thanks in advance Fwzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Clone Database
Ramon, Are you able to do a refresh from a hotbackup of the database? Bryan -Original Message- Sent: Tuesday, May 07, 2002 10:29 AM To: Multiple recipients of list ORACLE-L I have to refresh a development database every day with the production DB. The size of the DB is 70GB and import last like 7 hours. Does anyone in the list has the steps to clone a database, not using import. TIA Ramon E. Estevez -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).