Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Import of PL/SQL procedure without doing a full user import

Re: Import of PL/SQL procedure without doing a full user import

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 10 Jan 2001 22:39:30 +0800
Message-ID: <3A5C7422.7DD2@yahoo.com>

James Williams wrote:
>
> I have a PL/SQL program that did not go through change control. The
> source is inside a user level export. Without importing the entire
> file could I direct export to look for a certain procedure?
>
> I have reviewed the Oracle Utilities manual but don't see a way as of
> 8.1.6.
>
> I could always use fromuser touser if I can find an area with enough
> disk space.

imp show=y

or

strings expdat.dmp

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"
Received on Wed Jan 10 2001 - 08:39:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US