Home » RDBMS Server » Server Utilities » imp issue
imp issue [message #250414] Tue, 10 July 2007 00:22 Go to next message
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 ~]$
Re: imp issue [message #250415 is a reply to message #250414] Tue, 10 July 2007 00:25 Go to previous messageGo to next message
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....
Re: imp issue [message #250421 is a reply to message #250415] Tue, 10 July 2007 00:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow How to format your posts.

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

Regards
Michel


Re: imp issue [message #250506 is a reply to message #250421] Tue, 10 July 2007 05:40 Go to previous messageGo to next message
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.
Re: imp issue [message #250516 is a reply to message #250506] Tue, 10 July 2007 05:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: imp issue [message #250517 is a reply to message #250516] Tue, 10 July 2007 05:58 Go to previous messageGo to next message
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.
Re: imp issue [message #250590 is a reply to message #250517] Tue, 10 July 2007 10:32 Go to previous messageGo to next message
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
Re: imp issue [message #261641 is a reply to message #250590] Thu, 23 August 2007 03:30 Go to previous messageGo to next message
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
Re: imp issue [message #261650 is a reply to message #250414] Thu, 23 August 2007 04:07 Go to previous messageGo to next message
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.
Re: imp issue [message #261778 is a reply to message #261650] Thu, 23 August 2007 10:21 Go to previous message
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:
  


Current Time: Tue Dec 06 02:40:52 CST 2016

Total time taken to generate the page: 0.10772 seconds