Hi all,

I am having problem doing the spool files for my current project. Everytime I try to spool, I get the following error:

COLUMN parts_TP_prt_unit_price FORMAT A32;
SQL> COLUMN part_num FORMAT A20;
SQL> COLUMN parts_TP FORMAT A15;
SQL> SELECT parts_TP_prt_unit_price, part_num, parts_TP FROM table_creatorfinal33114Part1.sql;
SELECT parts_TP_prt_unit_price, part_num, parts_TP FROM table_creatorfinal33114Part1.sql
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> WHERE parts_TP_prt_unit_price NOT LIKE 'BIN%';
SP2-0734: unknown command beginning "WHERE part..." - rest of line ignored.
SQL>

I am wondering if somebody could help understand on how to spool the following codes:

CREATE TABLE customers_TP
(customer_id NUMBER (6),
customer_last_name VARCHAR2 (30)
CONSTRAINT cust_TP_cust_lname_nn NOT NULL,
customer_first_name VARCHAR2 (25)
CONSTRAINT cust_TP_cust_fname_nn NOT NULL,
customer_street VARCHAR2 (25)
CONSTRAINT cust_TP_cust_street_nn NOT NULL,
customer_city VARCHAR2 (25)
CONSTRAINT cust_TP_cust_city_nn NOT NULL,
customer_state CHAR (2)
CONSTRAINT cust_TP_cust_state_nn NOT NULL,
customer_zip_code CHAR (5)
CONSTRAINT cust_TP_cust_zip_nn NOT NULL,
customer_phone_num CHAR (10)
CONSTRAINT cust_TP_cust_phone_nn NOT NULL,
customer_alt_phone CHAR (10),
CONSTRAINT cust_TP_cust_id_pk PRIMARY KEY (customer_id));

CREATE TABLE technicians_TP
(technician_num NUMBER (2),
technician_last_name VARCHAR2 (30)
CONSTRAINT tech_TP_tech_lname_nn NOT NULL,
technician_first_name VARCHAR2 (25)
CONSTRAINT tech_TP_tech_fname_nn NOT NULL,
CONSTRAINT tech_TP_tech_num_pk PRIMARY KEY (technician_num));

CREATE TABLE ownerships_TP
(customer_id NUMBER (6),
car_vin CHAR (17)
CONSTRAINT owner_TP_car_vin_nn NOT NULL,
CONSTRAINT owner_TP_cust_id_pk PRIMARY KEY (customer_id, car_vin),
CONSTRAINT owner_TP_cust_num_fk FOREIGN KEY (customer_id)
REFERENCES customers_TP (customer_id),
CONSTRAINT ownerships_TP_car_vin_fk FOREIGN KEY (car_vin)
REFERENCES vehicles_TP (car_vin));

CREATE TABLE invoices_TP
(invoice_num NUMBER (6),
customer_id NUMBER (6)
CONSTRAINT inv_TP_cust_nn NOT NULL,
car_vin CHAR (17)
CONSTRAINT inv_TP_car_vin_in_nn NOT NULL,
invoice_date_in char(8)
CONSTRAINT inv_TP_inv_date_out_nn NOT NULL,
invoice_date_out char(8)
CONSTRAINT inv_TP_inv_mile_in_nn NOT NULL,
invoice_inv_sls_tax NUMBER (5,2)
CONSTRAINT inv_TP_inv_sls_tax_nn NOT NULL,
technician_num NUMBER (2)
CONSTRAINT inv_TP_tech_num_nn NOT NULL,
service_advisor VARCHAR2 (10)
CONSTRAINT inv_TP_serv_nn NOT NULL,
CONSTRAINT inv_TP_inv_num_pk PRIMARY KEY (invoice_num),
CONSTRAINT inv_TP_car_vin_fk FOREIGN KEY (car_vin)
REFERENCES vehicles_TP (car_vin),
CONSTRAINT inv_TP_inv_car_vin_fk FOREIGN KEY (customer_id)
REFERENCES customers_TP (customer_id),
CONSTRAINT inv_TP_tech_num_fk FOREIGN KEY (technician_num)
REFERENCES technicians_TP (technician_num));

CREATE TABLE parts_sls_TP
(invoice_num NUMBER (6),
part_num NUMBER (8)
CONSTRAINT prt_num_TP_nn NOT NULL,
part_unit_price NUMBER (6,2)
CONSTRAINT prt_unit_price_nn NOT NULL,
part_qty_sold CHAR (8)
CONSTRAINT prt_qty_sold_TP_nn NOT NULL,
CONSTRAINT prt_sls_TP_inv_num_pk PRIMARY KEY (invoice_num, part_num),
CONSTRAINT prt_sls_TP_inv_num_fk FOREIGN KEY (invoice_num)
REFERENCES invoices_TP (invoice_num),
CONSTRAINT prt_sls_TP_part_num_fk FOREIGN KEY (part_num)
REFERENCES parts_TP (part_num));

/*rem this sequence is used to increase with every new customer*/
CREATE SEQUENCE cust_id_seq
INCREMENT BY 1
START WITH 367888
NOCYCLE;

/*this sequence is used to increase with every new invoice*/
CREATE SEQUENCE inv_num_seq
INCREMENT BY 1
START WITH 160000
NOCYCLE;

The following codes have to be spool with the current commands that our teacher gave us:

To get information about constraints:
COLUMN constraint_name FORMAT A32;
COLUMN column_name FORMAT A20;
COLUMN table_name FORMAT A15;
SELECT constraint_name, column_name,table_name
FROM user_cons_columns
WHERE constraint_name NOT LIKE 'BIN%'
ORDER BY constraint_name;

To get information about sequences:
SELECT sequence_name, increment_by
FROM user_sequences;

Any help would be appreciated