I have tried to generate Oracle scripts using 9i and 10g DBMS definitions.
In all cases if a table has a cluster defined on a column whose data type is
varchar2, the generated definition fails to include the sizes of the
varchare, i.e. varchar2(8). I find these instances from the failures when
the create scripts run and if I correct them manually I the script is fine.

My question is how can I change the DBMS generation to include the size for
character data types? I believe it is in the definition of how the variable
%CLUSTERCOLUMNS% is built, but I cannot find where this is done. Help with
finding this and even better how to make the correction would be
appreciated.