Skip to Main Content

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2008
Added on Oct 9 2008
8 comments
3,529 views