Query Error

I'm trying to use DBMS_METADATA to get the DDL:

SELECT TO_CHAR(DBMS_METADATA.GET_DDL('TABLE', o.name,'DATA_HOLDER')) ddl_string

FROM       sys.obj$ o,sys.tab$ t
WHERE      o.owner# = 28
  AND      o.obj# = t.obj#
  AND      BITAND(o.flags, 128) = 0;

ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4747, maximum: 4000)

I cannot seem to get around that error no matter what I try. Any suggestions?

Thanks! Received on Fri Apr 01 2011 - 14:04:43 CDT