Re: analyze system generated LOB index in procedure

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Mon, 3 Aug 2009 20:07:41 +0200
Message-ID: <486b2b610908031107m5c644465s6929083b3ad800c4_at_mail.gmail.com>



Escape the $ signs in the index name

Stefan


Stefan P Knecht
CEO & Founder
s_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch


On Mon, Aug 3, 2009 at 7:45 PM, Rich <richa03_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 03 2009 - 13:07:41 CDT

Original text of this message