logo

Error report - SQL Error: ORA-00955: unique constraint (ABM0721.SYS_C0024374) virialization

16 Pages7421 Words159 Views
   

Added on  2019-09-16

About This Document

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.

Error report - SQL Error: ORA-00955: unique constraint (ABM0721.SYS_C0024374) virialization

   Added on 2019-09-16

ShareRelated Documents
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 -
Error report - SQL Error: ORA-00955: unique constraint (ABM0721.SYS_C0024374) virialization_1
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&#39', '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 report - SQL Error: ORA-00955: unique constraint (ABM0721.SYS_C0024374) virialization_2
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 -
Error report - SQL Error: ORA-00955: unique constraint (ABM0721.SYS_C0024374) virialization_3
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 -
Error report - SQL Error: ORA-00955: unique constraint (ABM0721.SYS_C0024374) virialization_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Oracle Database Assignment | DBMS
|7
|3576
|478