Re: analyze system generated LOB index in procedure
- From: Rich <richa03@xxxxxxxxx>
- To: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- Date: Mon, 3 Aug 2009 12:13:26 -0700
Thanks,Stefan - works
It's a Monday :)
On Mon, Aug 3, 2009 at 11:07 AM, Stefan Knecht <knecht.stefan@xxxxxxxxx>wrote:
> Escape the $ signs in the index name
>
> 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 Mon, Aug 3, 2009 at 7:45 PM, Rich <richa03@xxxxxxxxx> wrote:
>
>> Hi list,
>>
>> 64-bit 10.2.0.4 on RHEL 5.1
>>
>> Anyone know a reason why this OS script will not find the index:
>> $ORACLE_HOME/bin/sqlplus -s `/home/oracle/<OWNER>` <<EOF
>>
>> begin
>> execute immediate 'analyze index <OWNER>.<SYSTEM_GENERATED_LOB_INDEX_NAME>
>> validate structure';
>> end;
>>
>> /
>>
>> exit;
>> EOF
>>
>>
>> It throws:
>> ERROR at line 1:
>> ORA-01418: specified index does not exist
>> ORA-06512: at line 2
>>
>> Same error stack if connected as sysdba.
>>
>> The index does exist - from dba_lobs.
>>
>> However, using the same system generated LOB index name at a SQL*Plus
>> prompt [logged in as the owner] works.
>>
>> Lastly, with a named LOB index (non-system generated), the procedure will
>> work.
>>
>> Any help is appreciated,
>> Rich
>>
>
>
Other related posts:
