drop表,然后创建表,插入数据,并创建索引等内容。

时间:2023-03-08 16:00:57

execute immediate 'drop table sjb_jhgl_ydjhtdsbb';
   execute immediate 'create table dw_sc.sjb_jhgl_ydjhtdsbb as select * from ods_sc.sjb_jhgl_ydjhtdsbb';
   execute immediate 'create unique index dw_sc.ID_GUID_GSDM on dw_sc.SJB_JHGL_YDJHTDSBB (GUID, GSDM)';
   execute immediate 'create index dw_sc.ID_SJB_JHGL_YDJHTDSBB_GSDM on dw_sc.SJB_JHGL_YDJHTDSBB (GSDM)';
   execute immediate 'create index dw_sc.ID_SJB_JHGL_YDJHTDSBB_GUID on dw_sc.SJB_JHGL_YDJHTDSBB (GUID)';
   execute immediate 'create index dw_sc.ID_SJB_JHGL_YDJHTDSBB_JHGUID on dw_sc.SJB_JHGL_YDJHTDSBB (JHGUID)';
   execute immediate 'create index dw_sc.ID_SJB_JHGL_YDJHTDSBB_SSBDZBM on dw_sc.SJB_JHGL_YDJHTDSBB (SSBDZBM)';