Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error when changing tablespace for a blob column
"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
Received on Sun May 02 2004 - 00:50:55 CDT