Hi Friends,

I took a full export of 9i db and after creating the necessary users in the newly created 9i db, i imported it.

In one of the users, all the objects are there but most of the views are invalid and if i try to compile them,it says table does not exist.But that table exists .

what might be the reason? if it is related to priveleges, how to determine what all priveleges that needs to be created before I again begin the Import ?

thanks