Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: More "New" Oracle Gold
adding create or replace with vi to the result of select text from
all_source where name='MYPROC' ?
DA Morgan wrote:
> Or, again, at least "new" to me.
>
> A week or two ago I think we had a question here in the group about
> how to copy stored procedures from one schema to another and at the
> time my answer would have been ... better have the source code or
> use DBMS_METADATA to generate it: Not any more.
>
> The DBMS_SCHEMA_COPY built-in package does it beautifully ... well
> beautifully with one caveat ... it copies ALL PL/SQL objects ...
> and ONLY PL/SQL objects ... functions, packages, procedures, types,
> and views.
>
> You can find working demos in Morgan's Library at www.psoug.org
> under DBMS_SCHEMA_COPY.
>
> Daniel Morgan
> www.psoug.org
Received on Sun May 07 2006 - 04:41:53 CDT