Unable to Modify Index Storage Attributes in 6.0.4.906

[darryl_staflund]

Hi there,

I created 3 elementary tables this morning but find that although I was able to modify the index storage attributes of the tables earlier this morning, I am no longer able to do so -- even when I restart the application.

When I edit the table and go to the index tab, I can modify every field except 'Storage'. The '...' button at the end of the field does not appear, and short of dropping and re-creating the table, I am not sure what do do.

One of my table definitions is as follows.

Sincerely,
Darryl Staflund

-- Create table
create table TBL_SHOW_CATEGORY_PROXY
(
TSCP_ID NUMBER(9) not null,
TSCP_TSP_ID NUMBER(9) not null,
TSCP_TCTP_ID NUMBER(9) not null,
TSCP_TSCP_ID NUMBER(9),
TSCP_CREATE_NAME VARCHAR2(30) default user not null,
TSCP_CREATE_DATETIME DATE default sysdate not null,
TSCP_UPDATE_NAME VARCHAR2(30) default user not null,
TSCP_UPDATE_DATETIME DATE default sysdate not null
)
tablespace DYNAMIC_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column TBL_SHOW_CATEGORY_PROXY.TSCP_ID
is 'Primary Key.';
comment on column TBL_SHOW_CATEGORY_PROXY.TSCP_TSP_ID
is 'FK to CATEGORYMANAGER.TBL_SHOW_PROXY';
comment on column TBL_SHOW_CATEGORY_PROXY.TSCP_TCTP_ID
is 'FK to CATEGORYMANAGER.TBL_CATEGORY_TYPE_PROXY';
comment on column TBL_SHOW_CATEGORY_PROXY.TSCP_TSCP_ID
is 'FK to parent category for this asset.';
comment on column TBL_SHOW_CATEGORY_PROXY.TSCP_CREATE_NAME
is 'Audit information.';
comment on column TBL_SHOW_CATEGORY_PROXY.TSCP_CREATE_DATETIME
is 'Audit information.';
comment on column TBL_SHOW_CATEGORY_PROXY.TSCP_UPDATE_NAME
is 'Audit information.';
comment on column TBL_SHOW_CATEGORY_PROXY.TSCP_UPDATE_DATETIME
is 'Audit information.';
-- Create/Recreate primary, unique and foreign key constraints
alter table TBL_SHOW_CATEGORY_PROXY
add constraint PK_TSCP_ID primary key (TSCP_ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table TBL_SHOW_CATEGORY_PROXY
add constraint FK_TSCP_TCTP_ID foreign key (TSCP_TCTP_ID)
references TBL_CATEGORY_TYPE_PROXY (TCTP_ID);
alter table TBL_SHOW_CATEGORY_PROXY
add constraint FK_TSCP_TSCP_ID foreign key (TSCP_TSCP_ID)
references TBL_SHOW_CATEGORY_PROXY (TSCP_ID);
alter table TBL_SHOW_CATEGORY_PROXY
add constraint FK_TSCP_TSP_ID foreign key (TSCP_TSP_ID)
references TBL_SHOW_PROXY (TSP_ID);
-- Create/Recreate check constraints
alter table TBL_SHOW_CATEGORY_PROXY
add constraint CK_TSCP_ID
check (tscp_id > 0);
alter table TBL_SHOW_CATEGORY_PROXY
add constraint CK_TSCP_TCTP_ID
check (tscp_tctp_id > 0);
alter table TBL_SHOW_CATEGORY_PROXY
add constraint CK_TSCP_TSCP_ID_1
check (tscp_tscp_id > 0);
alter table TBL_SHOW_CATEGORY_PROXY
add constraint CK_TSCP_TSCP_ID_2
check (tscp_tscp_id tscp_id);
alter table TBL_SHOW_CATEGORY_PROXY
add constraint CK_TSCP_TSP_ID
check (tscp_tsp_id > 0);
alter table TBL_SHOW_CATEGORY_PROXY
add constraint CK_TSCP_UPDATE_DATETIME
check (tscp_update_datetime >= tscp_create_datetime);
-- Create/Recreate indexes
create unique index UX_TSCP_ID_1 on TBL_SHOW_CATEGORY_PROXY (TSCP_ID, TSCP_TSP_ID, TSCP_TCTP_ID)
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create unique index UX_TSCP_ID_2 on TBL_SHOW_CATEGORY_PROXY (TSCP_ID, TSCP_TSCP_ID)
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

 

[Marco Kalter]

I think this can happen if the table definition editor window width is too small. If you move the scrollbar, the [..] buttons do not appear. If you make the window wider, it should be fixed though.