copy objects between databases - Programmers Heaven

Howdy, Stranger!

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


Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

copy objects between databases

infidelinfidel Posts: 2,900Member
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?



Sign In or Register to comment.