Re: Dbms_metadata experts?
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 18 Mar 2015 12:05:47 -0500
Message-Id: <81A06581-901C-45A1-BAA1-2063964C9580_at_gmail.com>
That should read dbms_redefinition, not dbms_metadata.
>> On Mar 18, 2015, at 11:47 AM, Stefan Knecht <knecht.stefan_at_gmail.com> 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_at_DEV > create table t (x char(10));
>>
>> Table created.
>>
>> SYS_at_DEV > alter table t modify ( x varchar2(10));
>>
>> Table altered.
>>
>> Stefan
>>
>>
>>
Date: Wed, 18 Mar 2015 12:05:47 -0500
Message-Id: <81A06581-901C-45A1-BAA1-2063964C9580_at_gmail.com>
That should read dbms_redefinition, not dbms_metadata.
Sent from my iPad
> On Mar 18, 2015, at 12:03 PM, Andrew Kerber <andrew.kerber_at_gmail.com> 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_at_gmail.com> 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_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-lReceived on Wed Mar 18 2015 - 18:05:47 CET