Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change column order without drop table

chijarOct 9 2008 — edited Oct 9 2008

Dear 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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 6 2008

Added on Oct 9 2008

#general-database-discussions, #order

8 comments

3,530 views