Thanks All . You have given me more insight into the problem. My friend did all this with a blink of the eye and so couldn't do more research on this. So can i conlclude that running CATALOG.SQL is the best answer in such a situation ? And how do i find whether my dict. tables are corrupted or not ? Perhaps, i can do that and be safe ! Regards, Prem. -- //www.freelists.org/webpage/oracle-l