Re: exp/imp: able to change column order?

Chuck Hamilton wrote:
>
> A co-worker tells me he used to use the exp/imp utilities to change
> the order of columns in a table. I know of no option to do this. I've
> only been working with Oracle since version 7.0. Was this an option in
> earlier versions that was removed in version 7?
> --
> Chuck Hamilton
> chuckh_at_dvol.com
>
> This message delivered by electronic sled dogs. WOOF!

Chuck,
I think your co-worker left out a little step. You have to export the table, drop it and recreate it with the column order you want, then re-import it. Alternatively you could just copy the table to another table and acconmplish the same thing with the copy command or regular SQL to do the copy.

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.