Alter CLOB Storage- URGENT

Hi,
I have a table with a column as CLOB.

I want to alter the table to introduce storage space for CLOB column.

I have tried the following Alter table script.

ALTER table (Table name)
MODIFY (Column name)
LOB(Column name)
Storage as ( TABLESPACE (Tablespace name))

I get the error as invalid ALTER TABLE Option pointing to LOB.

Check out http://technet.oracle.com/doc/oracle...h4d2.htm#37749

To modify a LOB you use

MODIFY LOB (lob item)
not
MODIFY (column name) LOB (column name)

The lob item is the column name.

Whenever you have a command syntax problem it's best and fastest to check technet's sql reference for your version of the database, you'll also learn more about it.

Quote:

---

Originally posted by pwoneill
Check out http://technet.oracle.com/doc/oracle...h4d2.htm#37749

To modify a LOB you use

MODIFY LOB (lob item)
not
MODIFY (column name) LOB (column name)

The lob item is the column name.

Whenever you have a command syntax problem it's best and fastest to check technet's sql reference for your version of the database, you'll also learn more about it.

---

I have tried the syatax as suggested by you.
ALTER TABLE (table)
MODIFY LOB(lob item)
STORE AS(tablespace);

I aam still getting the same error.

Did you read through the documentation?

The command works like this

alter table table_name modify_storage_clause

where modify_storage_clause is in your case, modify_lob_storage_clause. this is

modify lob (lob_item) ( modify_lob_storage_parameters )

modify_lob_storage_parameters is just your typical storage clause, or some extent allocation/deallocation, set caching, etc. None of the clauses allow you to use the lob_storage_clause which is the one you want to use.

It looks like if you want to modify the lob storage you can only doing it when adding it to the table, not modifying an existing one. Read through the docs and maybe you will find a way that I missed.