Home » RDBMS Server » Server Administration » about imp problem
about imp problem [message #57235] Thu, 29 May 2003 21:53 Go to next message
aniugecn
Messages: 2
Registered: May 2003
Junior Member
why after imp functions and procdures come to invalid

Report message to a moderator

Re: about imp problem [message #57238 is a reply to message #57235] Fri, 30 May 2003 04:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
something might have gone wrong.
if the base tables were not created, functions/procs
will get INVALID.
post the log of ur import sesssion.

Report message to a moderator

Re: about imp problem [message #57247 is a reply to message #57235] Fri, 30 May 2003 14:56 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
heyy,
when the objects are getting imported there is a chance that a procure P (say) gets imported first whcih uses a table T (say) internally without being imported.. hence P becomes invalid..
If u are sure that they are error free in the parent schema.. u can solve this issue by saying..

exec dbms_utility.compile_schema('schema name');

sai

Report message to a moderator

Previous Topic: tablespace management
Next Topic: Oracle 9i Installer
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 11:36:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.