Re: How to Extract job from database to create in another database
- From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 8 Oct 2012 15:20:58 -0300
Hi,
The error I am getting is:
-00017: following statement failed with ORACLE error 1:
"BEGIN DBMS_JOB.ISUBMIT(JOB=>2,WHAT=>'delete te_bo where data"
" < sysdate - 40/1440;',NEXT_DATE=>TO_DATE('2012-09-03:21:10:28','YYYY-MM-"
"DD:HH24:MI:SS'),INTERVAL=>'sysdate + 30/1440',NO_PARSE=>TRUE); END;"
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
ORA-06512: at "SYS.DBMS_JOB", line 100
ORA-06512: at line 1
When doing the import of the job that were exported from another database ,
the ID exists.
So I need to do a script to extract the code and control the ID.
Any experience with this kind of issue ?
Regards
Eriovaldo
On Mon, Oct 8, 2012 at 2:47 PM, Eriovaldo Andrietta
<ecandrietta@xxxxxxxxx>wrote:
> Hi Friends,
>
> I have some jobs create in the database.
> I need to generete the command to create the same job, with same
> parameters and instructions into anoter database.
>
> Is there anyway to do it not using exp/imp ?
>
> Does the DBMS_METADATA do it ?
>
> Any experience extracting this kind of command ?
>
> Regards
> Eriovaldo
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
