Re: invalid procedures

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 12 Jun 1999 15:59:34 GMT
Message-ID: <376983bf.5418160@newshost.us.oracle.com>

A copy of this was sent to Anurag Minocha <anurag_at_synergy-infotech.com> (if that email address didn't require changing) On Sat, 12 Jun 1999 11:30:06 +0530, you wrote:

>Hi,
>When i export my user with all the tables and procedures and the again
>import it the procedures become invalid. i again have to compile them.
>is there a way that i dont have to compile them again.
>
>export command used exp80 <username>/<password>@<service name>
>file=<file name.dmp> indexes=y constraints=y grants=y
>
>import command used imp80 <username>/<password>@<service name>
>file=<file name.dmp > fromuser=<user name> touser=<username>
>
>anurag

they will compile all by themselves -- you don't need to compile them.

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/

Current article is "Fine Grained Access Control", added June 8'th  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Jun 12 1999 - 10:59:34 CDT