Re: Un-able to upload xml file - Error:ORA-14400: inserted partition key does not map to any partition
From: Robert Hanuschke <robert.hanuschke_at_gmail.com>
Date: Wed, 8 Aug 2012 08:09:42 +0200
Message-ID: <CAL6WDh2ou6Ce-vmv46MCAN_E_QLT0mRQLfzWxXkjsmXz0PXq2g_at_mail.gmail.com>
Hi Niall,
was just trying that in one of our test databases:
dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','TRUE');
Date: Wed, 8 Aug 2012 08:09:42 +0200
Message-ID: <CAL6WDh2ou6Ce-vmv46MCAN_E_QLT0mRQLfzWxXkjsmXz0PXq2g_at_mail.gmail.com>
Hi Niall,
was just trying that in one of our test databases:
SQL> show parameter job_queue_processes;
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ job_queue_processes integer 10SQL> exec
dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','TRUE');
PL/SQL procedure successfully completed.
SQL> show parameter job_queue_processes;
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ job_queue_processes integer 10
At least disabling the scheduler that way did not modify the parameter. Did you possibly do it another way?
Best regards,
Robert
http://robertvsoracle.blogspot.com
On Wed, Aug 8, 2012 at 8:01 AM, Niall Litchfield <niall.litchfield_at_gmail.com
> wrote:
> One unsupported (probably) way of having this happen is to turn off the
> scheduler via its enabled/disabled property IIRC. We certainly had a db
> where disabling the scheduler disabled the dbms_job system as well, I
> *think* with the symptoms you describe.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 08 2012 - 01:09:42 CDT