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).
