Index reverse keyword not show in the sql script ON table when the primary key has indexed reverse

redgeo1

Member
I found a plsql developer 10.0.3 bug?: Table->View->View SQL button: Index reverse keyword not show in the sql script ON table when the table primary key has indexed reverse mode
(Database: oracle 11.2)
 
I send the script below: (the view "Index" sheet show the reverse key, but the generated sql text not)

-- Create table
create table test_table01
(
pkey1 NUMBER(14) not null,
state varchar2(10),
sys5 date
)
partition by range (SYS5)
(
partition PREGI values less than (TO_DATE(' 2013-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace TTTT
pctfree 0
initrans 1
maxtrans 255
storage
(
initial 8M
next 1M
minextents 1
maxextents unlimited
),
partition SYS_P5452 values less than (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace TTTT
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 8M
next 1M
minextents 1
maxextents unlimited
),
partition SYS_P5453 values less than (TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace TTTT
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 8M
next 1M
minextents 1
maxextents unlimited
)
);
-- Add comments to the columns
comment on column test_table01.pkey1
is 'primary key';
comment on column test_table01.sys5
is 'create date';

-- Create/Recreate indexes
create index test_table01_state_i on test_table01 (state)
tablespace TTTT
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
)
compress;

-- Create/Recreate primary, unique and foreign key constraints
alter table test_table01
add constraint pkey1_pk primary key (pkey1)
using index
tablespace TTTT
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
)
reverse;

-- Create/Recreate check constraints
alter table test_table01
add constraint test_table01_check_const
check (state IN ('0', '1', '2'));
 
Back
Top