Oracle-L: RE: Copying PL/SQL Objects

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Thu, 27 Mar 2003 13:59:17 -0800
Message-ID: <F001.00574CB8.20030327135917@fatcity.com>

Tora can do the trick.

-----Original Message-----
Sent: Thursday, March 27, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L

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: Gogala, Mladen
  INET: MGogala_at_oxhp.com

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-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Thu Mar 27 2003 - 15:59:17 CST