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!


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.