RE: Intermedia Questions, Any Gurus on This Subject?
There is a wealth of docs regarding this issue in OTN also check http://www.oracle.com/products/intermedia -Original Message- From: Oracle DBA [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 15:11 To: Multiple recipients of list ORACLE-L Subject: Intermedia Questions, Any Gurus on This Subject? Help anybody, version 8.1.6.3 on UNIX 1. Storage clause of an intermedia index build. How to specify the buffer pool to KEEP or CACHE the index? 2. How to specify the tablespace for such a DOMAIN index. When put in tablespace clause, says its invalid option for domain index. Thanx = Vicky D. Foster, Oracle DBA email: [EMAIL PROTECTED] __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hatzistavrou Giannis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Intermedia Questions, Any Gurus on This Subject?
Title: RE: Intermedia Questions, Any Gurus on This Subject?
Hi Vicky,
You need to create a preference to define the storage clause with CTX_DDL. I did this at a former employer and I don't have the scripts handy, sorry to say. The documentation does go over this in detail. You can specify just about everything for storage of your imt index in the preference. You can even put the separate pieces of the index in separate ts's. Buffer pool though, I'm not sure. See below a cutout from the doco.
Specifying Storage Attributes
The following examples specify that the index tables are to be created in the foo tablespace with an initial extent of 1K:
begin
ctx_ddl.create_preference('mystore', 'BASIC_STORAGE');
ctx_ddl.set_attribute('mystore', 'I_TABLE_CLAUSE',
'tablespace foo storage (initial 1K)');
ctx_ddl.set_attribute('mystore', 'K_TABLE_CLAUSE',
'tablespace foo storage (initial 1K)');
ctx_ddl.set_attribute('mystore', 'R_TABLE_CLAUSE',
'tablespace foo storage (initial 1K)');
ctx_ddl.set_attribute('mystore', 'N_TABLE_CLAUSE',
'tablespace foo storage (initial 1K)');
ctx_ddl.set_attribute('mystore', 'I_INDEX_CLAUSE',
'tablespace foo storage (initial 1K)');
end;
HTH
Lisa Koivu
Oracle Database Administrator
954-935-4117
The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful.
The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments.
-Original Message-
From: Oracle DBA [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 9:11 AM
To: Multiple recipients of list ORACLE-L
Subject: Intermedia Questions, Any Gurus on This Subject?
Help anybody, version 8.1.6.3 on UNIX
1. Storage clause of an intermedia index build. How
to specify the buffer pool to KEEP or CACHE the index?
2. How to specify the tablespace for such a DOMAIN
index. When put in tablespace clause, says its invalid
option for domain index.
Thanx
=
Vicky D. Foster,
Oracle DBA
email: [EMAIL PROTECTED]
__
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Oracle DBA
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Intermedia Questions, Any Gurus on This Subject?
You need to create preferences to specify storage parameters like:
begin
ctx_ddl.create_preference('storage_small','BASIC_STORAGE');
ctx_ddl.set_attribute('storage_small','I_TABLE_CLAUSE','tablespace
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','K_TABLE_CLAUSE','tablespace
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','R_TABLE_CLAUSE','tablespace
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','N_TABLE_CLAUSE','tablespace
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','I_INDEX_CLAUSE','tablespace
LOBADM_01_SMALL_INDX');
ctx_ddl.set_attribute('storage_small','P_TABLE_CLAUSE','tablespace
LOBADM_01_SMALL_DATA');
end;
/
Then create index like:
create index lobadm.client_full_nm_indx on lobadm.client(full_nm)
indextype is ctxsys.context
parameters('storage lobadm.storage_small')
/
Hope this helps
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike J Kurth
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
