That should read dbms_redefinition, not dbms_metadata. Sent from my iPad > On Mar 18, 2015, at 12:03 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote: > > Stefan - the issue is the table locking and downtime. We have to use > dbms_metadata to minimize downtime, not due to the type of change. The tables > involved are too large and busy to make the change using alter table in our > small window. > > Sent from my iPad > >> On Mar 18, 2015, at 11:47 AM, Stefan Knecht <knecht.stefan@xxxxxxxxx> wrote: >> >> Andrew >> >> If that's the only change you need to do - change char() to varchar2() - you >> won't need to bother with dbms_metadata nor dbms_redefinition: >> >> >> SYS@DEV > create table t (x char(10)); >> >> Table created. >> >> SYS@DEV > alter table t modify ( x varchar2(10)); >> >> Table altered. >> >> Stefan >> >> >>> On Wed, Mar 18, 2015 at 11:42 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx> >>> wrote: >>> Ok. I am looking to find help with dbms_metadata. This may not be >>> possible, but I have a bunch of tables I need to change the layout on with >>> dbms_redefinition. I need to change all the char data types to varchar2. Is >>> there any way to set a transformation in dbms_metadata to do that >>> transformation as the DDL is generated for the interim table? >>> >>> Sent from my iPad-- >>> //www.freelists.org/webpage/oracle-l >>