Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle oledb bug?
All,
I am encountering an issue with gathering stats from an OLEDB
connection when the stats to be gathered include a composite index. I
receive the ambiguous " OraOLEDB: ORA-03113: end-of-file on
communication channel" from the calling program and even if my
anonymous block has an exception handler it is never fired. Below is a
simple vbs script to replicate the problem. I am running Oracle9i
Enterprise Edition Release 9.2.0.6.0 on Win2k with ADO v2.8 but have
replicated this using several other configurations/platforms.
Set db = CreateObject("ADODB.Connection") db.open "Provider=OraOLEDB.Oracle;User Id=system;Password=manager;Data Source="
db.execute "begin execute immediate 'create table teststats(a NUMBER, b NUMBER)'; end;"
db.execute "begin for x in 1..4000 loop insert into teststats values(x,x); end loop; end;"
'works fine with the following single column index
'db2.execute "begin execute immediate 'create index teststats_idx on
teststats(a)'; end ;"
'breaks with this composite index
db.execute "begin execute immediate 'create index teststats_idx on
teststats(a,b)'; end ;"
db.execute "begin DBMS_STATS.GATHER_TABLE_STATS( OWNNAME=>null, TABNAME=>'teststats', estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,
CASCADE=>true); end;"
db.execute "begin execute immediate 'drop table teststats'; end;" db.close Received on Tue Feb 21 2006 - 13:19:20 CST