Re: Dbms_metadata experts?
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: Steve Harville <steve.harville@xxxxxxxxx>
- Date: Wed, 18 Mar 2015 13:33:24 -0500
I also want to change the table name slightly if possible, I have a bunch of
tables to change. The more code I can generate the better.
Sent from my iPad
> On Mar 18, 2015, at 1:15 PM, Steve Harville <steve.harville@xxxxxxxxx> wrote:
>
> I'm interested in this too if you find what you are looking for.
>
>> On Wed, Mar 18, 2015 at 1:57 PM Andrew Kerber <andrew.kerber@xxxxxxxxx>
>> wrote:
>> Well, it does look I can use the replace function on the get_ddl call. That
>> works, but just doesn't seem very neat to me. Does anyone know of a way to
>> do this using the functionality of the dbms_metadata package? Or maybe I am
>> just being a little OCD. :)
>>
>> 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
>>>>
>>>>
>>>
Other related posts:
