我在oracle初始话表时遇到的问题如下:
1,初始化后表的个数正确,表的构造正确,可是表的内容老是空的!而别人使用同样的表在他们的机子上都初始化成功了;
2,于是我不通过导入文件初始化,而是一个一个建表,结果又出错,问题如下;
SQL> CREATE TABLE s_customer
2 (id NUMBER(7)
3 CONSTRAINT s_customer_id_nn NOT NULL,
4 name VARCHAR2(50)
5 CONSTRAINT s_customer_name_nn NOT NULL,
6 phone VARCHAR2(25),
7 address VARCHAR2(400),
8 city VARCHAR2(30),
9 state VARCHAR2(20),
10 country VARCHAR2(30),
11 zip_code VARCHAR2(75),
12 credit_rating VARCHAR2(9),
13 sales_rep_id NUMBER(7),
14 region_id NUMBER(7),
15 comments VARCHAR2(255),
16 CONSTRAINT s_customer_id_pk PRIMARY KEY (id),
17 CONSTRAINT s_customer_credit_rating_ck
18 CHECK (credit_rating IN ('EXCELLENT', 'GOOD', 'POOR')));
CREATE TABLE s_customer
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
SQL>
SQL> INSERT INTO s_customer VALUES (
2 201, 'Unisports', '55-2066101',
3 '72 Via Bahia', 'Sao Paolo', NULL, 'Brazil', NULL,
4 'EXCELLENT', 12, 2, NULL);
INSERT INTO s_customer VALUES (
*
ERROR at line 1:
ORA-00001: unique constraint (SYSTEM.S_CUSTOMER_ID_PK) violated
1,初始化后表的个数正确,表的构造正确,可是表的内容老是空的!而别人使用同样的表在他们的机子上都初始化成功了;
2,于是我不通过导入文件初始化,而是一个一个建表,结果又出错,问题如下;
SQL> CREATE TABLE s_customer
2 (id NUMBER(7)
3 CONSTRAINT s_customer_id_nn NOT NULL,
4 name VARCHAR2(50)
5 CONSTRAINT s_customer_name_nn NOT NULL,
6 phone VARCHAR2(25),
7 address VARCHAR2(400),
8 city VARCHAR2(30),
9 state VARCHAR2(20),
10 country VARCHAR2(30),
11 zip_code VARCHAR2(75),
12 credit_rating VARCHAR2(9),
13 sales_rep_id NUMBER(7),
14 region_id NUMBER(7),
15 comments VARCHAR2(255),
16 CONSTRAINT s_customer_id_pk PRIMARY KEY (id),
17 CONSTRAINT s_customer_credit_rating_ck
18 CHECK (credit_rating IN ('EXCELLENT', 'GOOD', 'POOR')));
CREATE TABLE s_customer
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
SQL>
SQL> INSERT INTO s_customer VALUES (
2 201, 'Unisports', '55-2066101',
3 '72 Via Bahia', 'Sao Paolo', NULL, 'Brazil', NULL,
4 'EXCELLENT', 12, 2, NULL);
INSERT INTO s_customer VALUES (
*
ERROR at line 1:
ORA-00001: unique constraint (SYSTEM.S_CUSTOMER_ID_PK) violated
解决方案 »
- 帮忙做个很简单的实验吧。谢谢了
- Error executing BeginTransaction for list.
- 问一个update语句,大家帮帮忙啊。
- 求一个字段说明sql语句
- 请问有没有Oracle中用存储过程实现数据库备份与恢复的例子?
- 帮一帮各位,兄弟,小弟先声谢谢,100分不够,再加
- Win2000下安装Oracle90的初级问题
- ORCALE正版多少钱???
- 新建一数据库,独立登陆OEM看的到,登陆到OMS就看不到,请指教!在线等!
- 有关 Oracle 的几个问题!
- "SYS"."DBMS_REPCAT_RPC",这个对象怎么会不存在呢?
- merge into的update问题
看错误消息就知道原因了。自己也可以改正的。
ORA-00955: name is already used by an existing object
这个对象已经存在了,需要删除掉,然后再创建。
ORA-00001: unique constraint (SYSTEM.S_CUSTOMER_ID_PK) violated插入的值违反了主键约束。。
create table;然后insert,就不会报这2个错误了。
CREATE TABLE s_customer_new
(id NUMBER(7)
CONSTRAINT s_customer_id_nn NOT NULL,
name VARCHAR2(50)
CONSTRAINT s_customer_name_nn NOT NULL,
phone VARCHAR2(25),
address VARCHAR2(400),
city VARCHAR2(30),
state VARCHAR2(20),
country VARCHAR2(30),
zip_code VARCHAR2(75),
credit_rating VARCHAR2(9),
sales_rep_id NUMBER(7),
region_id NUMBER(7),
comments VARCHAR2(255),
CONSTRAINT s_customer_id_pk PRIMARY KEY (id),
CONSTRAINT s_customer_credit_rating_ck
CHECK (credit_rating IN ('EXCELLENT', 'GOOD', 'POOR'))); --由于是新表s_customer_new,所以插入第一条记录,就应该Ok了。
INSERT INTO s_customer VALUES (
201, 'Unisports', '55-2066101',
'72 Via Bahia', 'Sao Paolo', NULL, 'Brazil', NULL,
'EXCELLENT', 12, 2, NULL);