RE: extract stored pl/sql pcode

From: Frederic Bidon <fbi_at_mobilix.dk>
Date: Wed, 2 Feb 2000 17:53:37 +0100
Message-ID: <2D3005375CAED31199D00008C784963F020987@ms02.mobilix.dk>

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. Received on Wed Feb 02 2000 - 10:53:37 CST