Re: ORA-28579 during Intermedia indexing

From: Andreas Jung <ajung_at_sz-sb.de>
Date: Fri, 14 Jul 2000 10:35:49 +0200
Message-Id: <10558.112026@fatcity.com>

On Thu, Jul 13, 2000 at 09:06:39AM -0800, MacGregor, Ian A. wrote:
> Have you verified that your external procedure listener is working? There
> is a sample external procedure demo program
> at $ORACLE_HOME/plsql/demo which can be used to do this.

The listener is working as it should here it creation procedure for the indexes:

drop index tedalert.ojs_de_idx01 force;
drop index tedalert.ojs_de_lob_idx01 force;

Logging starten
Section Group exec ctx_ddl.drop_section_group('mygroup'); exec ctx_ddl.create_section_group('mygroup','xml_section_group'); exec ctx_ddl.add_field_section('mygroup','tidoc','tidoc',TRUE); exec ctx_ddl.add_field_section('mygroup','originalcpv','originalcpv',TRUE); exec ctx_ddl.add_field_section('mygroup','contractaim','contractaim',TRUE); exec ctx_ddl.add_field_section('mygroup','contractaim','contractaim2',TRUE); exec ctx_ddl.add_field_section('mygroup','addr','addr',TRUE); exec ctx_ddl.add_field_section('mygroup','winner','winner',TRUE);

exec ctx_ddl.drop_preference('de_store')
exec ctx_ddl.create_preference('de_store','BASIC_STORAGE')
exec ctx_ddl.set_attribute('de_store','I_TABLE_CLAUSE','tablespace ojs_de_idx storage (initial 10M next 10M pctincrease 0)')
exec ctx_ddl.set_attribute('de_store','R_TABLE_CLAUSE','tablespace ojs_de_idx storage (initial 10M next 10M pctincrease 0)')
exec ctx_ddl.set_attribute('de_store','I_INDEX_CLAUSE','tablespace ojs_de_idx storage (initial 10M next 10M pctincrease 0)')

exec ctx_ddl.drop_preference('de_lob_store')
exec ctx_ddl.create_preference('de_lob_store','BASIC_STORAGE')
exec ctx_ddl.set_attribute('de_lob_store','I_TABLE_CLAUSE','tablespace ojs_de_idx storage (initial 10M next 10M pctincrease 0)')

exec ctx_ddl.set_attribute('de_lob_store','R_TABLE_CLAUSE','tablespace ojs_de_idx storage (initial 10M next 10M pctincrease 0)') exec ctx_ddl.set_attribute('de_lob_store','I_INDEX_CLAUSE','tablespace ojs_de_idx storage (initial 10M next 10M pctincrease 0)')

Index anlegen

exec ctx_output.start_log('ctx_ojs_de.log');

create index tedalert.ojs_de_idx01 on tedalert.ojs_de(inhalt)

	indextype is ctxsys.context parameters('section group mygroup storage de_store')
	parallel 2; 

create index tedalert.ojs_de_lob_idx01  on tedalert.ojs_de(inhalt_lob) 
	indextype is ctxsys.context parameters('section group mygroup storage de_lob_store')

Received on Fri Jul 14 2000 - 03:35:49 CDT