OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » imp issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

imp issue [message #250414]

Tue, 10 July 2007 00:22

guru_karnam
Messages: 142
Registered: May 2005

Senior Member

When I tried to import the dump I got this error in dbms)_scheduler. Why is this happening everytime I import?

" end getTimeForHierarchy;"
""
"END ipdc_ss;"
IMP-00017: following statement failed with ORACLE error 27477:
"BEGIN "
"dbms_scheduler.create_job('"CHECKBUNDLEMEMBERVALIDITY_JOB"',"
"job_type=>'STORED_PROCEDURE', job_action=>"
"'ipdc_global.CheckBundleMemberValidity'"
", number_of_arguments=>0,"
"start_date=>'28-JUN-07 12.00.00.000000 AM EET', repeat_interval=> "
"'freq = daily; byhour = 3'"
", end_date=>NULL,"
"job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>TRUE,comments="
">"
"NULL"
");"
"dbms_scheduler.enable('"CHECKBUNDLEMEMBERVALIDITY_JOB"');"
"COMMIT; END;"
IMP-00003: ORACLE error 27477 encountered
ORA-27477: "IPDC.CHECKBUNDLEMEMBERVALIDITY_JOB" already exists
ORA-06512: at "SYS.DBMS_ISCHED", line 99
ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
ORA-06512: at line 2
IMP-00091: Above error occurred on the following function and object: CREATE CHECKBUNDLEMEMBERVALIDITY_JOB. Remaining PL/SQL blocks for this object will be skipped.
IMP-00017: following statement failed with ORACLE error 27477:
"BEGIN "
"dbms_scheduler.create_job('"DB_CLEANUP_JOB"',"
"job_type=>'STORED_PROCEDURE', job_action=>"
"'ipdc_global.db_cleanup'"
", number_of_arguments=>0,"
"start_date=>'28-JUN-07 12.00.00.000000 AM EET', repeat_interval=> "
"'freq = daily; byhour = 5'"
", end_date=>NULL,"
"job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>TRUE,comments="
">"
"NULL"
");"
"dbms_scheduler.enable('"DB_CLEANUP_JOB"');"
"COMMIT; END;"
IMP-00003: ORACLE error 27477 encountered
ORA-27477: "IPDC.DB_CLEANUP_JOB" already exists
ORA-06512: at "SYS.DBMS_ISCHED", line 99
ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
ORA-06512: at line 2
IMP-00091: Above error occurred on the following function and object: CREATE DB_CLEANUP_JOB. Remaining PL/SQL blocks for this object will be skipped.
Import terminated successfully with warnings.
[oracle@it-habsm-db1 ~]$

Report message to a moderator

Re: imp issue [message #250415 is a reply to message #250414]

Tue, 10 July 2007 00:25

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

The Job name already exits. Delete the previous job or rename the job name....

Report message to a moderator

Re: imp issue [message #250421 is a reply to message #250415]

Tue, 10 July 2007 00:44

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read and follow How to format your posts.

Btw, exp(dp)/imp(dp) is not a backup.

Regards
Michel

Report message to a moderator

Re: imp issue [message #250506 is a reply to message #250421]

Tue, 10 July 2007 05:40

ebrian
Messages: 2794
Registered: April 2006

Senior Member

EXP[DP]/IMP[DP] are definitely backups (logical), however for backup purposes are typically used to supplement a physical backup of the database itself.

Report message to a moderator

Re: imp issue [message #250516 is a reply to message #250506]

Tue, 10 July 2007 05:55

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I meant it does not fit in Backup forum.

By experience, if someone thinks exp is a backup, he will soon ask how to apply archived logs on it.

Regards
Michel

Report message to a moderator

Re: imp issue [message #250517 is a reply to message #250516]

Tue, 10 July 2007 05:58

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Michel Cadot wrote on Tue, 10 July 2007 06:55

By experience, if someone thinks exp is a backup, he will soon ask how to apply archived logs on it.

Now ain't that the truth !! I've definitely seen that question many times.

Report message to a moderator

Re: imp issue [message #250590 is a reply to message #250517]

Tue, 10 July 2007 10:32

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery

http://orafaq.com/faqiexp.htm

Report message to a moderator

Re: imp issue [message #261641 is a reply to message #250590]

Thu, 23 August 2007 03:30

guru_karnam
Messages: 142
Registered: May 2005

Senior Member

How do I supress this error while importing?

orelse how do I delete that job from the sys user?

Regards,
Ravi M

Report message to a moderator

Re: imp issue [message #261650 is a reply to message #250414]

Thu, 23 August 2007 04:07

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Rename the new import job name if you cannot delete.You should know how to delete a job.

Report message to a moderator

Re: imp issue [message #261778 is a reply to message #261650]

Thu, 23 August 2007 10:21

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

 SQL> exec dbms_scheduler.drop_job('job_name', TRUE);

SQL> SELECT job_name, enabled
  2  FROM dba_scheduler_jobs;

[Updated on: Thu, 23 August 2007 10:21]

Report message to a moderator

Previous Topic:	tuning for export
Next Topic:	How To Encrypt the dump file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 08:41:31 CST 2024