Maximo interacts with Oracle's Manufacturing Apps, so if I were you I would open a TAR on this view, make sure you get an Oracle Apps support analyst to sign off on its creation/destruction/etc. and be done with it. Just make sure you keep a printed copy of the analyst saying 'ok' in case something dire happens at a later date. It's then a lot simpler to escalate the issue as needed.
Ibiza sounds nice. Enjoy! Chris Gait On 27 Jul 2003 at 22:49, [EMAIL PROTECTED] wrote: > 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: 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).
