Hi Jun, - The db-schema scripts don't define an index on that column. - Possibly a change from varchar2(255) to varchar2(4000) will be sufficient for you (see latest changes also here -> http://www.mail-archive.com/[email protected]/msg12926.html) - Versioning and other things (possibly many users assigned to a role) create large entries in the column property_value of the table PROPERTIES (another URL: http://www.mail-archive.com/[email protected]/msg11754.html)
If i remember right there were discussions about storing group-sets values in a more "relational" manner. So i am using the varchar2(4000) setting atm and not CLOB. The mentioned (theoretical) indexing issues was the only thing that came to mind immediately. I didn't make thorough tests running with a CLOB, so i can share experiences there. I am curious myself, if using a CLOB for that column would be the final solution for this issue. Roman Am Fr 19.11.2004 10:02, Gao Jun <[EMAIL PROTECTED]> schrieb: > 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! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
