Intermedia Indexes being rebuilt

From: <todd_at_cardinalgroup.com>
Date: 2000/05/03
Message-ID: <8ep9a4$svs$1@nnrp1.deja.com>#1/1

Does anyone know if the Intermedia Indexes are rebuilt automatically to include new additions to the database and if so what is the frequency of updating? Is this a paramter that can be set?

We need to have new additions available for searching within a short period of time of being added to the database. We are trying to create a workaround since it doesn't appear to be rebuilding frequently if at all. Here is a pl/sql procedure we are trying to use. The package is created without issue but it raises errors when executed...

Any ideas or assistance would be much appreciated.

Thanks

create or replace package intermediaIndexes is

        procedure rebuildSherlock;
end;
/

show errors;

create or replace package body intermediaIndexes is

	procedure rebuildSherlock is
		v_sync varchar2(5) := 'sync';
		v_alter varchar2 (500);
		v_dummy INTEGER;
		v_Cursor1	INTEGER;

	BEGIN
		v_alter := 'alter index indx_sherlock  REBUILD  online

parameters ('''||v_sync||''')';

		DBMS_OUTPUT.PUT_LINE  ( v_alter ) ;
		DBMS_SQL.PARSE(v_Cursor1, v_alter,DBMS_SQL.NATIVE);
		v_dummy := DBMS_SQL.EXECUTE (v_Cursor1);
		DBMS_OUTPUT.PUT_LINE ('HELLO');
	end;

END;
/

show errors;

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 03 2000 - 00:00:00 CDT