Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> invalid procedures
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
![]() |
![]() |