Re: LOBs and XMLTYPEs and NOLOGGING and NOCACHE

From: David Barbour <david.barbour1_at_gmail.com>
Date: Mon, 15 Dec 2008 16:01:46 -0500
Message-ID: <69eafc3f0812151301l5b2bbecbpabff95bfc706973e@mail.gmail.com>


Mark,

Just reference the column name:

alter table sg_documents modify lob(doc_text) (nocache nologging);

On Mon, Dec 15, 2008 at 2:43 PM, Bobak, Mark <Mark.Bobak_at_proquest.com>wrote:

> 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_at_proquest.com <mark.bobak_at_il.proquest.com>
> www.proquest.com
> www.csa.com
>
> *ProQuest...*Start here.
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 15 2008 - 15:01:46 CST

Original text of this message