Load SQL File:

/* log in as SYSTEM and run this script */ SET ECHO ON SET SQLBLANKLINES ON

REM The next command will fail on the first run DROP USER iggy CASCADE; CREATE USER iggy PROFILE DEFAULT IDENTIFIED BY oracle DEFAULT TABLESPACE USERS ACCOUNT UNLOCK; GRANT CONNECT TO iggy; GRANT RESOURCE TO iggy;

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');

INSTRUCTIONS

Download the scipt provided above (LoadDB.sql) to C:\CIS4210

Run sqlplus SYSTEM/Oracle11

Enter START C:\CIS4210\LoadDB.sql

Enter 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;

I would need the spool.txt file