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

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.

   There is no standard way to do it... :-(  

> I could always use fromuser touser if I can find an area with enough
> disk space.

   To extract procedure you need no disk space for tables.    You need space for source code only in SYSTEM tablespace    You can even set zero tablespace quota for TOUSER user.

Valery Yourinsky

-- 
Oracle8 Certified DBA