<div>
<div class="content wysiwyg-content">
This is in reference to my previous question on changing an varchar2 column to CLOB.<br />
<a href="https://www.experts-exchange.com/questions/28524807/Clarification-on-CLOB-column.html" rel="ugc">https://www.experts-exchange.com/questions/28524807/Clarification-on-CLOB-column.html</a><br />
<br />
The requirement has changed a bit and i have been asked to make the change without <br />
adding the new column . They have asked to use dbms_redifinition package to do so.<br />
Iam not too sure about it , any help in this regard is really appreciated.<br />
<br />
I need to modify the column comments to clob. currently it is in users_tab tablespace , I need to move it to <br />
user_lob tablespace. This needs to be done using DBMS_REDEFINITION package.<br />
<br />
Any help is really appreciated.
</div>
</div>


This is in reference to my previous question on changing an varchar2 column to CLOB.
http://www.experts-exchange.com/Database/Oracle/Q_28524807.html

The requirement has changed a bit and i have been asked to make the change without 
adding the new column . They have asked to use dbms_redifinition package to do so.
Iam not too sure about it , any help in this regard is really appreciated.

I need to modify the column comments to clob. currently it is in users_tab tablespace , I need to move it to 
user_lob tablespace. This needs to be done using DBMS_REDEFINITION package.

Any help is really appreciated.

need help on dbms_redefinition package

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.