Change column order without drop table
chijarOct 9 2008 — edited Oct 9 2008Dear all.
Are there some way to change the table columns order without drop and create table again ???
I mean i have :
TABLE1
campo1 number PK,
campo2 integer
campo3 varchar2(2)
and i want to move
TABLE1
campo1 number PK
campo3 varchar2(2)
campo2 integer
Thanks a lot !!!
cesar.
Oracle 10g R2 standard edition
RHEL AS 32 bits.