Re: Rearrange columns

From: sybrandb <sybrandb_at_gmail.com>
Date: 19 Jan 2007 02:41:54 -0800
Message-ID: <1169203313.953652.250420@q2g2000cwa.googlegroups.com>

On Jan 19, 11:14 am, MRCarver <mrcnewGr..._at_charter.net> wrote:
> What is the preferred way for rearranging columns in Oracle 10g XE. I
> can't seem to find a way to do this..
>
> Regards,
>
> A Oracle Newbie
> MR Carver

Column order is irrelevant as no one should code select * from foo
all over the place.
The preferred way is
- to *design* the database prior to implementing it, instead of hacking it together
- Put a view with the correct column order on top of the table, and use the view everywhere instead of the table.

other than that study the demo for the dbms_redefinition package in Morgan's library or in the Oracle database documentation.

Actually, Oracle shouldn't have made this available, as it will help people insist in their messy development procedures.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Fri Jan 19 2007 - 04:41:54 CST