Dear all,
On freshly new installed database (12.2.0.1.0) I configured MAX_STRING_SIZE=extended, following the standard procedure described here: Increasing the Maximum Size of VARCHAR2, NVARCHAR2, and RAW Columns in a CDB.
It seems that I that setting MAX_STRING_SIZE=extended was successful. The procedure produced the following logs:
$ ls -l utl32k_cdb_pdbs_output utlrp_cdb_pdbs_output
utl32k_cdb_pdbs_output:
total 28
-rw-rw-r--. 1 oracle oracle 12681 Jun 1 10:44 utl32k_cdb_pdbs_output0.log
-rw-rw-r--. 1 oracle oracle 4570 Jun 1 10:44 utl32k_cdb_pdbs_output1.log
-rw-rw-r--. 1 oracle oracle 457 Jun 1 10:43 utl32k_cdb_pdbs_output_catcon_16444.lst
utlrp_cdb_pdbs_output:
total 28
-rw-rw-r--. 1 oracle oracle 14210 Jun 1 10:49 utlrp_cdb_pdbs_output0.log
-rw-rw-r--. 1 oracle oracle 5080 Jun 1 10:49 utlrp_cdb_pdbs_output1.log
-rw-rw-r--. 1 oracle oracle 453 Jun 1 10:47 utlrp_cdb_pdbs_output_catcon_17442.lst
When I try to create a text index on table with a varchar(4000) I get the following error:
SQL> CREATE TABLE test_table(col_vc VARCHAR(4000));
Table created.
SQL> CREATE INDEX test_index ON test_table(col_vc) INDEXTYPE IS CTXSYS.CONTEXT;
CREATE INDEX test_index ON test_table(col_vc) INDEXTYPE IS CTXSYS.CONTEXT
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvxtab.create_index_tables
ORA-43929: Collation cannot be specified if parameter MAX_STRING_SIZE=STANDARD
is set.
ORA-06512: at "CTXSYS.DRUE", line 171
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 316
Does anyone have an idea of what is going on?
Thank you
Fred