我用反向工程执行sql脚本 里面是这样写的create table SR_WR_FRONTTRANSIMYH (
rptday NUMBER(12) not null,
wayid VARCHAR2(32) not null,
countyid VARCHAR2(32) not null,
operID VARCHAR2(16) not null,
servNumber VARCHAR2(20) not null,
feeTypeID varchar2(32) not null,
PRODID varchar2(32) not null,
acctid NUMBER(14) not null,
RECAMT NUMBER(16,2),
PAICLUPAMT NUMBER(16,2),
DISCOUNTAMT NUMBER(16,2)
);alter table SR_WR_FRONTTRANSIMYH modify acctid null;
alter table SR_WR_FRONTTRANSIMYH rename column PRODID to PROID;alter table "SR_WR_FRONTTRANSIMYH"
add primary key ("rptday")
/
执行后发现表和主键都建了,但是字段的null属性没有改,字段名字也没改。
查看日志,发现是被忽略了
Lines 1 to 1: "drop table SR_WR_FRONTTRANSIMYH cascade constraints" skipped.
Lines 6 to 18: Table SR_WR_FRONTTRANSIMYH
Lines 20 to 20: "alter table SR_WR_FRONTTRANSIMYH modify acctid null" skipped.
Lines 21 to 21: "alter table SR_WR_FRONTTRANSIMYH rename column PRODID to PROID" skipped.
不知道为什么这两个sql被忽略,有没有办法通过sql修改pdm表的字段属性?
rptday NUMBER(12) not null,
wayid VARCHAR2(32) not null,
countyid VARCHAR2(32) not null,
operID VARCHAR2(16) not null,
servNumber VARCHAR2(20) not null,
feeTypeID varchar2(32) not null,
PRODID varchar2(32) not null,
acctid NUMBER(14) not null,
RECAMT NUMBER(16,2),
PAICLUPAMT NUMBER(16,2),
DISCOUNTAMT NUMBER(16,2)
);alter table SR_WR_FRONTTRANSIMYH modify acctid null;
alter table SR_WR_FRONTTRANSIMYH rename column PRODID to PROID;alter table "SR_WR_FRONTTRANSIMYH"
add primary key ("rptday")
/
执行后发现表和主键都建了,但是字段的null属性没有改,字段名字也没改。
查看日志,发现是被忽略了
Lines 1 to 1: "drop table SR_WR_FRONTTRANSIMYH cascade constraints" skipped.
Lines 6 to 18: Table SR_WR_FRONTTRANSIMYH
Lines 20 to 20: "alter table SR_WR_FRONTTRANSIMYH modify acctid null" skipped.
Lines 21 to 21: "alter table SR_WR_FRONTTRANSIMYH rename column PRODID to PROID" skipped.
不知道为什么这两个sql被忽略,有没有办法通过sql修改pdm表的字段属性?
-- 不好意思 检查了一下,我刚才贴的脚本是错的,下面的才是我运行的脚本
/*==============================================================*/
/* Table: SR_WR_FRONTTRANSIMYH */
/*==============================================================*/
create table SR_WR_FRONTTRANSIMYH (
rptday NUMBER(12) not null,
wayid VARCHAR2(32) not null,
countyid VARCHAR2(32) not null,
operID VARCHAR2(16) not null,
servNumber VARCHAR2(20) not null,
feeTypeID varchar2(32) not null,
PRODID varchar2(32) not null,
acctid NUMBER(14) not null,
RECAMT NUMBER(16,2),
PAICLUPAMT NUMBER(16,2),
DISCOUNTAMT NUMBER(16,2)
);alter table SR_WR_FRONTTRANSIMYH modify acctid null;
alter table SR_WR_FRONTTRANSIMYH rename column PRODID to PROID;alter table SR_WR_FRONTTRANSIMYH
add primary key (rptday)
/
试了一下 还是不行