I can create a primary key for a table and then reverse it with the command
alter index T_PK rebuild reverse online;
How can I create it reversed?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
The primary key index (including index parameters) can be specified with the
using index clause. You can include the
reversed specification there.
create table T(X number primary key using index (create unique index T_PK on T(X) reverse));