after changing all the "string" over 4K to "clob", my XWiki is able to create all 31 tables in Oracle now. I can publish the ddl @ http://docs.google.com/View?docid=ddqbx4zp_12s75qxw Here are all the 31 tables: xwikiattachment xwikiattachment_archive xwikiattachment_content xwikibooleanclasses xwikiclasses xwikiclassesprop xwikicomments xwikidateclasses xwikidates xwikidblistclasses xwikidoc xwikidoubles xwikifloats xwikiintegers xwikilargestrings xwikilinks xwikilistitems xwikilists xwikilock xwikilongs xwikinumberclasses xwikiobjects xwikipreferences xwikiproperties xwikislistclasses xwikistatsdoc xwikistatsreferer xwikistatsvisit xwikistringclasses xwikistrings xwikiusers ______________________________ Some java error here: Hibernate: /* insert com.xpn.xwiki.doc.XWikiDocument */ insert into xwikidoc (XWD_FULLNAME, XWD_NAME, XWD_TITLE, XWD_LANGUAGE, XWD_DEFAULT_LANGUAGE, XWD_TRANSLATION, XWD_DATE, XWD_CONTENT_UPDATE_DATE, XWD_CREATION_DATE, XWD_AUTHOR, XWD_CONTENT_AUTHOR, XWD_CREATOR, XWD_WEB, XWD_CONTENT, XWD_VERSION, XWD_CUSTOM_CLASS, XWD_PARENT, XWD_CLASS_XML, XWD_ELEMENTS, XWD_DEFAULT_TEMPLATE, XWD_VALIDATION_SCRIPT, XWD_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.CalendarEvent ...... Wrapped Exception: java.lang.String at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:310) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:96) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:90) Wrapped Exception: java.lang.ClassCastException: java.lang.String at org.hibernate.type.ClobType.set(ClobType.java:50) at org.hibernate.type.ClobType.nullSafeSet(ClobType.java:118) at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1826) at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1803) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2059) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51) ...... Hibernate: /* insert com.xpn.xwiki.doc.XWikiDocument */ insert into xwikidoc (XWD_FULLNAME, XWD_NAME, XWD_TITLE, XWD_LANGUAGE, XWD_DEFAULT_LANGUAGE, XWD_TRANSLATION, XWD_DATE, XWD_CONTENT_UPDATE_DATE, XWD_CREATION_DATE, XWD_AUTHOR, XWD_CONTENT_AUTHOR, XWD_CREATOR, XWD_WEB, XWD_CONTENT, XWD_VERSION, XWD_CUSTOM_CLASS, XWD_PARENT, XWD_CLASS_XML, XWD_ELEMENTS, XWD_DEFAULT_TEMPLATE, XWD_VALIDATION_SCRIPT, XWD_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: java.lang.String at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:310) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:96) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:90) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:750) at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:2010)