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@(protected)
-- --Original Message-- --
From: Seema Singh [mailto:oracledbam@(protected)]
Sent: Tuesday, June 15, 2004 8:41 AM
To: oracle-l@(protected)
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 (See ORA-12012.ora-code.com): error on auto execute of job 1541
ORA-20000 (See ORA-20000.ora-code.com): interMedia Text error:
DRG-10502: index SITE_WIDE_INDEX_CTXIDX does not exist
ORA-06512 (See ORA-06512.ora-code.com): at "CTXSYS.DRUE ", line 126
ORA-06512 (See ORA-06512.ora-code.com): at "CTXSYS.CTX_DDL ", line 1270
ORA-06512 (See ORA-06512.ora-code.com): 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@(protected) 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
