How should I know what happen at that time? On Sat, Jan 23, 2010 at 2:50 PM, AMIT VERMA <verma.labs@xxxxxxxxx> wrote: > > hi david, > > All grants are given. Eariler we were able to access it however index & > table are Valid. When there was no solution to resolve it we have rebooted > the database. And thereafter problem resolves, we again access the table. > Its Strange! > > please advice. > > thanks, > amit v > > > > On Sat, Jan 23, 2010 at 2:08 PM, David Ballester < > ballester.david@xxxxxxxxx> wrote: > >> >> >> 2010/1/23 AMIT VERMA <verma.labs@xxxxxxxxx> >> >> All, >>> >>> I am sharing my yesterday experience with you, below are the details: >>> >>> * >>> ISSUE: >>> * >>> Not able to access the table. >>> ** >>> *DEPLOYMENT:* >>> In a A schema we have 7 tables x1, x2.... x7 which is further join by a >>> VIEW y. Other B/C schema access the y to get the records. >>> >>> *ROOT CASUSE:* >>> ** :( not able to locate, no error in the alert log, statistics are >>> uptodate. Oracle Version is 10g Standard with RHEL update 8. >>> >>> >>> Any Suggestions... >>> >> >> i've one, try to explain better what you can't do :) anyway, are you sure >> that all grants necessary are put in place? remember that each time that you >> recreate an object, even with the same name, the grants must be reapplied >> >> >> > > > -- > Amit Verma > v.amit84@xxxxxxxxx > > > "Winning takes talent but it takes character to keep winning" > -- Amit Verma v.amit84@xxxxxxxxx "Winning takes talent but it takes character to keep winning"