Re: Error when changing tablespace for a blob column

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<40948c72$0$13069$636a15ce_at_news.free.fr>...
> "Prem K Mehrotra" <premmehrotra_at_hotmail.com> a écrit dans le message de
> news:43441e77.0405011630.32ad983_at_posting.google.com...
> > I changed data type of a lomg raw column to blob and I wnated to place blob
> > column to a tablespace of its own. I use following statements:
> > alter table LTR_BODY modify (LTR_BODY_TXT BLOB);
> > alter table LTR_BODY move
> > lob (LTR_BODY_TXT) store as
> > (tablspace s_pqms_blob);
> > SQL> SQL> SQL> SQL> SQL>
> > Table altered.
> > SQL> 2 3 (tablspace s_pqms_blob)
> > *
> > ERROR at line 3:
> > ORA-22853: invalid LOB storage option specification
> > I don't see any thing wrong in my syntax and tablespace S_PQMS_BLOB does exist
> > in
> > the database.
> >
> > I have tried many other combinations but somehow all of them error with ORA 22853.
> >
> > If I create a brand new table using create table them things work fine.
>
> Maybe an e is missing at tablespace.
>
> Regards
> Michel Cadot

Nichel:

That was it. After staring it for so long, I could not see the type.

Prem Received on Mon May 03 2004 - 14:34:02 CDT