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?
0 · ·