Packages are not imported properly
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Packages are not imported properly

  1. #1
    Join Date
    May 2001
    Location
    London
    Posts
    149

    Packages are not imported properly

    Hello Guys,

    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

    Paresh

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Is that Package Body created under different user than what package specification is created?

    Abhay.
    funky...

    "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"

  3. #3
    Join Date
    May 2001
    Location
    London
    Posts
    149
    Yes...

    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...

  4. #4
    Join Date
    Jun 2003
    Posts
    108
    Yes we had such a problem which you are getting now.
    Actually we had all the procecure and package script in
    text file.

    We recreated from the text file.Better you keep all your scripts in text file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width