Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Copying PL/SQL Objects

Copying PL/SQL Objects

From: Weiss, Rick <rweiss_at_state.mt.us>
Date: Thu, 27 Mar 2003 13:03:46 -0800
Message-ID: <F001.00574ACC.20030327130346@fatcity.com>


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-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:03:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US