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
IMP-00017: following statement failed with ORACLE error 4043:
"ALTER PROCEDURE "CALC_DONNEES_DER_MPP" COMPILE REUSE SETTINGS TIMESTAMP '20"
IMP-00003: ORACLE error 4043 encountered
ORA-04043: object CALC_DONNEES_DER_MPP does not exist
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!