Rabbit - Please don't take offense. From time to time I myself have had someone try to make me do something really dumb, and it is really helpful to innocently ask the question on this list and then return to that person's office with a handful of scorching replies. But until we get that strong Guild of Oracle Administrators formed, we are all at the mercy of our employers. You are a professional, do what you must and then enjoy your holiday.
Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Monday, July 28, 2003 1:49 AM To: Multiple recipients of list ORACLE-L I havent got original Subject e-mail as it is on my home PC. Firstly let me just say how I like to use this list. As I am completely different time zone to you guys i.e. I am Brit living in Middle East, also our weekends are thu/fri - by the time I read posted questions they are usually well answered. But I do like to follow the list and now and again I post a question for a number of reasons. In this case I am leaving for a months vacation to Ibiza on Wednesday, before that Im doing a database upgrade in test(on 10 schemas- each one takes 3-5 hours), a million other jobs and frankly Ive not faced a problem such as this for a long time. Now ,is not the time I have to investigate fully the problem myself, I have 2 more days and Im offsky to party,big style - aint gonna be worrying bout no sys.icol$ view. Anyhow I also have a work around as I explained by dropping a Maximo table (not from SYS schema if you look at original post carefully) but I still thought original problem may be interesting to some people out there or even another MAXIMO DBA who has had a similar experience.(we are a multi schema site- unique in Maximo world though). Many posts are unanswered and it was just a chance somebody would have a 'heads up' on this. If not no big deal. I must remind you that this a MANDATORY installation script provided by the vendor as part of the MAXIMO ERP implementation. All of a sudden a self proclaimed guru (MUPPET) starts accusing me of being a disgrace to DBA's then I get another mail also telling me how I should stop implementations of products if they touch SYS schema(whats all that IBM about - somebody please come to my rescue here). Is the world going mad or do I need this holiday more than I thought. (maybe I do) MAXIMO(MROI) is the leading vendor of MATERIALS MANAGEMENT software in the World (Its a USA company mate). Sorry BP/SHELL CEO we have to cancel 5 million dollar implementation because DBA says you cant create view in SYS schema(and its not Data Dictionary just cause its SYS ).Well SHELL/BP CEO says tell the DBA TO GO ****** HIMSELF with his P45.Grow up please.Have you ever worked on a large ERP implementation. Have u ever been on a big job before? Well I took the abuse and then got accused of being to blase talking about SYS objects, and thats why I was rebuked (please- was that an apology ?). Well if you dont like the question or its not to ure liking the way I structured it well ignore it mate. Your reply was totally offensive ,rude,and also ignorant as you fully missed the point. By the way of course I tried wait events , your specialist subject must be ' the bleeding obvious'. I was looking for something a little more inspirational and imaginative. I know some people may find this reply also offensive and Im sorry for that, but enough is enough- I didnt realise there was a bizzy on the list and the rubuke did it for me. On a serious note though I am not afraid to ask questions and for that matter am not afraid to talk about sex (please feel free off line,girls only). Im also not afraid to take criticism, if I missed something obvious. Dont we all from time to time. IT people used to be fun and have a sense of humour. That includes laughing at yourself when you balls up. Next time I will take more care when structuring a question.Maybe I did rush it and it wasn't clear and was misleading. Anyhow I want to withdraw the original post, I cant deal with any other Numpty telling me woes and pitfalls and evil things that will happen to me if I mess with SYS. Roll on Ibiza - p.s. It was waiting all the time on TEMP tablespace- probably because Hash join. Temp was empty and well sized -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
