copy objects between databases

I'm looking for code to copy objects between databases. I can use regular sql statements to query the user_source view and build a create or replace statement, but the pl/sql dynamic sql facilities are limited to 32K and some of our packages and/or package bodies are bigger than that. To be more specific, I need to keep a number of roaming laptop-based Oracle databases up-to-date with the code and data on the main database. I'm looking for a way to update views, functions, packages, etc via a stored procedure rather than using Oracle's replication functionality. Any ideas?



  • I might be inclined to share if someone is interested.


  • Hi,

    I am interested...
    I hope you still know how you did it, 7 years ago :-)
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!