[go: up one dir, main page]
Scribd
Upload
106 views6 pages

Op

The document describes various errors that occurred while creating, altering, inserting and deleting records from tables in an Oracle database. It shows the SQL commands used and the corresponding error messages. Primary keys and foreign keys are created on some tables, and attempts are made to alter columns that fail due to constraints.

Uploaded by

Arpan Kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
106 views6 pages

Op

The document describes various errors that occurred while creating, altering, inserting and deleting records from tables in an Oracle database. It shows the SQL commands used and the corresponding error messages. Primary keys and foreign keys are created on some tables, and attempts are made to alter columns that fail due to constraints.

Uploaded by

Arpan Kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 6

Error starting at line : 1 in command -

CREATE TABLE Customer_T


(CustomerID NUMBER(11,0) NoT NULL,
CustomerName VARCHAR2(25) NOT NULL,
CustomerAddress VARCHAR2(30),
CustomerCity VARCHAR2(20),
CustomerState CHAR(2),
CustomerPostalCode VARCHAR2(9),
CONSTRAINT Customer_PK PRIMARY KEY (CustomerID))
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:
Table ORDER_T dropped.

Table CUSTOMER_T dropped.

Table CUSTOMER_T created.

Table ORDER_T created.

1 row inserted.

1 row inserted.

Error starting at line : 33 in command -


Delete from CUSTOMER_T where CUSTOMERID=009
Error report -
SQL Error: ORA-02292: integrity constraint (SYSTEM.ORDER_FK) violated - child
record found
02292. 00000 - "integrity constraint (%s.%s) violated - child record found"
*Cause: attempted to delete a parent key value that had a foreign
dependency.
*Action: delete dependencies first then parent or disable constraint.
Table ORDER_T dropped.

Table ORDER_T created.

1 row inserted.

1 row deleted.

Table ORDER_T dropped.

Table ORDER_T created.

1 row inserted.

1 row inserted.

1 row deleted.

Table ORDER_T dropped.

Table CUSTOMER_T dropped.

Error starting at line : 77 in command -


DROP TABLE ORDER_T
Error report -
SQL Error: ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
Table CUSTOMER_T created.

Table ORDER_T created.

Table CUSTOMER_T dropped.

Table CUSTOMER_T created.

1 row inserted.

Name Null Type


------------------ -------- ------------
CUSTOMERID NOT NULL NUMBER(11)
CUSTOMERNAME NOT NULL VARCHAR2(25)
CUSTOMERADDRESS VARCHAR2(30)
CUSTOMERCITY VARCHAR2(20)
CUSTOMERSTATE CHAR(2)
CUSTOMERPOSTALCODE VARCHAR2(9)
Name Null Type
---------- -------- ----------
ORDERID NOT NULL NUMBER(11)
ORDERDATE DATE
CUSTOMERID NUMBER(11)
Error starting at line : 88 in command -
ALTER TABLE CUSTOMER_T
Error report -
SQL Error: ORA-02210: no options specified for ALTER TABLE
02210. 00000 - "no options specified for ALTER TABLE"
*Cause: No ALTER TABLE option was specified.
*Action: Specify at least one alter table option.
Error starting at line : 88 in command -
ALTER TABLE CUSTOMER_T
Error report -
SQL Error: ORA-02210: no options specified for ALTER TABLE
02210. 00000 - "no options specified for ALTER TABLE"
*Cause: No ALTER TABLE option was specified.
*Action: Specify at least one alter table option.
Error starting at line : 90 in command -
ADD CustomerType VARCHAR2(20)
Error report -
Unknown Command

Error starting at line : 92 in command -


ALTER TABLE CUSTOMER_T
Error report -
SQL Error: ORA-02210: no options specified for ALTER TABLE
02210. 00000 - "no options specified for ALTER TABLE"
*Cause: No ALTER TABLE option was specified.
*Action: Specify at least one alter table option.
Error starting at line : 94 in command -
ALTER TABLE CUSTOMER_T
Error report -
SQL Error: ORA-02210: no options specified for ALTER TABLE
02210. 00000 - "no options specified for ALTER TABLE"
*Cause: No ALTER TABLE option was specified.
*Action: Specify at least one alter table option.
Name Null Type
------------------ -------- ------------
CUSTOMERID NOT NULL NUMBER(11)
CUSTOMERNAME NOT NULL VARCHAR2(25)
CUSTOMERADDRESS VARCHAR2(30)
CUSTOMERCITY VARCHAR2(20)
CUSTOMERSTATE CHAR(2)
CUSTOMERPOSTALCODE VARCHAR2(9)
1 row inserted.

Error starting at line : 92 in command -


ALTER TABLE CUSTOMER_T
Error report -
SQL Error: ORA-02210: no options specified for ALTER TABLE
02210. 00000 - "no options specified for ALTER TABLE"
*Cause: No ALTER TABLE option was specified.
*Action: Specify at least one alter table option.
Error starting at line : 94 in command -
ALTER TABLE CUSTOMER_T
Error report -
SQL Error: ORA-02210: no options specified for ALTER TABLE
02210. 00000 - "no options specified for ALTER TABLE"
*Cause: No ALTER TABLE option was specified.
*Action: Specify at least one alter table option.
Name Null Type
------------------ -------- ------------
CUSTOMERID NOT NULL NUMBER(11)
CUSTOMERNAME NOT NULL VARCHAR2(25)
CUSTOMERADDRESS VARCHAR2(30)
CUSTOMERCITY VARCHAR2(20)
CUSTOMERSTATE CHAR(2)
CUSTOMERPOSTALCODE VARCHAR2(9)
Error starting at line : 88 in command -
ALTER TABLE CUSTOMER_T
Error report -
SQL Error: ORA-02210: no options specified for ALTER TABLE
02210. 00000 - "no options specified for ALTER TABLE"
*Cause: No ALTER TABLE option was specified.
*Action: Specify at least one alter table option.
Error starting at line : 88 in command -
ALTER TABLE CUSTOMER_T
Error report -
SQL Error: ORA-02210: no options specified for ALTER TABLE
02210. 00000 - "no options specified for ALTER TABLE"
*Cause: No ALTER TABLE option was specified.
*Action: Specify at least one alter table option.
Table CUSTOMER_T altered.

Name Null Type


------------------ -------- ------------
CUSTOMERID NOT NULL NUMBER(11)
CUSTOMERNAME NOT NULL VARCHAR2(25)
CUSTOMERADDRESS VARCHAR2(30)
CUSTOMERCITY VARCHAR2(20)
CUSTOMERSTATE CHAR(2)
CUSTOMERPOSTALCODE VARCHAR2(9)
CUSTOMERTYPE VARCHAR2(20)
Table CUSTOMER_T altered.

Table CUSTOMER_T altered.

Error starting at line : 104 in command -


ALTER TABLE CUSTOMER_T
MODIFY CustomerName VARCHAR2(50) NOT NULL VALIDATE
Error report -
SQL Error: ORA-01442: column to be modified to NOT NULL is already NOT NULL
01442. 00000 - "column to be modified to NOT NULL is already NOT NULL"
*Cause:
*Action:
Table CUSTOMER_T altered.

Table CUSTOMER_T dropped.

Table ORDER_T dropped.

Table CUSTOMER_T created.

Table ORDER_T created.

Table CUSTOMER_T altered.

Table CUSTOMER_T altered.

Name Null Type


------------------ -------- ------------
CUSTOMERID NOT NULL NUMBER(11)
CUSTOMERNAME NOT NULL VARCHAR2(25)
CUSTOMERADDRESS VARCHAR2(30)
CUSTOMERCITY VARCHAR2(20)
CUSTOMERSTATE CHAR(2)
CUSTOMERPOSTALCODE VARCHAR2(9)
Table CUSTOMER_T altered.

Name Null Type


------------------ -------- ------------
CUSTOMERID NOT NULL NUMBER(11)
CUSTOMERNAME VARCHAR2(50)
CUSTOMERADDRESS VARCHAR2(30)
CUSTOMERCITY VARCHAR2(20)
CUSTOMERSTATE CHAR(2)
CUSTOMERPOSTALCODE VARCHAR2(9)
Table CUSTOMER_T altered.

Name Null Type


------------------ -------- ------------
CUSTOMERID NOT NULL NUMBER(11)
CUSTOMERNAME VARCHAR2(50)
CUSTOMERADDRESS VARCHAR2(30)
CUSTOMERCITY VARCHAR2(20)
CUSTOMERSTATE CHAR(2)
CUSTOMERPOSTALCODE VARCHAR2(9)
1 row inserted.

Name Null Type


------------------ -------- ------------
CUSTOMERID NOT NULL NUMBER(11)
CUSTOMERNAME VARCHAR2(50)
CUSTOMERADDRESS VARCHAR2(30)
CUSTOMERCITY VARCHAR2(20)
CUSTOMERSTATE CHAR(2)
CUSTOMERPOSTALCODE VARCHAR2(9)
Error starting at line : 117 in command -
INSERT INTO
CUSTOMER_T(CustomerID,CustomerName,CustomerAddress,CustomerCity,CustomerState,Custo
merPostalCode) VALUES (009,'','1853 CLARENCE','BUFFALO','NY','14230')
Error report -
SQL Error: ORA-01400: cannot insert NULL into
("SYSTEM"."CUSTOMER_T"."CUSTOMERNAME")
01400. 00000 - "cannot insert NULL into (%s)"
*Cause: An attempt was made to insert NULL into previously listed objects.
*Action: These objects cannot accept NULL values.
Error starting at line : 122 in command -
ALTER TABLE CUSTOMER_T
MODIFY CustomerName VARCHAR2(50) NOT NULL VALIDATE
Error report -
SQL Error: ORA-01442: column to be modified to NOT NULL is already NOT NULL
01442. 00000 - "column to be modified to NOT NULL is already NOT NULL"
*Cause:
*Action:
Name Null Type
------------------ -------- ------------
CUSTOMERID NOT NULL NUMBER(11)
CUSTOMERNAME VARCHAR2(50)
CUSTOMERADDRESS VARCHAR2(30)
CUSTOMERCITY VARCHAR2(20)
CUSTOMERSTATE CHAR(2)
CUSTOMERPOSTALCODE VARCHAR2(9)
Table CUSTOMER_T altered.

Table CUSTOMER_T altered.

Name Null Type


------------------ -------- ------------
CUSTOMERID NOT NULL NUMBER(11)
CUSTOMERNAME NOT NULL VARCHAR2(50)
CUSTOMERADDRESS VARCHAR2(30)
CUSTOMERCITY VARCHAR2(20)
CUSTOMERSTATE CHAR(2)
CUSTOMERPOSTALCODE VARCHAR2(9)
Table ORDER_T altered.

Name Null Type


--------- -------- ----------
ORDERID NOT NULL NUMBER(11)
ORDERDATE DATE
Table ORDER_T altered.

Table ORDER_T altered.

Name Null Type


--------- -------- ----------
ORDERDATE DATE
ORDERID NOT NULL NUMBER(11)
Error starting at line : 136 in command -
ALTER TABLE ORDER_T
ADD ORDERID number(11,0)PRIMARY KEY
Error report -
SQL Error: ORA-01430: column being added already exists in table
01430. 00000 - "column being added already exists in table"
*Cause:
*Action:

You might also like