analyze system generated LOB index in procedure
- From: Rich <richa03@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 3 Aug 2009 10:45:09 -0700
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:
