이름 변경 문법

alter table info rename constraints pk_info to pk_info_old;
alter index pk_info rename to pk_info_old;
alter table info rename to info_old;

LOB 생성 문법

create table info
(
id varchar2(40) not null,
pid varchar2(40) not null,
type varchar2(2) not null,
desc varchar2(200),
value clob,
creator varchar2(20) not null,
created date default sysdate not null,
updater varchar2(20) not null,
updated date default sysdate not null
)
tablespace tblspace
pctused 40
pctfree 10
lob (domain_prop_value) store as (
index lx_info_01 (tablespace idxspace)
tablespace tblspace
);