{データベースの作成その他}索引構成表を作成

 

https://docs.oracle.com/cd/F19136_01/admin/managing-tables.html#GUID-D9BCA9BF-EAA8-431D-BDBB-ED5B3C59C5E4


CREATE TABLE admin_docindex(
        token char(20), 
        doc_id NUMBER,
        token_frequency NUMBER,
        token_offsets VARCHAR2(2000),
        CONSTRAINT pk_admin_docindex PRIMARY KEY (token, doc_id))
    ORGANIZATION INDEX 
    TABLESPACE users
    PCTTHRESHOLD 20
    OVERFLOW TABLESPACE users;
    

col table_name for a20

select table_name,IOT_TYPE from user_tables;