Re: Change columns datatype and order

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Mon, 27 Jun 2005 20:18:00 +0100
Message-ID: <7qj0c11b47nqhh28h6ng37kejkfurlka7j@4ax.com>

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.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Received on Mon Jun 27 2005 - 14:18:00 CDT