Re: Serious Issue in oracle

From: AMIT VERMA <verma.labs_at_gmail.com>
Date: Sat, 23 Jan 2010 15:53:44 +0530
Message-ID: <9ef8914e1001230223g6f640899iec80775a1e80bfa1_at_mail.gmail.com>



How should I know what happen at that time?

On Sat, Jan 23, 2010 at 2:50 PM, AMIT VERMA <verma.labs_at_gmail.com> 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_at_gmail.com> wrote:
>
>>
>>
>> 2010/1/23 AMIT VERMA <verma.labs_at_gmail.com>
>>
>> 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_at_skype.com
>
>
> "Winning takes talent but it takes character to keep winning"
>

-- 
Amit Verma
v.amit84_at_skype.com


"Winning takes talent but it takes character to keep winning"

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jan 23 2010 - 04:23:44 CST

Original text of this message