APEX

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!

How to set primary key of a table to increment automatically?

DannyS-OracleAug 1 2016 — edited Aug 1 2016

Hi guys, I hope someone had encountered this problem before and can share a solution.

I tried to create a duplicate of my existing table, from "DC_Calendar_Admin" to "CVC_Admin". The whole copy process is working, CVC_Admin has the same structure and data, but its primary key is not set to be incremented automatically. The screenshot below shows that the "Default" attribute of column "ID" in the CVC_Admin table is not set, while the old table DC_Calendar_Admin is set.

Screen Shot 2016-08-01 at 12.01.37 PM.png

Screen Shot 2016-08-01 at 12.01.55 PM.png

So far I have no luck trying to find a way to set the Default attribute of CVC_Admin. Anyone have suggestion? Any help will be appreciated!

Btw, this is Apex v5.0.3, used as a service from Oracle. So I cannot access any files, since it is not installed in my computer.

This post has been answered by PMON on Aug 1 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2016

Added on Aug 1 2016

#apex, #apex-discussions, #oracle, #table

6 comments

1,280 views