Login  Register

Re: schedule rename partitions

Posted by ErmanArslansOracleBlog on Sep 12, 2017; 10:57am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/schedule-rename-partitions-tp3462p3466.html

create the job with the schema user, which you use for executing dbms_scheduler.run_job.

I mean, suppose your DB user is XXERMAN;

recreate your jobs in the XXERMAN schema
run "BEGIN DBMS_SCHEDULER.RUN_JOB"  from XXERMAN.

Update me with the outcome.