Recent content by Kenton

Thanks, (sorry for the delay) yes the SUCCESS issue is known. What I'm after is why the following error: ORA-20001: Error Encountered in CDR_CLAIM_AGEING_PKG - PROCESS_BY_SUBMISSION - -20001 - ORA-20001: Error Encountered in cdr_db_pkg - get_previous_submission_id - 100 - ORA-01403: no data...

Usually we're just running procedures with no output. Thanks Kenton (Note: I must remember to add something witty & technical for my signature)

I don't know whether this is the right place or not, but there is a definite lack of Control-M forum (anywhere) so I picked here. I have taken over a system sheduled by control-m and the wrapper script that calls oracle procedures is not returning error codes etc back to control-m. The error...

Hi Sem Same for both: NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ optimizer_index_caching integer 0 optimizer_index_cost_adj integer 100 Thanks Kenton (Note: I must...

Thanks for the help guys!!! I will try your suggestions to try ans squeeze more life out of it but I have found an acceptable solution anyway. I added the hint INDEX_SS(f_policy F_POLICY_FK_D_POL_IDX) to both the main query and nested subquery and it returned in 15 mins. The plan cost jumped...

Mufasa ... your results TRUNC(LAS COUNT(*) --------- ---------- 14/OCT/08 2 07/OCT/08 1 04/OCT/08 6 11/OCT/08 1 10/OCT/08 1 15/OCT/08 1 13/OCT/08 29 7 rows selected. LKBrwnDBA .... tried the hint but it made no difference...

Thanks everyone ... here are my answers: Turkbear ... insert into S_POLICY_BY_PRY select fpol.policy_wca_id, fpol.AGENT_INSURER_ID, fpol.EMPLOYER_ID, fpol.SOURCE_POLICY_NUMBER, fpol.POLICY_RENEWAL_YEAR...

Hello ... A query that used to take 20 mins to complete under 9i now does not return a result after 24 hours. Looking at the CBO execution plans we get ... for 9i ------------------------------------------------------------------------------------------------------------------------- |...

Thank you for the example, I have seen quite a few similar to this but still have some questions. 1) You declare a type of test_tab.a%type. How do you cope with cursors that use multiple tables? 2) You use one key from the cursor. How do you code this for multiple keys as per my example? 3) Is...

How do I do an update AND insert during the match part of a MERGE? Thanks Kenton (Note: I must remember to add something witty & technical for my signature)

Hello I am trying to gain some performance on a DW ETL process and would like to use Bulk Collect and/or FORALL. I have spent quite some hours reading up but I am totally lost. Here's what I'm trying to do: DECLARE CURSOR c1 IS SELECT key1, key2, value1 FROM table1@db1; asofdt...

Please excuse my lack on knowledge, I'm relly new to all this. We are a small home-based business in Australia - well 2 businesses. We currently have 2 phone numbers assigned to our home phone with different ring tones depending on what number has been called. Upstairs there is one phone...

Hi I've got the same problem and will be trying the following when I get home tonight. Turn off USB Authoring Support & FireWire Authoring Support in the Extensions manager control panel. see: http://docs.info.apple.com/article.html?artnum=60805 Hopefully that will work Thanks Kenton...

Great so far. This has fixed my problem with rm but not mv find /archive -type f -name '*' -print | xargs -i mv -f {} /oldfiles gives me the error myfile.sh[19]: /sbin/mv: arg list too long What am I doing wrong? Thanks Kenton

Found it! There is a bug in Informix Dynamic Server 7.3 A. Mail Generated When /NONOTIFY Flag Used (Resolution for PTS 34406) ON-Archive always generates a mail even if you use the /NONOTIFY flag. Refer to Archive and Backup Guide, Version 7.3, page 8-19, 8-28, and 8-75. Anyone know how to...