Recent content by CanNeverThinkOfaName

papadba i have until april 1st to have the course paperwork all signed off by the trainer and into the grant people!! not much time! i dont intend to work in the next 9 months to be honest- just travel- then i have a years visa in canada for 2012... alvechurchdata - thanks for that input- i am...

Hi I have a grant to do a training course after being made redundant - but I can't decide what the hell is the wisest thing to do!! I have some database oracle admin experience (setting up database, importing, cronjobs), some business objects experience (admin, security, report writing) and a...

Thanks Dagon...thought that might be the case alright! I'll have to go with a nightly dump of data in my database from live it seems!

hi I have a problem with my materialized view on my replicated database- its taking about 20 hours to update every day! I've noticed it does a COMPLETE refresh every day and want it to do a fast refresh but I need to implement a log for this I've read....the DBAs for the live master database...

ahh I didn't realise it would be anything to do with extra licensing costs- that will be a definite no then as I've been asking for a new server to host the db for 2 years with no hope of getting one! When you mean a redesign of the database- what roughly do you mean please?

No the table isn't partitioned- but should be!!The problem is I don't know how to do it and neither does our DBA (long story dont ask!! - small company not willing to spend money - my database not a priority etc!) Is partitioning something I could read up on and do myself or is it a very...

Hi i need to count the number of people who are logged in over and including 3 minutes eg user a logs in at 9:00 and logs out at 9:05 user b logs in at 9:00 and logs out at 9:01 user c user a logs in at 9:00 and logs out at 9:03 from example above that would be users a and c! the row data...

Well THANK YOU! I added an index to b.usagetimestamp , b.channelid, b.externalno and also just seached addate alone for the date parts (as LKBrwnDBA suggested) - and it takes 30 seconds!! I only wish now I had done it incrementally and worked out which made it work best- I'm guessing the index...

My brain wasn't all there yesterday- there is a second (function based) index on the massive table B TO_DATE(TO_CHAR("ADDATE",'dd/mm/yyyy')||' '||"ADTIME",'dd/mm/yyyy hh24:mi:ss')-.006944444444444444444444444444444444444444,TO_DATE(TO_CHAR("ADDATE",'dd/mm/yyyy')||' '||"ADTIME",'dd/mm/yyyy...

Sorry Mufasa- I was a big vague!!! Thanks for helping me out! Execution Plan: Plan SELECT STATEMENT ALL_ROWSCost : 20,080 Bytes : 59,400 Cardinality : 495 11 FILTER 10 HASH JOIN Cost : 20,080 Bytes : 59,400 Cardinality : 495 8 HASH JOIN Cost : 19,513 Bytes : 55,278...

Hi all This query takes WAY too long to run (over an hour) - can anyone think of any other way to write it please?!! SELECT to_Date((to_char(A.ADDATE,'dd/mm/yyyy')||' '||A.ADTIME),'dd/mm/yyyy hh24:mi:ss'), B.ACCOUNTID, A.CAMPAIGN, ( C.TITLE ), A.WEEK, C.TITLE, D.TITLE FROM A, B, C, D, E WHERE...

LKBrwnDBA - that didnt work :( BJCooperIT - thanks for taking the time to reformat my query in a more user friendly way! However as you have written it, they are the correct links and pst.hjid does link to both ppd.transactions_transactions_id and ptl.parent_transactions_id - and should also...

Hi I have this following SQL statement where tables can join in various ways but I cannot get the data to return when I add in the last join The sql is as follows SELECT PURCH_ORDER.ACCOUNTID, PURCH_ORDER.ORDERDATEELEMENT, PURCH_ORDER.TOTALRATEDAMOUNT,PURCH_SUBSCRIPTION.FREQUENCY...

Hi Chris It doesnt go in a specific order of start stop start stop - there could be 2 start watchings on 2 TVs (this is the idea of sessionid but it isn't a field to rely on unfortunately) I am counting customer's not TVs I will work on getting some test data up here to show different...

Hi taupirho I hate to ask you this but my brain is just not working anymore today and I think I've looking at this query too long and can't see the wood for the trees anymore! Could you give me a helping hand and help me with the code I need to log to generate a secondary table which contains...