Home » RDBMS Server » Server Utilities » invalid objects while importing
invalid objects while importing [message #73737] Mon, 28 June 2004 09:41 Go to next message
sandeep
Messages: 110
Registered: October 2000
Senior Member
when i exported one schema from ond db to another schema (i created new one) all the tables are in valid state but the views and procedure becomes invalid how to overcome this problem.i want all the objects should be valid if i have to go to manually compile the objects its comes around 1000 objects

Report message to a moderator

Re: invalid objects while importing [message #73742 is a reply to message #73737] Tue, 29 June 2004 03:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try compile=y during import.

Report message to a moderator

Re: invalid objects while importing [message #73748 is a reply to message #73742] Wed, 30 June 2004 03:32 Go to previous message
sandeep
Messages: 110
Registered: October 2000
Senior Member
that will be defualt
then what may went wrong
when i am trying to compile it gives plsql errors

Report message to a moderator

Previous Topic: import data from oracle 8.1.6 to 8.1.7
Next Topic: reading a value into an oracle script
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 02:11:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.