RE: INTERMEDIA INDEXES on snapshot
- From: "MacGregor, Ian A." <ian@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 15 Jun 2004 10:04:34 -0700
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@xxxxxxxxxxxxxxxxx
-----Original Message-----
From: Seema Singh [mailto:oracledbam@xxxxxxxxxxx]
Sent: Tuesday, June 15, 2004 8:41 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx put 'unsubscribe'
in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
