Help! I find this syntax to be quite confusing and frustrating.....can someone offer me a clue here? This looks right to me, but doesn't work: $ sqlplus sgarapati/sgarapati SQL*Plus: Release 11.1.0.6.0 - Production on Mon Dec 15 14:41:22 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production SQL> desc sg_documents Name Null? Type ----------------------------------------- -------- ---------------------------- DOC_ID NUMBER(15) DOC_TEXT PUBLIC.XMLTYPE SQL> alter table sg_documents modify lob(doc_text.xmltype) (nocache nologging); alter table sg_documents modify lob(doc_text.xmltype) (nocache nologging) * ERROR at line 1: ORA-02337: not an object type column Shouldn't that work? Does anyone see what I'm doing wrong? All I'm trying to do here is change the XMLTYPE to be NOCACHE and NOLOGGING... AdvThanksance, -Mark -- Mark J. Bobak Senior Database Administrator, System & Product Technologies ProQuest 789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346 +1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com> ProQuest...Start here.