Re: Dbms_metadata experts?

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_at_DEV > create table t (x char(10));

Table created.

SYS_at_DEV > alter table t modify ( x varchar2(10));

Table altered.

Stefan

On Wed, Mar 18, 2015 at 11:42 PM, Andrew Kerber <andrew.kerber_at_gmail.com> 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--
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l