表空间 oracle

--create table
create table table_name (
    column1 varchar2(20) not null,
    column2 number(8)    not null,
    column3 date,
    column4 char
)
--define space
tablespace    base_data
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
        initial   64K,
        next    1M,
        minextents    1,
        maxextents     unlimited
);
--add comment
comment on column to table_name.column1 
is 'this is the column comment';
...
posted @ 2017-09-12 11:44  言非言  阅读(115)  评论(0编辑  收藏  举报