Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reorder columns?

Re: Reorder columns?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Dec 2005 06:47:34 -0800
Message-ID: <1135003654.461269.162640@g43g2000cwa.googlegroups.com>


Harry, the simple answer is no, unless you want to re-create the table with the data in the new physical column order. Otherwise, new columns are added to the end of the row for existing tables.

You can rename the existing table, create the new table, use insert as select to repopulate the new version of the table from the old version, drop the existing indexes, rebuild the indexes on the new version, drop the triggers from the old version and add them to the new version. If there are FK to this table you will have to drop and recreate them also.

HTH -- Mark D Powell -- Received on Mon Dec 19 2005 - 08:47:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US