We have a table on PostgreSQL 9.3 and we migrate it (data & structure) to Oracle 126.96.36.199. Here is our table:
create table cstb_temp_log ( id NUMBER PRIMARY KEY, log_info data_type(max_length) -- max_length < 10000 ) -- log_info : data is inserted/updated every second (**) -- data_type: may be we can use "clob" because max_length of varchar2 in Oracle is 4000 (SQL). -- cstb_temp_log : size = 1 GB, row = 400000
We want to index and search "text" on log_info column, so we tried Oracle Text 11g .
If we use "data_type" is "clob", we can use "context index" and it have to synchronize after DML . ( we can not use this way because of (**) )
If any, how can we index and search on "log_info" column (max_length < 10000 and data is changed every second) ?