Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reorder columns?
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