DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Copying Oracle Packages

  1. #1
    Join Date
    Jul 2002
    Posts
    5

    Angry

    Hi Friends,

    Is thr any way to copy the missing packages from 1 DB to another DB, if Yes, then How, and whr will the scripts b available??
    or can anyone gimme the scripts for creating the packages??

    Thnx in Advance...

    Regards,

    Ravin

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    One way to find out the missing packages is by viewing user_soure view.The other way is to go in Oracle Schema Manager in Oracle OEM and get the text for the database objects.I prefer the second option as you get the text for all the database objects in it.

    Regards,
    Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

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