Well, after some diggings on metalink I found this. It basically says that there is a(nother) bug and according to their description:
create force view using a synonym for a table fails to create the view if the synonym is invalid.
The 10.2.0.3 and 10.2.0.4 databases are confirmed to be affected and this bug is supposed to be fixed in 10.2.0.5 and 11.2.In my case, the solution was to fix the synonyms problem and after that to reimport just the views using the INCLUDE parameter of the impdp utility.
1 comment:
Many thanks.
Post a Comment