Identifying and Resolving Database Script Errors: A Practical Guide
VerifiedAdded on  2019/09/16
|16
|7421
|159
Homework Assignment
AI Summary
This assignment solution addresses a series of SQL script errors encountered during the creation of database tables and the insertion of data. The errors include ORA-00955 (name already used), unique constraint violations, and date format mismatches. The script attempts to create tables for project types, projects, job types, staff, and staff skills, and then insert data into these tables. The solution highlights the specific lines of code where errors occur, providing error messages from the database (Oracle). The errors are related to duplicate object names, unique key violations during data insertion, and incorrect date formats. The solution demonstrates the debugging process and the need for careful attention to database object names, data integrity constraints, and data type formatting when writing SQL scripts. This is a practical example that shows common mistakes and the process to correct them when working with databases.
Error starting at line : 1 in command -
create table Project_Type
(
ptype_id integer primary key,
ptype_name varchar(50)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 11 in command -
insert into project_type(ptype_id, ptype_name) values (1, 'Web')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 13 in command -
insert into project_type(ptype_id, ptype_name) values (2, 'Maintenance')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 15 in command -
insert into project_type(ptype_id, ptype_name) values (3, 'App')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 17 in command -
insert into project_type(ptype_id, ptype_name) values (4, 'Testing')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 19 in command -
create table Project_Type
(
ptype_id integer primary key,
ptype_name varchar(50)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 11 in command -
insert into project_type(ptype_id, ptype_name) values (1, 'Web')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 13 in command -
insert into project_type(ptype_id, ptype_name) values (2, 'Maintenance')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 15 in command -
insert into project_type(ptype_id, ptype_name) values (3, 'App')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 17 in command -
insert into project_type(ptype_id, ptype_name) values (4, 'Testing')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 19 in command -
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
create table project
(
Project_id varchar(10) primary key,
Project_Name varchar(100),
Project_Type_id integer,
Start_Date date,
End_Date date,
expect_finish_date date,
constraint p_fk foreign key(Project_Type_id) references Project_Type(ptype_id)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 39 in command -
insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,
expect_finish_date) values ('B1049', 'Health System', 1, '2016-06- 01', '2016-09- 01',
'39;2016-09- 02')
Error report -
SQL Error: ORA-01861: literal does not match format string
01861. 00000 - "literal does not match format string"
*Cause: Literals in the input must be the same length as literals in
the format string (with the exception of leading whitespace). If the
"FX" modifier has been toggled on, the literal must match exactly,
with no extra whitespace.
*Action: Correct the format string to match the literal.
Error starting at line : 43 in command -
insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,
expect_finish_date) values ('B1050'', 'insurance System', 2, '39;2016-01- 01', '2016-03-
03', '2016-03- 06')
Error report -
SQL Error: ORA-01847: day of month must be between 1 and last day of month
01847. 00000 - "day of month must be between 1 and last day of month"
*Cause:
*Action:
Error starting at line : 49 in command -
insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,
expect_finish_date) values ('B1051', 'university System', 3, '2016-05- 01', '2016-06- 01',
'2016-06- 05')
Error report -
SQL Error: ORA-01861: literal does not match format string
01861. 00000 - "literal does not match format string"
*Cause: Literals in the input must be the same length as literals in
the format string (with the exception of leading whitespace). If the
"FX" modifier has been toggled on, the literal must match exactly,
with no extra whitespace.
*Action: Correct the format string to match the literal.
(
Project_id varchar(10) primary key,
Project_Name varchar(100),
Project_Type_id integer,
Start_Date date,
End_Date date,
expect_finish_date date,
constraint p_fk foreign key(Project_Type_id) references Project_Type(ptype_id)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 39 in command -
insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,
expect_finish_date) values ('B1049', 'Health System', 1, '2016-06- 01', '2016-09- 01',
'39;2016-09- 02')
Error report -
SQL Error: ORA-01861: literal does not match format string
01861. 00000 - "literal does not match format string"
*Cause: Literals in the input must be the same length as literals in
the format string (with the exception of leading whitespace). If the
"FX" modifier has been toggled on, the literal must match exactly,
with no extra whitespace.
*Action: Correct the format string to match the literal.
Error starting at line : 43 in command -
insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,
expect_finish_date) values ('B1050'', 'insurance System', 2, '39;2016-01- 01', '2016-03-
03', '2016-03- 06')
Error report -
SQL Error: ORA-01847: day of month must be between 1 and last day of month
01847. 00000 - "day of month must be between 1 and last day of month"
*Cause:
*Action:
Error starting at line : 49 in command -
insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,
expect_finish_date) values ('B1051', 'university System', 3, '2016-05- 01', '2016-06- 01',
'2016-06- 05')
Error report -
SQL Error: ORA-01861: literal does not match format string
01861. 00000 - "literal does not match format string"
*Cause: Literals in the input must be the same length as literals in
the format string (with the exception of leading whitespace). If the
"FX" modifier has been toggled on, the literal must match exactly,
with no extra whitespace.
*Action: Correct the format string to match the literal.
Error starting at line : 53 in command -
create table Job_type
(
type_id varchar(5) primary key,
type_name varchar(50)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 63 in command -
insert into job_type(type_id, type_name) values ('JT1', 'Imaging')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 65 in command -
insert into job_type(type_id, type_name) values ('JT2', 'Web Developer')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 67 in command -
insert into job_type(type_id, type_name) values ('JT3', 'Maintenance')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 69 in command -
insert into job_type(type_id, type_name) values ('JT4', 'Training')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 71 in command -
create table Job_type
(
type_id varchar(5) primary key,
type_name varchar(50)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 63 in command -
insert into job_type(type_id, type_name) values ('JT1', 'Imaging')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 65 in command -
insert into job_type(type_id, type_name) values ('JT2', 'Web Developer')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 67 in command -
insert into job_type(type_id, type_name) values ('JT3', 'Maintenance')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 69 in command -
insert into job_type(type_id, type_name) values ('JT4', 'Training')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 71 in command -
⊘ This is a preview!⊘
Do you want full access?
Subscribe today to unlock all pages.
Trusted by 1+ million students worldwide
create table Staff
(
Staff_ID varchar(10) primary key,
Name varchar(50),
Job_Type_id varchar(5),
Job_Grade integer,
constraint s_fk foreign key(job_type_id) references Job_type(type_id)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 87 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('1014E', 'John Baker',
'JT1', 3)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 89 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('230R1', 'Marian Dowd',
'JT2', 1)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 91 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('0P625', 'Jennifer Tuff',
'JT3', 2)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 93 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('4T371', 'Paul Downing',
'JT4', 3
)
Error report -
(
Staff_ID varchar(10) primary key,
Name varchar(50),
Job_Type_id varchar(5),
Job_Grade integer,
constraint s_fk foreign key(job_type_id) references Job_type(type_id)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 87 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('1014E', 'John Baker',
'JT1', 3)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 89 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('230R1', 'Marian Dowd',
'JT2', 1)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 91 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('0P625', 'Jennifer Tuff',
'JT3', 2)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 93 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('4T371', 'Paul Downing',
'JT4', 3
)
Error report -
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 97 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('1044E', '39;Johnny
Woods', 'JT1',
3)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 101 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('233R1', 'Mia S.', 'JT2', 1)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 105 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('0Q625', '39;Jenny Duff',
'JT3', 2)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 107 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('6T371', '39;Pal Sterling',
'JT4', 3 )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 109 in command -
create table Staff_skill
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 97 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('1044E', '39;Johnny
Woods', 'JT1',
3)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 101 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('233R1', 'Mia S.', 'JT2', 1)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 105 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('0Q625', '39;Jenny Duff',
'JT3', 2)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 107 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('6T371', '39;Pal Sterling',
'JT4', 3 )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 109 in command -
create table Staff_skill
(
Staff_ID varchar(10),
skill_name varchar(50),
primary key(staff_id, skill_name),
constraint ss_fk foreign key(Staff_ID) references staff(Staff_ID)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 123 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('1014E', 'DATA IMAGING' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 125 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('230R1', 'WEB
DEVELOPMENT' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 127 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('0P625', 'OFFLINE
DEVELOPMENT' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 129 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('4T371', 'C++' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
Staff_ID varchar(10),
skill_name varchar(50),
primary key(staff_id, skill_name),
constraint ss_fk foreign key(Staff_ID) references staff(Staff_ID)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 123 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('1014E', 'DATA IMAGING' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 125 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('230R1', 'WEB
DEVELOPMENT' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 127 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('0P625', 'OFFLINE
DEVELOPMENT' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 129 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('4T371', 'C++' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
⊘ This is a preview!⊘
Do you want full access?
Subscribe today to unlock all pages.
Trusted by 1+ million students worldwide
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 131 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('1044E', 'BLACK BOX' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 133 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('233R1', 'HTML' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 135 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('0Q625', 'SQL' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 137 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('6T371', 'NOSQL' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 139 in command -
create table Project_Staff
(
Staff_ID varchar(10),
Project_id varchar(10),
primary key(staff_id, project_id),
constraint ps_fk1 foreign key(Staff_ID) references staff(Staff_ID),
constraint ps_fk2 foreign key(project_ID) references project(project_ID)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
Error starting at line : 131 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('1044E', 'BLACK BOX' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 133 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('233R1', 'HTML' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 135 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('0Q625', 'SQL' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 137 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('6T371', 'NOSQL' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 139 in command -
create table Project_Staff
(
Staff_ID varchar(10),
Project_id varchar(10),
primary key(staff_id, project_id),
constraint ps_fk1 foreign key(Staff_ID) references staff(Staff_ID),
constraint ps_fk2 foreign key(project_ID) references project(project_ID)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 157 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('1014E','B1049' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 159 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('230R1', 'B1049' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 161 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('0P625', 'B1049' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 163 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('4T371', 'B1049' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 165 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('1044E', 'B1050' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 167 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('233R1', 'B1050' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
*Cause:
*Action:
Error starting at line : 157 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('1014E','B1049' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 159 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('230R1', 'B1049' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 161 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('0P625', 'B1049' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 163 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('4T371', 'B1049' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 165 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('1044E', 'B1050' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 167 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('233R1', 'B1050' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 169 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('0Q625', 'B1051' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 171 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('6T371', 'B1050' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 173 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('6T371', 'B1051' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 175 in command -
create table Software
(
Software_ID integer primary key,
Software_name varchar(50)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 185 in command -
INSERT INTO SOFTWARE(SOFTWARE_ID, SOFTWARE_NAME) VALUES (1001,
'Encryption Protocol
Suite')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024813) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 169 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('0Q625', 'B1051' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 171 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('6T371', 'B1050' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 173 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('6T371', 'B1051' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 175 in command -
create table Software
(
Software_ID integer primary key,
Software_name varchar(50)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 185 in command -
INSERT INTO SOFTWARE(SOFTWARE_ID, SOFTWARE_NAME) VALUES (1001,
'Encryption Protocol
Suite')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024813) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
⊘ This is a preview!⊘
Do you want full access?
Subscribe today to unlock all pages.
Trusted by 1+ million students worldwide
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 189 in command -
INSERT INTO SOFTWARE(SOFTWARE_ID, SOFTWARE_NAME) VALUES
(1002,'Autodesk Maya')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024813) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 191 in command -
INSERT INTO SOFTWARE(SOFTWARE_ID, SOFTWARE_NAME) VALUES (1003,
'Rational rose')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024813) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 193 in command -
INSERT INTO SOFTWARE(SOFTWARE_ID, SOFTWARE_NAME) VALUES (1004, 'Sql
Server')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024813) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 195 in command -
create table Hardware
(
Hardware_ID integer primary key,
Hardware_name varchar(50)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 205 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (101, 'Games
Monitor')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
Error starting at line : 189 in command -
INSERT INTO SOFTWARE(SOFTWARE_ID, SOFTWARE_NAME) VALUES
(1002,'Autodesk Maya')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024813) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 191 in command -
INSERT INTO SOFTWARE(SOFTWARE_ID, SOFTWARE_NAME) VALUES (1003,
'Rational rose')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024813) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 193 in command -
INSERT INTO SOFTWARE(SOFTWARE_ID, SOFTWARE_NAME) VALUES (1004, 'Sql
Server')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024813) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 195 in command -
create table Hardware
(
Hardware_ID integer primary key,
Hardware_name varchar(50)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 205 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (101, 'Games
Monitor')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 209 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (102, 'Web
Cam')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 211 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (103,
'Scanner')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 213 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (104,
'External Drive')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 215 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (105, 'Hard
Disk 5GB')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 217 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (106, 'Flat
Screen Monitor')
Error report -
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 209 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (102, 'Web
Cam')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 211 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (103,
'Scanner')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 213 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (104,
'External Drive')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 215 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (105, 'Hard
Disk 5GB')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 217 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (106, 'Flat
Screen Monitor')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 219 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (107,
'Imagines tool')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 221 in command -
create table Project_hware
(
Project_id varchar(10),
Hardware_ID integer,
primary key(project_id, hardware_id),
constraint ph_fk1 foreign key(hardware_ID) references hardware(hardware_ID),
constraint ph_fk2 foreign key(project_ID) references project(project_ID)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 237 in command -
insert into Project_hware(project_id, hardware_id) values('B1049', 101)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 239 in command -
insert into Project_hware(project_id, hardware_id) values('B1049', 102)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 241 in command -
insert into Project_hware(project_id, hardware_id) values('B1049', 103)
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 219 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (107,
'Imagines tool')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 221 in command -
create table Project_hware
(
Project_id varchar(10),
Hardware_ID integer,
primary key(project_id, hardware_id),
constraint ph_fk1 foreign key(hardware_ID) references hardware(hardware_ID),
constraint ph_fk2 foreign key(project_ID) references project(project_ID)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 237 in command -
insert into Project_hware(project_id, hardware_id) values('B1049', 101)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 239 in command -
insert into Project_hware(project_id, hardware_id) values('B1049', 102)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 241 in command -
insert into Project_hware(project_id, hardware_id) values('B1049', 103)
⊘ This is a preview!⊘
Do you want full access?
Subscribe today to unlock all pages.
Trusted by 1+ million students worldwide
1 out of 16
Your All-in-One AI-Powered Toolkit for Academic Success.
 +13062052269
info@desklib.com
Available 24*7 on WhatsApp / Email
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
Unlock your academic potential
Copyright © 2020–2025 A2Z Services. All Rights Reserved. Developed and managed by ZUCOL.