--connect sys/sys;
create tablespace TS_YBHK LOGGING datafile 'R:\...(服务器上具体地址)\ts_ybhk0001.dat' size 1024M autoextend on next 200M
extent management local segment space management auto ;
--创建用户SD_YBHK
--drop user SD_YBHK cascade;
create user SD_YBHK identified by SD_YBHK default tablespace TS_YBHK;
grant RESOURCE,connect TO SD_YBHK;
-添加属性描述-
comment on column SD_YBHK.HK_CFSHFK.SHFKID is '审核反馈id，对应序列sd_hk_cfshfk_shfkid';
---创建视图--
create or replace view VIEW_SF_BRFY00 as
select mzh000 from sf where jzdh00>1;
-添加字段-
alter table SD_YBHK.HK_SFXM00 modify gzlx00 VARCHAR2(4000);