Search results for query: *

Hi all experts, quick question for you. I vaguely remember when looking at the new features of Oracle 10 something about external tables and excel spreadsheets. Where each sheet in a workbook becomes a separate external table. I’ve used external tables a fare bit but am very interested in this...

:) Thanks nothing like making 4 times the amount of work for yourself because you don’t know what Oracle can do with dates – SILLY ME

I’ve been working on reports and needed to get some quarters for a parameter list. This may be of interest to anyone who runs quarterly reports. However I also have a question and that is, am I making this complicated, is there a simpler way to do this? Basically to get the current quarter for...

Hi The Service Request number is: 5902944.993 The Bug Ref is: 5660222 Good luck Muppet :)

Hey no probs you're a programmer of course you're pedantic, it’s expected

:) AS SOON AS I GET IT I can assure you I am waiting on tender hooks as this upgrade is now way overdue for us, and is fine on our other database. Intermittent problems are sooooooooo frustrating. Cheers M

Hi I thought I’d quickly update this post in case anyone is interested in what has happens. We logged a call with Oracle and although it took awhile they have confirmed that there is a bug in 10g causing this problem. It is relay an intermittent problem as most insert statements are working...

Hi Yup we did that but it didn’t help. Over the past few days I’ve been in contact with Oracle. They have confirmed that it is a bug in the optimizer and are working on the problem. Hopefully they will come back to me with some DB param changes. Thanks for all the suggestions I’ll let you know...

Thanks I have printed out all the params from v$parameters and am going through them at the moment. Here are the two explain plans. I can only think there must be some setup in 10g that has caused this, hopefully looking through the v$parameters etc will help. If anyone has any suggestions on...

THANKS Beilstwh and taupirho Yup we did gather stats straight after the upgrade and once again after not being able to solve the problems. I have just run the explain plan and they are different. I find this strange since the new database is a copy of the old DB it’s just been upgraded. My sad...

Hi PLEASE PLEASE PLEASE help me I’m really stuck. We have just upgraded our 9i Oracle DB to 10g. (This is a copy of our live DB that we are upgrading to test) There have been no hardware or code changes. My problem is that some of our code is now running dog slow. For example a 2.5 hour...