I have a working DB holding schema1.
I needed to clone the schema1 to schema2. I did this with
impdp. Everything worked fine, least when doing
impdp for metadata I got the following error:
ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated Failing sql is:
BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 3, LUSER=> 'SCHEMA2', PUSER=> 'SCHEMA2', CUSER=> 'SCHEMA2', NEXT_DATE=> TO_DATE('2017-10-30 11:00:00', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'trunc(sysdate,''HH24'')+1/24', BROKEN=> FALSE, WHAT=> 'a_database_job;', NLSENV=> 'NLS_LANGUAGE=''AMERICAN'' NLS_TERRITORY=''AMERICA'' NLS_CURRENCY=''$'' NLS_ISO_CURRENCY=''AMERICA'' NLS_N
Now the way I read this is because of the jobs that were trying to get in the
SYS.DBMS_IJOB and keep he same number perhaps for the second schema.
So my question is How do I migrate the / a set of jobs from schema1 to schema2 - can this be done by just changing the owner?
hope there is enough data here.