Re: dbms_utility.uncl_array
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: Chuck Boddy <Chuck.Boddy@xxxxxxxxxxxxxxx>
- Date: Fri, 15 Oct 2010 21:46:59 +0200
Ahh ok
Ignore the previous mail then :)
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Fri, Oct 15, 2010 at 9:46 PM, Stefan Knecht <knecht.stefan@xxxxxxxxx>wrote:
> Hi Chuck
>
> Not very much familar with dbms_refresh and its internals, but it seems
> like something is missing.
>
> But it does appear as it's actually starting to run, compared to the first
> errors you mentioned.
>
> What you can do to further diagnose it is:
>
> alter session set events '1403 trace name errorstack level 1';
>
> Then, run your statement again, and check the tracefile generated in udump
> for the Current SQL statement, as well as the errorstack. This may lead to
> further hints about what's going on.
>
>
>
> Stefan
>
>
>
> =========================
>
> Stefan P Knecht
> CEO & Founder
> s@xxxxxxxx
>
> 10046 Consulting GmbH
> Schwarzackerstrasse 29
> CH-8304 Wallisellen
> Switzerland
>
> Phone +41-(0)8400-10046
> Cell +41 (0) 79 571 36 27
> info@xxxxxxxx
> http://www.10046.ch
>
> =========================
>
>
> On Fri, Oct 15, 2010 at 9:40 PM, Chuck Boddy
> <Chuck.Boddy@xxxxxxxxxxxxxxx>wrote:
>
>> Hi Stefan,
>>
>> You are probably right….when I’ve used single quotes..i’ve gotten this
>> error instead….not quite sure why?...any ideas…the object does exist…
>>
>> Thanks,
>>
>> Chuck
>>
>>
>>
>> ORA-01403: no data found
>>
>> ORA-06512: at "SYS.DBMS_IREFRESH", line 820
>>
>> ORA-06512: at "SYS.DBMS_REFRESH", line 84
>>
>> ORA-06512: at line 90
>>
>>
>>
>> *From:* Stefan Knecht [mailto:knecht.stefan@xxxxxxxxx]
>> *Sent:* Friday, October 15, 2010 12:33 PM
>> *To:* Chuck Boddy
>> *Cc:* oracle-l-freelists
>> *Subject:* Re: dbms_utility.uncl_array
>>
>>
>>
>> Chuck,
>>
>>
>>
>> vSnapshotList(1) := “TABLE1”;
>>
>>
>>
>> You don't want to be using double quotes there. Just normal single quotes.
>>
>>
>>
>> Stefan
>>
>>
>> =========================
>>
>> Stefan P Knecht
>> CEO & Founder
>> s@xxxxxxxx
>>
>> 10046 Consulting GmbH
>> Schwarzackerstrasse 29
>> CH-8304 Wallisellen
>> Switzerland
>>
>> Phone +41-(0)8400-10046
>> Cell +41 (0) 79 571 36 27
>> info@xxxxxxxx
>> http://www.10046.ch
>>
>> =========================
>>
>> On Fri, Oct 15, 2010 at 9:21 PM, Chuck Boddy <
>> Chuck.Boddy@xxxxxxxxxxxxxxx> wrote:
>>
>> vSnapshotList(1) := “TABLE1”;
>>
>>
>>
>
>
Other related posts:
