Re: Rearrange columns

MRCarver wrote:
> I was not LOOKING for a lecture on RDMS design philosophy. I am new to
> Oracle, but not new to RDMS design. Using SQL Server, Interbase,
> Paradox, all have simple means to manipulate the order of columns in a
> table, without having to recreate and mess with permission, etc.
>
> I was simply looking for the equivalent in Oracle. It seems that the
> Mighty Oracle provides NO facility to rearrange the column order.
>
> There is nothing wrong with keeping all my "plumbing fields" at the
> bottom of my tables. I simply realized I needed a new field, and did
> not want it confusing my plumbing tables. I don't own a high dollar
> CASE tool like Embarcedero's ERStudio, so please forgive me if I do my
> development in Oracle... Or should I use MS Visio ?
>
> Regards,
> Monte Carver

Oracle does provide the capability of doing it. That method is the DBMS_REDEFINITION built-in package. It has been been available since 9.0.1, 7 years ago.

If you want to see a demo of how to use the package go to: http://www.psoug.org/reference/dbms_redefinition.html

Why the statement "It seems that the Mighty Oracle provides NO facility to rearrange the column order." when it is clearly not the case?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org