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 -> invalid procedures

invalid procedures

From: Anurag Minocha <anurag_at_synergy-infotech.com>
Date: Sat, 12 Jun 1999 11:30:06 +0530
Message-ID: <3761F765.B5344BBA@synergy-infotech.com>


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 Received on Sat Jun 12 1999 - 01:00:06 CDT

Original text of this message

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