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

Thread: Propagation of Procedures with Dependent Objects

  1. #1
    Join Date
    Sep 2003
    Posts
    19

    Propagation of Procedures with Dependent Objects

    Hi,
    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.
    Thanks!
    Preeti

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    use DBLINK (simplest)

    or

    informatica
    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
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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