Packages are not imported properly
We are doing export of one user and import into another user during ovenight but some how from last few days it is importing packages properly....
Only package specification is getting imported and there is no package body...Also everything other that packages like tables, procedures, functions and sequnces are getting imported properly...
If anybody experinced such kind of problem...also whats the solution for this??
Thanks in advance
Is that Package Body created under different user than what package specification is created?
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
We are having 2 diffrent databases.
We are exporting User1 in DB1.
and then importing dump into User2 in DB2.
Somehow all tables,views, procedures, functions and only package specifications are getting created but there is no package body in packages...
I really dont understand why there is no package body in the packages...
Yes we had such a problem which you are getting now.
Actually we had all the procecure and package script in
We recreated from the text file.Better you keep all your scripts in text file.
Click Here to Expand Forum to Full Width