• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

need help on dbms_redefinition package

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.
0
sam_2012
Asked:
sam_2012
2 Solutions
 
Wasim Akram ShaikCommented:
This should work,but unable to perform a test case to confirm

create an interim table which suits your data type needs(even specify the storage clause if you want the interim table to point different tablespace)  and use the  col_mapping mapping parameter in dbms_redefinition.start_redef_table

ie., you will not do any changes in the main table, you will modify the data types in your interim table and use column mappings with interim table

After this, sync the interim table with main table

An illustration of dbms_redefinition can be found here.
http://www.orafaq.com/node/4
0
 
MikeOM_DBACommented:
0
 
sam_2012Author Commented:
awesome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now