Hi Roman,
Thanks for your answer. I'd like to know is index on this column necessary?
If I don't need to worry search for now, is there any other known issues
related to
the difference of Oracle's varchar2 and CLOB type?
regards,
Jun
Roman Novak <[EMAIL PROTECTED]> wrote:
Hi,
I thought about that too somewhen. Indexing the CLOB will be an issue. Formally
you need the "Context Option", which basically will mean that it will be a
"Domain Index" suitable for fulltext search.
If you try to index that type of column you get an ORA-02327 (cannot create
index ...).
The workaround was to alter the table and extend the column to varchar2(4000)
(this apparently didn't find the way into beta 2. I remember a hotfix a while
ago).
Good luck
Am Fr 19.11.2004 08:25, Gao Jun schrieb:
> Hi,
>
> Has anybody tried to using Oracle's CLOB for properties table's
> property_value column,
> instead of the original VARCHAR2(255)? We are trying to do this right now.
> Although
> it can pass the basic test cases, we are still not sure whether this is a
> reliable solution.
> Could anyone share your experience with us? Thanks.
>
> regards,
>
> Jun
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Meet the all-new My Yahoo! ?Try it today!
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Do you Yahoo!?
The all-new My Yahoo! � Get yours free!
