テーブル作成

SQL

prompt create table mun_hist_user_trade_opt
create table mun_hist_user_trade_opt (
user_trade_id CHAR(16) not null , -- 会員取引ＩＤ
manager_id VARCHAR2(12) not null , -- 更新者ID
constraint pk_mun_hist_user_trade_opt primary key ( user_trade_id )
using index tablespace MUN_TBLSP_INDX_HIST
storage
(
initial 1m
next 1m
minextents 1
maxextents unlimited
pctincrease 0
)
pctfree 10
)
storage
(
initial 1m
next 1m
minextents 1
maxextents unlimited
pctincrease 0
)
pctfree 10
pctused 30
tablespace MUN_TBLSP_DATA_HIST;

    • synonym

create public synonym mun_hist_user_trade_opt for mun_hist_user_trade_opt;
grant select,insert,update,delete on VP_SYS.mun_hist_user_trade_opt to VP_ROLE_APP;