Re: analyze system generated LOB index in procedure
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: richa03@xxxxxxxxx
- Date: Mon, 3 Aug 2009 20:07:41 +0200
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:
