scott@ORA92> CREATE TABLE MY_MASTER
  2    (ARTICLE_ID NUMBER PRIMARY KEY,
  3  	AUTHOR	   VARCHAR2(30),
  4  	TITLE	   VARCHAR2(50),
  5  	BODY	   CHAR(1))
  6  /

Table created.

scott@ORA92> CREATE TABLE MY_DETAIL
  2    (ARTICLE_ID NUMBER,
  3  	SEQ	   NUMBER,
  4  	TEXT	   CLOB)
  5  /

Table created.

scott@ORA92> ALTER TABLE MY_DETAIL
  2  ADD CONSTRAINT MY_DETAIL_FK
  3  FOREIGN KEY (ARTICLE_ID)
  4  REFERENCES MY_MASTER (ARTICLE_ID)
  5  /

Table altered.

scott@ORA92> BEGIN
  2    CTX_DDL.CREATE_PREFERENCE ('MY_DETAIL_PREF', 'DETAIL_DATASTORE');
  3    CTX_DDL.set_attribute ('MY_DETAIL_PREF', 'binary', 'true');
  4    CTX_DDL.set_attribute ('MY_DETAIL_PREF', 'detail_table', 'MY_DETAIL');
  5    CTX_DDL.set_attribute ('MY_DETAIL_PREF', 'detail_key', 'ARTICLE_ID');
  6    CTX_DDL.set_attribute ('MY_DETAIL_PREF', 'detail_lineno', 'SEQ');
  7    CTX_DDL.set_attribute ('MY_DETAIL_PREF', 'detail_text', 'TEXT');
  8  END;
  9  /

PL/SQL procedure successfully completed.

scott@ORA92> CREATE INDEX MASTER_DETAIL_INDEX
  2  ON MY_MASTER (BODY)
  3  INDEXTYPE IS CTXSYS.CONTEXT
  4  PARAMETERS ('DATASTORE MY_DETAIL_PREF')
  5  /

Index created.

scott@ORA92> INSERT INTO MY_MASTER
  2  VALUES (101, 'RISHI', 'DATASTORE', 'Y')
  3  /

1 row created.

scott@ORA92> INSERT INTO MY_MASTER
  2  VALUES (102, 'BARBARA', 'TEST', 'Y')
  3  /

1 row created.

scott@ORA92> INSERT INTO MY_DETAIL
  2  VALUES (101, '00002', 'The direct datastore')
  3  /

1 row created.

scott@ORA92> INSERT INTO MY_DETAIL
  2  VALUES (102, '00003', 'Something else ... whatever')
  3  /

1 row created.

scott@ORA92> COMMIT
  2  /

Commit complete.

scott@ORA92> EXEC ctx_ddl.sync_index ('MASTER_DETAIL_INDEX')

PL/SQL procedure successfully completed.

scott@ORA92> SELECT *
  2  FROM   my_master
  3  WHERE  CONTAINS (body, 'direct') > 0
  4  /

ARTICLE_ID AUTHOR                         TITLE                                              B
---------- ------------------------------ -------------------------------------------------- -
       101 RISHI                          DATASTORE                                          Y

scott@ORA92> SELECT *
  2  FROM   my_master
  3  WHERE  CONTAINS (body, 'something') > 0
  4  /

ARTICLE_ID AUTHOR                         TITLE                                              B
---------- ------------------------------ -------------------------------------------------- -
       102 BARBARA                        TEST                                               Y

scott@ORA92> 

drop table my_detail
/
drop table my_master
/
exec CTX_DDL.drop_PREFERENCE ('MY_DETAIL_PREF')
CREATE TABLE MY_MASTER 
  (ARTICLE_ID NUMBER PRIMARY KEY,
   AUTHOR     VARCHAR2(30),
   TITLE      VARCHAR2(50),
   BODY       CHAR(1))
/
CREATE TABLE MY_DETAIL 
  (ARTICLE_ID NUMBER,
   SEQ        NUMBER,
   TEXT       CLOB)
/
ALTER TABLE MY_DETAIL 
ADD CONSTRAINT MY_DETAIL_FK
FOREIGN KEY (ARTICLE_ID)
REFERENCES MY_MASTER (ARTICLE_ID)
/
BEGIN
  CTX_DDL.CREATE_PREFERENCE ('MY_DETAIL_PREF', 'DETAIL_DATASTORE');
  CTX_DDL.set_attribute ('MY_DETAIL_PREF', 'binary', 'true');
  CTX_DDL.set_attribute ('MY_DETAIL_PREF', 'detail_table', 'MY_DETAIL');
  CTX_DDL.set_attribute ('MY_DETAIL_PREF', 'detail_key', 'ARTICLE_ID');
  CTX_DDL.set_attribute ('MY_DETAIL_PREF', 'detail_lineno', 'SEQ');
  CTX_DDL.set_attribute ('MY_DETAIL_PREF', 'detail_text', 'TEXT');
END;
/
CREATE INDEX MASTER_DETAIL_INDEX 
ON MY_MASTER (BODY) 
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS ('DATASTORE MY_DETAIL_PREF')
/
INSERT INTO MY_MASTER 
VALUES (101, 'RISHI', 'DATASTORE', 'Y')
/
INSERT INTO MY_MASTER 
VALUES (102, 'BARBARA', 'TEST', 'Y')
/
INSERT INTO MY_DETAIL 
VALUES (101, '00002', 'The direct datastore')
/
INSERT INTO MY_DETAIL 
VALUES (102, '00003', 'Something else ... whatever')
/
COMMIT
/
EXEC ctx_ddl.sync_index ('MASTER_DETAIL_INDEX')
SELECT token_text 
FROM   dr$master_detail_index$i
/
SELECT *
FROM   my_master
WHERE  CONTAINS (body, 'direct') > 0
/
SELECT *
FROM   my_master
WHERE  CONTAINS (body, 'something') > 0
/