DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003

    Propagation of Procedures with Dependent Objects

    I need to propagate around 100 Procedures with all their dependent Objects from a source database to the destination database.
    Dependency levels may be recursive in nature also. I would also want dependent tables data to get propagated.
    Export Import may not be feasible since I do not want unwanted objects from the source database . Also, the source database is around 150GB in size. Can anyone suggest some solution/tool which may help.

  2. #2
    Join Date
    Dec 2002
    Bangalore ( India )
    use DBLINK (simplest)



    "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
    Jun 2000
    Madrid, Spain
    you've got to do this in several exports and imports, I just did this a couple of weeks ago moving a production database to integration, you first need to find out what data in what tables you need and you must work out that dependency

    export full=y rows=n

    export tables=a,b,c,d,e etc

    imp full=y rows=n constraint=n index=n

    imp fromuser=xxx touser=yyyy tables=a,b,c,d,e constraints=y

    it's tedious but it can be done with export import

    you can also try

    imp full=yes show=y log=imp.log

    then get the packages procedures in the log file

    or you can try create the users in the new database and use TOAD to compare Schemas it will generate a sql tetx file to syncronize the database
    Last edited by pando; 09-11-2003 at 06:20 AM.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.