SET TERMOUT ON
PROMPT Building Hotel tables. Please wait.
--SET TERMOUT OFF
DROP TABLE BD;
DROP TABLE BR;
DROP TABLE D;
DROP TABLE R;
CREATE TABLE RT
(TYPE VARCHAR2(11) NOT NULL,
CONSTRAINT roomtype_pk PRIMARY KEY(TYPE));
INSERT INTO RT VALUES ('MAGNIFICENT', 200.00);
Hey all, something strange about SQLPlus oracle sql statements to note here. I have a create.sql file which looks like the above snippet example, which builds my database tables. Contains both 'INSERT' and 'CREATE' statements. Today and yesterday its working fine on terminal, all tables being dropped and created as instructed. I leave home it being working fine and come home and execute start create.sql and apprently all tables does not exist!!!!
ORA-00942: table or view does not exist
No matter what I do, restart computer, restart terminal, change file name... nothing works. No line has changed since leaving it working fine. Whats the issue. Note I do have foreign key constraints which are correctly integrated with tables. The same happened to my group member working on the same file. but different times.