Really needing help with this Oracle problem. Here are the provided instructions:

• Install Oracle if you have not done it already.
• Download the script file, BuildIGGY.sql and move it to C:\CIS4210
• Start the COMMAND PROMPT and type in the following lines:

• sqlplus SYSTEM/password
• START C:\CIS4210\BuildIGGY.sql
• SPOOL C:\CIS4210\M1spool.txt
• DESCRIBE iggy.part;
• SELECT * FROM iggy.part;
• DESCRIBE iggy.supplier;
• SELECT * FROM iggy.supplier;
• DESCRIBE iggy.quote;
• SELECT * FROM iggy.quote;
• SPOOL OFF;
• QUIT;

Note: The password for SYSTEM is the one chosen during installation.

Here are the contents of BuildIGGY.sql :

/* Log into SQLPLUS as SYSTEM and run this script */

/* This script creates user SCOTT and builds four tables */

/* THIS IS FOR Oracle 12c */

SET ECHO ON

SET SQLBLANKLINES ON

REM The next command will fail on the first run

DROP USER IGGY CASCADE;

CREATE USER IGGY IDENTIFIED BY oracle;

GRANT CREATE SESSION TO iggy;

GRANT CONNECT, RESOURCE TO iggy;

ALTER USER IGGY ACCOUNT UNLOCK;

ALTER USER IGGY DEFAULT TABLESPACE USERS;

ALTER USER IGGY QUOTA 10M ON USERS;

ALTER USER IGGY TEMPORARY TABLESPACE TEMP;

/* ------------ Create Tables -------------- */

CREATE TABLE IGGY.supplier (

supplierName VARCHAR(32) NOT NULL,

PRIMARY KEY (supplierName))

TABLESPACE USERS;\

CREATE TABLE IGGY.part (

partName VARCHAR(32) NOT NULL,

PRIMARY KEY (partName)) TABLESPACE USERS;

CREATE TABLE IGGY.quote (

supplierName VARCHAR(32) NOT NULL,

partName VARCHAR(32) NOT NULL,

quote NUMBER(8,2) NOT NULL,

PRIMARY KEY (supplierName,partName),

FOREIGN KEY (supplierName) REFERENCES IGGY.supplier,

FOREIGN KEY (partName) REFERENCES IGGY.part)

TABLESPACE USERS;

/* ------------ Add Data to Tables -------------- */

INSERT INTO IGGY.supplier

VALUES ('NEW YANKEE WORKSHOP, INC.');

INSERT INTO IGGY.supplier

VALUES ('OLD YANKEE WORKSHOP, INC.');

INSERT INTO IGGY.supplieR

VALUES ('TOOL TIME, INC.');

INSERT INTO IGGY.part

VALUES ('HAMMER');

INSERT INTO IGGY.part

VALUES ('NAIL');

INSERT INTO IGGY.quote

VALUES ('NEW YANKEE WORKSHOP, INC.','HAMMER','1.89');

INSERT INTO IGGY.quote

VALUES ('NEW YANKEE WORKSHOP, INC.','NAIL','0.19');

INSERT INTO IGGY.quote

VALUES ('OLD YANKEE WORKSHOP, INC.','HAMMER','2.09');

INSERT INTO IGGY.quote

VALUES ('TOOL TIME, INC.','HAMMER','1.99');

INSERT INTO IGGY.quote

VALUES ('TOOL TIME, INC.','NAIL','0.20');

When finished, submit your text document.