建立新表
CREATE TABLE GDL.GDL_EVENTENGINE_ADMIN(
ID NUMBER NOT NULL PRIMARY KEY,
APPID VARCHAR(50) NOT NULL,
RELATION VARCHAR(50) NOT NULL,
EVENTTYPE VARCHAR(50) NOT NULL,
CREATETIME DATE NOT NULL,
UPDATETIME DATE NOT NULL
)
LOGGING
TABLESPACE GDL_DAT;
COMMENT ON COLUMN GDL_EVENTENGINE_ADMIN.ID IS '自增ID';
COMMENT ON COLUMN GDL_EVENTENGINE_ADMIN.APPID IS '事件生产消费方';
COMMENT ON COLUMN GDL_EVENTENGINE_ADMIN.RELATION IS '生产消费方和事件类型的关系';
COMMENT ON COLUMN GDL_EVENTENGINE_ADMIN.EVENTTYPE IS '事件类型';
COMMENT ON COLUMN GDL_EVENTENGINE_ADMIN.CREATETIME IS '该项规则的创建事件';
COMMENT ON COLUMN GDL_EVENTENGINE_ADMIN.UPDATETIME IS '该项规则的更新时间';
CREATE INDEX IDX_GDL_EVENTENGINE_ADMIN_APPID ON GDL.GDL_EVENTENGINE_ADMIN (APPID) TABLESPACE GDL_IDX ;
create sequence GDL.SEQ_GDL_EVENTENGINE_ADMIN_ID
minvalue 1 --最小值
maxvalue 999999999999999999 --最大值
start with 1 --从1开始
increment by 1 --每次加1
cache 20;
GRANT ALL ON GDL.GDL_EVENTENGINE_ADMIN TO GDL;
查看所有的表空间
SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size
FROM dba_tablespaces t, dba_data_files d
WHERE t.tablespace_name = d.tablespace_name
GROUP BY t.tablespace_name;
查询表信息
字段信息
select *
from user_tab_columns
where Table_Name='GDL_EVENTENGINE_ADMIN'
order by column_name