Error when changing tablespace for a blob column

[Prem K Mehrotra]

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.

[unknown]

Post by Prem K Mehrotra
I changed data type of a lomg raw column to blob and I wnated to place blob
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)
*
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

[Prem K Mehrotra]

Post by unknown

Post by Prem K Mehrotra
I changed data type of a lomg raw column to blob and I wnated to place blob
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)
*
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