SQL & PL/SQL

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!

System generated column names

sgudipudiJun 24 2013 — edited Jul 5 2013

Version - Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

I see some system generated column names(like SYS_C00009_13061211:44:57$,SYS_C00033_13061211:44:57$) in ALL_TAB_COLS view for a partitioned table, not sure how they got created in the first place and tabledoesn't have any virtual columns. Is it something if we drop a column from table and oracle trying to keep them in the dictionary? when i describe the table these "SYS_C00" columns are not showing.

I am trying to exchange the partition with staging (similar structure) table, but i end up with this error "

14097. 00000 - "column type or size mismatch in ALTER TABLE EXCHANGE PARTITION"

*Cause: The corresponding columns in the tables specified in the

ALTER TABLE EXCHANGE PARTITION are of different type or size

*Action: Ensure that the two tables have the same number of columns

with the same type and size."

Any suggestions would be appreciated.

Thanks,

This post has been answered by sgudipudi on Jul 5 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 2 2013

Added on Jun 24 2013

2 comments

1,900 views