Xref: alice comp.databases.oracle.server:83078
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.stanford.edu!logbridge.uoregon.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: Frederic Bidon <fbi@mobilix.dk>
Newsgroups: comp.databases.oracle.server
Subject: RE: extract stored pl/sql pcode
Date: Wed, 2 Feb 2000 17:53:37 +0100
Organization: Deja.com - Before you buy
Lines: 61
Message-ID: <2D3005375CAED31199D00008C784963F020987@ms02.mobilix.dk>
Mime-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
To: "'comp.databases.oracle.server@list.deja.com'"
	 <comp.databases.oracle.server@list.deja.com>
Cc: "'Immo Wetzel'" <iwetzel@gmx.de>
X-Mailer: Internet Mail Service (5.5.2448.0)
X-DejaID: _qzBE/hx7rR/0lou8UcXcXQ=

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@gmx.de]
Sent: 26. januar 2000 17:03
To: comp.databases.oracle.server@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@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.