oracle脚本转换成SQL脚本,该怎么做???本人从未学过Oracle,有大量Oracle脚本是数据库建表的,现在要到sql2000中建表。我应该怎么办?样例如下:
CREATE TABLE FA_CPO_HDR
(
FA_CPOH_OUR_REF NUMBER(12),
FA_CPOH_QUOTE_NO VARCHAR2(20),
FA_CPOH_CPO_NO VARCHAR2(20) NOT NULL,
FA_CPOH_STATUS VARCHAR2(1) NOT NULL,
FA_CPOH_CUST_CODE VARCHAR2(10) NOT NULL,
FA_CPOH_END_USER VARCHAR2(10) NOT NULL,
FA_CPOH_CONSGN_CODE VARCHAR2(10) NOT NULL,
FA_CPOH_PRIC_CURR VARCHAR2(3) NOT NULL,
FA_CPOH_PRIC_TRM VARCHAR2(3) NOT NULL,
FA_CPOH_TRM_DEST VARCHAR2(3) NOT NULL,
FA_CPOH_PROFIT_RATE NUMBER(3,2) NOT NULL,
FA_CPOH_INTEREST_RATE NUMBER(7,6) NOT NULL,
FA_CPOH_HC_RATE NUMBER(7,6) NOT NULL,
FA_CPOH_MAKE_DATE DATE NOT NULL,
FA_CPOH_ISSUE_DATE DATE,
FA_CPOH_ETD_DATE DATE,
FA_CPOH_ETD_DATE_DESC VARCHAR2(100),
FA_CPOH_PYTM_CODE VARCHAR2(100),
FA_CPOH_OTHER_CONDITION VARCHAR2(100),
FA_CPOH_CAL_AMT NUMBER NOT NULL,
FA_CPOH_TOT_AMT NUMBER NOT NULL,
FA_CPOH_AMT_CHN VARCHAR2(50),
FA_CPOH_STAMP_TAX_YN VARCHAR2(1) NOT NULL,
FA_CPOH_CRT_DATE DATE NOT NULL,
FA_CPOH_CRT_BY VARCHAR2(20) NOT NULL,
FA_CPOH_MOD_DATE DATE NOT NULL,
FA_CPOH_MOD_BY VARCHAR2(20) NOT NULL,
FA_CPOH_CONTRACT_NO VARCHAR2(50),
FA_CPOH_SECT_CODE VARCHAR2(4) NOT NULL,
FA_CPOH_SALE_ID NUMBER(4) NOT NULL,
FA_CPOH_INV_RCV VARCHAR2(20) NOT NULL,
FA_CPOH_CGO_RCV VARCHAR2(20) NOT NULL,
FA_CPOH_RMK VARCHAR2(100),
FA_CPOH_ACC_PRATE NUMBER,
FA_CPOH_DEF_DISC_RATE NUMBER(4,4) NOT NULL,
FA_CPOH_GOODS_TY VARCHAR2(10) NOT NULL
)
TABLESPACE USERS
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 256K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL;
CREATE UNIQUE INDEX PK_FA_CPOH_OUR_REF ON FA_CPO_HDR
(FA_CPOH_OUR_REF)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 256K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE PUBLIC SYNONYM FA_CPO_HDR FOR FA_CPO_HDR;
ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_CAL_AMT CHECK ( FA_CPOH_CAL_AMT>=0));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_HC_RATE CHECK (FA_CPOH_HC_RATE >=0));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_INTEREST_RATE CHECK (FA_CPOH_INTEREST_RATE>=0));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_PROFIT_RATE CHECK ( FA_CPOH_PROFIT_RATE>=0));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_STAMP_TAX_YN CHECK (FA_CPOH_STAMP_TAX_YN IN ('Y','N')));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_STATUS CHECK (FA_CPOH_STATUS IN ('Y','N','C')));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_TOT_AMT CHECK ( FA_CPOH_TOT_AMT>=0));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT PK_FA_CPOH_OUR_REF PRIMARY KEY (FA_CPOH_OUR_REF)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 256K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
));
ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT FK_FA_CPOH_CUST_CODE FOREIGN KEY (FA_CPOH_CUST_CODE)
REFERENCES FA_CUSTOMER (FA_CUST_CODE));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT FK_FA_CPOH_END_USER FOREIGN KEY (FA_CPOH_END_USER)
REFERENCES FA_CUSTOMER (FA_CUST_CODE));
CREATE TABLE FA_CPO_HDR
(
FA_CPOH_OUR_REF NUMBER(12),
FA_CPOH_QUOTE_NO VARCHAR2(20),
FA_CPOH_CPO_NO VARCHAR2(20) NOT NULL,
FA_CPOH_STATUS VARCHAR2(1) NOT NULL,
FA_CPOH_CUST_CODE VARCHAR2(10) NOT NULL,
FA_CPOH_END_USER VARCHAR2(10) NOT NULL,
FA_CPOH_CONSGN_CODE VARCHAR2(10) NOT NULL,
FA_CPOH_PRIC_CURR VARCHAR2(3) NOT NULL,
FA_CPOH_PRIC_TRM VARCHAR2(3) NOT NULL,
FA_CPOH_TRM_DEST VARCHAR2(3) NOT NULL,
FA_CPOH_PROFIT_RATE NUMBER(3,2) NOT NULL,
FA_CPOH_INTEREST_RATE NUMBER(7,6) NOT NULL,
FA_CPOH_HC_RATE NUMBER(7,6) NOT NULL,
FA_CPOH_MAKE_DATE DATE NOT NULL,
FA_CPOH_ISSUE_DATE DATE,
FA_CPOH_ETD_DATE DATE,
FA_CPOH_ETD_DATE_DESC VARCHAR2(100),
FA_CPOH_PYTM_CODE VARCHAR2(100),
FA_CPOH_OTHER_CONDITION VARCHAR2(100),
FA_CPOH_CAL_AMT NUMBER NOT NULL,
FA_CPOH_TOT_AMT NUMBER NOT NULL,
FA_CPOH_AMT_CHN VARCHAR2(50),
FA_CPOH_STAMP_TAX_YN VARCHAR2(1) NOT NULL,
FA_CPOH_CRT_DATE DATE NOT NULL,
FA_CPOH_CRT_BY VARCHAR2(20) NOT NULL,
FA_CPOH_MOD_DATE DATE NOT NULL,
FA_CPOH_MOD_BY VARCHAR2(20) NOT NULL,
FA_CPOH_CONTRACT_NO VARCHAR2(50),
FA_CPOH_SECT_CODE VARCHAR2(4) NOT NULL,
FA_CPOH_SALE_ID NUMBER(4) NOT NULL,
FA_CPOH_INV_RCV VARCHAR2(20) NOT NULL,
FA_CPOH_CGO_RCV VARCHAR2(20) NOT NULL,
FA_CPOH_RMK VARCHAR2(100),
FA_CPOH_ACC_PRATE NUMBER,
FA_CPOH_DEF_DISC_RATE NUMBER(4,4) NOT NULL,
FA_CPOH_GOODS_TY VARCHAR2(10) NOT NULL
)
TABLESPACE USERS
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 256K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL;
CREATE UNIQUE INDEX PK_FA_CPOH_OUR_REF ON FA_CPO_HDR
(FA_CPOH_OUR_REF)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 256K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE PUBLIC SYNONYM FA_CPO_HDR FOR FA_CPO_HDR;
ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_CAL_AMT CHECK ( FA_CPOH_CAL_AMT>=0));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_HC_RATE CHECK (FA_CPOH_HC_RATE >=0));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_INTEREST_RATE CHECK (FA_CPOH_INTEREST_RATE>=0));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_PROFIT_RATE CHECK ( FA_CPOH_PROFIT_RATE>=0));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_STAMP_TAX_YN CHECK (FA_CPOH_STAMP_TAX_YN IN ('Y','N')));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_STATUS CHECK (FA_CPOH_STATUS IN ('Y','N','C')));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT CK_FA_CPOH_TOT_AMT CHECK ( FA_CPOH_TOT_AMT>=0));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT PK_FA_CPOH_OUR_REF PRIMARY KEY (FA_CPOH_OUR_REF)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 256K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
));
ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT FK_FA_CPOH_CUST_CODE FOREIGN KEY (FA_CPOH_CUST_CODE)
REFERENCES FA_CUSTOMER (FA_CUST_CODE));ALTER TABLE FA_CPO_HDR ADD (
CONSTRAINT FK_FA_CPOH_END_USER FOREIGN KEY (FA_CPOH_END_USER)
REFERENCES FA_CUSTOMER (FA_CUST_CODE));
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货