Andy Hassall wrote:
> On Mon, 27 Jun 2005 07:49:47 GMT, "Ach C via DBMonster.com"
> <forum_at_DBMonster.com> wrote:
>
>
>>In fact I have two questions! :D
>>1.How to change a columns data type without making that column empty?
>>2.How to change the order of columns in a table?
>>for the 2nd one,I know I can create a new table and do "select into" and...
>>but I am curious about another way! ;)
>
>
> Another option on all (supported) versions of Oracle is DBMS_REDEFINITION.
> It's more complicated to use, but you may be able to reduce downtime if you
> really do have to perform this operation.
A demo of DBMS_REDEFINITION can be found at www.psoug.org.
click on Morgan's Library and scroll down.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Jun 27 2005 - 18:58:28 CDT
