Re: COPY objects

q_matias_at_sic.com.uy (=?ISO-8859-1?Q?Mat=EDas_Bergengruen?=) wrote in message news:<ddb48689.0112210931.30d67739_at_posting.google.com>...
> Hi, I'm trying to copy objects from one squema to another.
> I'm looking for some kind of command or procedure that does the same
> as de COPY (table) command but for TRIGGERS, PROCEDURE, FUNCTIONS,
> PACKAGES, ETC.
>
> Tks, MATIAS

exp owner=(oldowner)
imp fromuser=(oldowner) touser=(newowner) will do everything. An empty newowner must exist.
Exp and imp are separate programs differing from sql*plus, documented in the Oracle Server Utilities Manual, online at http://technet.oracle.com

Hth

Sybrand Bakker
Senior Oracle DBA Received on Sat Dec 22 2001 - 09:47:33 CET