Re: LOBs and XMLTYPEs and NOLOGGING and NOCACHE
- From: "David Barbour" <david.barbour1@xxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxx
- Date: Mon, 15 Dec 2008 16:01:46 -0500
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@xxxxxxxxxxxx>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@xxxxxxxxxxxx <mark.bobak@xxxxxxxxxxxxxxx>
> www.proquest.com
> www.csa.com
>
> *ProQuest...*Start here.
>
>
>
Other related posts:
