详情见 :http://topic.csdn.net/u/20100126/14/8e77718b-1b3e-4c11-b195-29f53ba1444a.html上面改后还有一个问题:就是会报
create table SITES_INFO
(
MAIN_DOMAIN VARCHAR2(160),
HOST_NAME VARCHAR2(160) not null,
OUT_LINKS NUMBER,
LINKS NUMBER,
STATUS NUMBER default 40,
ALLCOUNT NUMBER,
FAILEDCOUNT NUMBER,
CREATE_DATE DATE default sysdate,
LAST_UPDATE_DATE DATE default sysdate,
CLIENT_ID VARCHAR2(150),
NUM1 NUMBER,
NUM2 NUMBER,
STR1 VARCHAR2(150),
STR2 VARCHAR2(150),
STR3 VARCHAR2(150),
GRADE NUMBER,
INTERVALDAYS NUMBER,
SITE_LANGUAGE_TYPE NUMBER default 0
)create table DOMAIN_ALEXA_INFO
(
MAIN_DOMAIN VARCHAR2(160) not null,
ALEXA_RANKING NUMBER,
CHINAALEXARANK NUMBER,
STATUS NUMBER default 40,
SITELANGUAGETYPE NUMBER default 0,
SITEOUTLINKS NUMBER,
SITEONLINEDATE DATE,
USERCOUNTRYINFO VARCHAR2(300),
SITEAVGSPEEDINFO VARCHAR2(300),
ATTEMPTTIMES NUMBER,
CREATE_DATE DATE default sysdate,
LAST_UPDATE_DATE DATE default sysdate,
NETGY_GRADE NUMBER,
INTERVAL_VISIT_DAYS NUMBER,
CLIENT_ID VARCHAR2(150),
NUM1 NUMBER,
NUM2 NUMBER,
STR1 VARCHAR2(150),
STR2 VARCHAR2(150),
STR3 VARCHAR2(150)
)alter table DOMAIN_ALEXA_INFO
add constraint DOMAIN_ALEXA_INFO__MAIN_DOMAIN primary key (MAIN_DOMAIN)
为什么会出现报 ora-00001 违反唯一 约束条件 DOMAIN_ALEXA_INFO__MAIN_DOMAIN
如果domain_alexa_info 存在main_domain时,就更新时间,只有不存在时,才会插入的啊
怎么会违反违反唯一 约束条件
要怎么改sql
create table SITES_INFO
(
MAIN_DOMAIN VARCHAR2(160),
HOST_NAME VARCHAR2(160) not null,
OUT_LINKS NUMBER,
LINKS NUMBER,
STATUS NUMBER default 40,
ALLCOUNT NUMBER,
FAILEDCOUNT NUMBER,
CREATE_DATE DATE default sysdate,
LAST_UPDATE_DATE DATE default sysdate,
CLIENT_ID VARCHAR2(150),
NUM1 NUMBER,
NUM2 NUMBER,
STR1 VARCHAR2(150),
STR2 VARCHAR2(150),
STR3 VARCHAR2(150),
GRADE NUMBER,
INTERVALDAYS NUMBER,
SITE_LANGUAGE_TYPE NUMBER default 0
)create table DOMAIN_ALEXA_INFO
(
MAIN_DOMAIN VARCHAR2(160) not null,
ALEXA_RANKING NUMBER,
CHINAALEXARANK NUMBER,
STATUS NUMBER default 40,
SITELANGUAGETYPE NUMBER default 0,
SITEOUTLINKS NUMBER,
SITEONLINEDATE DATE,
USERCOUNTRYINFO VARCHAR2(300),
SITEAVGSPEEDINFO VARCHAR2(300),
ATTEMPTTIMES NUMBER,
CREATE_DATE DATE default sysdate,
LAST_UPDATE_DATE DATE default sysdate,
NETGY_GRADE NUMBER,
INTERVAL_VISIT_DAYS NUMBER,
CLIENT_ID VARCHAR2(150),
NUM1 NUMBER,
NUM2 NUMBER,
STR1 VARCHAR2(150),
STR2 VARCHAR2(150),
STR3 VARCHAR2(150)
)alter table DOMAIN_ALEXA_INFO
add constraint DOMAIN_ALEXA_INFO__MAIN_DOMAIN primary key (MAIN_DOMAIN)
为什么会出现报 ora-00001 违反唯一 约束条件 DOMAIN_ALEXA_INFO__MAIN_DOMAIN
如果domain_alexa_info 存在main_domain时,就更新时间,只有不存在时,才会插入的啊
怎么会违反违反唯一 约束条件
要怎么改sql
http://topic.csdn.net/u/20100128/09/a328a86d-c1d7-4341-930a-5121898e43b6.html?seed=2137663338&r=63061102#r_63061102