Alter CLOB Storage- URGENT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Alter CLOB Storage- URGENT

  1. #1
    Join Date
    Dec 2000
    Posts
    3
    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.


  2. #2
    Join Date
    Jun 2000
    Posts
    417
    Check out [url]http://technet.oracle.com/doc/oracle8i_816/server.816/a76989/ch4d2.htm#37749[/url]

    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.

  3. #3
    Join Date
    Dec 2000
    Posts
    3
    [QUOTE][i]Originally posted by pwoneill [/i]
    [B]Check out [url]http://technet.oracle.com/doc/oracle8i_816/server.816/a76989/ch4d2.htm#37749[/url]

    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. [/B][/QUOTE]

    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.

  4. #4
    Join Date
    Jun 2000
    Posts
    417
    Did you read through the documentation?

    The command works like this

    alter table table_name <i>modify_storage_clause</i>

    where modify_storage_clause is in your case, modify_lob_storage_clause. this is

    modify lob (lob_item) ( <i>modify_lob_storage_parameters</i> )

    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 <i>lob_storage_clause</i> 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width