Hi list,
if I check my database there are some tables that I haven't seen before.
Does anybody know for what are AR0CHAR* tables used? For me it seems as
if they are related to the full text search option. But I can't find
any documentation.
ARS 7.0.1 (Server group)
Solaris 10
Oracle 10gR2 (RAC Cluster)
Below follow some sql statements..
Kind regards,
Albert
SQL> select table_name from user_tables where table_name like 'AR0%';
TABLE_NAME
------------------------------
AR0CHAR19
AR0CHAR20
AR0CHAR21
AR0CHAR22
AR0CHAR23
AR0CHAR24
AR0CHAR25
AR0CHAR26
AR0CHAR27
AR0CHAR28
AR0CHAR29
AR0CHAR30
AR0CHAR31
13 rows selected.
SQL> descr AR0CHAR19;
Name Null? Type
----------------------------------------------------- --------
----------------
--------------------
FVALUE
VARCHAR2(255)
WEIGHT NUMBER(15)
SQL> select weight, fvalue from ar0char19;
WEIGHT FVALUE
---------- ------------------------------------------------------------
86 00203956
86 00204113
86 00204142
...
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
