| EXP/IMP - Stored Procedure requires Execution? [message #136408] |
Wed, 07 September 2005 22:54  |
mymot
Messages: 225
Registered: July 2005
|
Senior Member |
|
|
Hi,
Db: oracle 9i
I have exported schema from db1 to db2.
imp userid=u1/u1 file=t1.dmp fromuser=u1 touser=u1
On db2, i need to compile some of the stored procedures manaually.
Is there any way i could do by running single command to run all the uncomplied stored procedure in db2 after importing from db1.
Do i need to compile Stored Procedure manually after importing?
Thanks
|
|
|
|
| Re: EXP/IMP - Stored Procedure requires Execution? [message #136927 is a reply to message #136408] |
Mon, 12 September 2005 05:24  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
You can use the following "command" to recompile all invalid objects:
SQL> @?/rdbms/admin/utlrp.sql
NOTE: On my Oracle 10.1.0.4 system, utlrp.sql calls utlprp.sql (parallel recompile). In turn, utlprp.sql calls either utl_recomp.recomp_serial or utl_recomp.recomp_parallel. The utl_recomp package is defined in script utlrcmp.sql.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
