RE: extract stored pl/sql pcode

Use the ALL_SOURCE table. The source code is actually in the TEXT column.

Otherwise you have the stored object in any user or full export file.

-----Original Message-----
From: Immo Wetzel [mailto:iwetzel_at_gmx.de] Sent: 26. januar 2000 17:03
To: comp.databases.oracle.server_at_list.deja.com Subject: Re: extract stored pl/sql pcode

 Message from the Deja.com forum:
 comp.databases.oracle.server
 Your subscription is set to individual email delivery

immo wrote:

> Hello
>
> How can i extract some/all stored programm units so that i can it
> easy bring back into the database?
>
> Thanks
> Immo
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Or how can i load all extrated procedures, packages with one file ? I have extract all Procedures and packages with select text from dba_source where OWNER='USER' and change 'package' into 'create or replace package'

Thanks
Immo

--
----------------------------------------------------------------------------

Immo Wetzel
mailto:iwetzel_at_gmx.de
Webpage: http://immo.home.pages.de

Fachhochschule Stralsund http://www.fh-stralsund.de
momently in Finland





 _____________________________________________________________
 Deja.com: Before you buy.
 http://www.deja.com/
 * To modify or remove your subscription, go to
 http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.server
 * Read this thread at
 http://www.deja.com/thread/%3C388F1AC6.B76F4847%40gmx.de%3E


 Sent via Deja.com http://www.deja.com/
 Before you buy.