Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Copying PL/SQL Objects
I have a question for the group:
What is the best way to copy a large set (>400 pkgs alone) of PL/SQL objects
(procedures, packages, etc.) from SCHEMA_A on database A (8.1.7.2 on AIX) to
SCHEMA_A on database B (9.2.0.2 on W2K) without whacking the tables, indexes
on database B?
I have thought about EXP/IMP, but the tablespace names do not match.
Thanks
Rick Weiss
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: rweiss_at_state.mt.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Mar 27 2003 - 15:03:46 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |