Oracle Data Import

5 pts.
Tags:
Oracle Application Server
I am doing an import every week in the test and development database.The import is working fine in the test database.But while i import in the developement database .I am enountering with the errors.All the tables are getting imported successfully ,but after that i am getting the below import error.Actually i am importing all the objects (procedures,functions,packages etc)from the dump file only.But some of the procedures are not getting imported and when the import tries to re- execute those procedures i am getting the following error. Kindly help me to sort this out.Many thanks . Action taken :- I have compared all the database parameters of the test and development.All are similar. my import statement :- imp $ORCONNECTION file=$DUMP_FILES fromuser=abcuser touser=abcuser ignore=y log=fullimp.log buffer=300000 Error:- IMP-00017: following statement failed with ORACLE error 4043: "ALTER PROCEDURE "CALC_DONNEES_DER_MPP" COMPILE REUSE SETTINGS TIMESTAMP '20" "07-06-06:19:34:44'" IMP-00003: ORACLE error 4043 encountered ORA-04043: object CALC_DONNEES_DER_MPP does not exist
ASKED: February 6, 2008  12:36 PM
UPDATED: February 6, 2008  5:37 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

The stored procedure CALC_DONNEES_DER_MPP does not exist in the schema of the user running the import or the rights to that procedure have been removed.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following