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!

Alter table COLUMN_ID??

OracleNewbie828Jul 2 2010 — edited Jul 2 2010

Oracle 10gR2 on Win2k3

Is it possible to change the column_id for a table without dropping the table or creating view?
Example Current table Structure:
FNAME, MNAME, LNAME

Need to change it to:
LNAME, FNAME, MNAME

I can see the corresponding COLUMN_ID for that table (FNAME, MNAME, LNAME) as 1,2,3 respectively. Is it possible to change the COLUMN_ID for that table (FNAME, MNAME, LNAME) to 2,3,1??

I have tried

SQL>alter dba_tab_columns set column_id=1 where table_name='xxx' and column_id=4;

thinking that maybe I need to change 1 to 4 since 4 is not used and then 3 to 1 and so on and so forth. Did not work.

Can I change the COLUMN_ID?? If so, how do I do it?

Thanks.

Edited by: OracleNewbie828 on Jul 2, 2010 9:56 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2010

Added on Jul 2 2010

#general-database-discussions

8 comments

5,769 views