CREATE TABLE dbo.DM_DJ_BGLB ( BGLB_DM char(2) NOT NULL, BGLB_MC varchar(50) NOT NULL, XG_BJ char(1) NOT NULL, LR_SJ datetime NULL, XG_SJ datetime NULL, LRRY_DM varchar(30) NULL, XGRY_DM varchar(30) NULL, CONSTRAINT DM_DJ_BGLB_5016258491 PRIMARY KEY NONCLUSTERED(BGLB_DM) WITH max_rows_per_page = 0, reservepagegap = 0 ) LOCK DATAROWS WITH exp_row_size = 0, reservepagegap = 0, identity_gap = 0 ON 'default' GO CREATE TABLE dbo.DM_DJ_BGXM ( BGXM_DM char(8) NOT NULL, BGXM_MC varchar(50) NOT NULL, BGXM_JC varchar(30) NOT NULL, XG_BJ char(1) NOT NULL, BGDX_DM char(5) NOT NULL, SJB_LM varchar(30) NOT NULL, SJB_LLX char(2) NOT NULL, LR_SJ datetime NULL, XG_SJ datetime NULL, SJB_BJ char(2) NULL, SJDMB_MC varchar(30) NULL, SJDMB_ZJ varchar(30) NULL, SJDMB_ZJLX char(2) NULL, SJDMB_LMC varchar(30) NULL, LRRY_DM varchar(30) NULL, XGRY_DM varchar(30) NULL, JY_TJ varchar(20) NULL, dmTablefilter varchar(200) NULL, CONSTRAINT DM_DJ_BGXM_12021523471 PRIMARY KEY NONCLUSTERED(BGXM_DM) WITH max_rows_per_page = 0, reservepagegap = 0 ) LOCK DATAROWS WITH exp_row_size = 0, reservepagegap = 0, identity_gap = 0 ON 'default' GO CREATE TABLE dbo.DM_DJ_DJLX ( DJLX_DM char(1) NOT NULL, DJLX_MC varchar(100) NOT NULL, DJLX_JC varchar(5) NULL, SWJG_DM varchar(20) NULL, XY_BJ char(1) NULL, XY_QSRQ date NULL, XY_ZZRQ date NULL, LRRY_DM varchar(30) NULL, LR_SJ datetime NULL, XGRY_DM varchar(30) NULL, XG_SJ datetime NULL, DJLX_LSH numeric(10,0) IDENTITY NOT NULL, CONSTRAINT DM_DJ_DJLX_1308124971 PRIMARY KEY NONCLUSTERED(DJLX_LSH) WITH max_rows_per_page = 0, reservepagegap = 0 ) LOCK DATAROWS WITH exp_row_size = 0, reservepagegap = 0, identity_g ORA-00906: 缺失左括号
这是sybase导出来的sql建表语句,我想将表结构倒入oracle,倒入的时候就出现ORA-00906: 缺失左括号。求高人解决问题。。。或者提供导入的正确的方法。小弟谢啦。