RE: INTERMEDIA INDEXES on snapshot

From: MacGregor, Ian A. <ian_at_slac.stanford.edu>
Date: Tue, 15 Jun 2004 10:04:34 -0700
Message-ID: <26E3EC48949D134C94A1574B2C89466113A921@exchange2.slac.stanford.edu>

What is the data type of the column with the missing index? Long columns cannot be snapshot, but you can build your own snapshot log table and pl/sql procedure to accomplish it, provided the long is less than 32K. You can snapshot CLOBs, but if the snapshot has a context index, this will not work. What you need to do is to drop the context index on the snapshot, perform the refresh, and then re-establish the context index.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu

-----Original Message-----

From: Seema Singh [mailto:oracledbam_at_hotmail.com] Sent: Tuesday, June 15, 2004 8:41 AM
To: oracle-l_at_freelists.org
Subject: INTERMEDIA INDEXES on snapshot

Hi,
I have been getting following error on replication site.I have created intermedia indexes on replication site. Oracle EE 8163/sun solaris
Errors in file
/ora8/m01/app/oracle/admin/oraprod/bdump/oraprod_snp2_1428.trc:

ORA-12012: error on auto execute of job 1541
ORA-20000: interMedia Text error:
DRG-10502: index SITE_WIDE_INDEX_CTXIDX does not exist
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.CTX_DDL", line 1270
ORA-06512: at line 1

Thu Jun 10 15:17:59 2004

ANy thoughts?
thx-seema

Get fast, reliable Internet access with MSN 9 Dial-up - now 3 months FREE! http://join.msn.click-url.com/go/onm00200361ave/direct/01/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Jun 15 2004 - 12:01:53 CDT