Re: How to insert values?

Me wrote:
> On Mon, 19 May 2003 12:46:08 +0000, andrewst wrote:
> :<snip>
>
> SQL*Plus: Release 8.1.5.0.0 - Production on Mon May 19 22:11:08 2003
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle8i Personal Edition Release 8.1.5.0.0 - Production
> With the Java option
> PL/SQL Release 8.1.5.0.0 - Production
>
> SQL> @C:\WINDOWS\DESKTOP\TEMP.SQL
> Input truncated to 1 characters
> CREATE SCHEMA AUTHORIZATION myschema
> *
> ERROR at line 1:
> ORA-02421: missing or invalid schema authorization identifier
>
>
>
> ______________________________________________________
>
>
> Contents of temp.sql
> CREATE SCHEMA AUTHORIZATION myschema
> CREATE TABLE EMPLOYEE
> (
> FNAME VARCHAR(15) NOT NULL,
> MINIT CHAR,
> LNAME VARCHAR(15) NOT NULL,
> SSN CHAR(9) NOT NULL,
> BDATE DATE,
> ADDRESS VARCHAR(30),
> SEX CHAR,
> SALARY DECIMAL(10,2),
> SUPERSSN CHAR(9),
> DNO INT NOT NULL,
> PRIMARY KEY(SSN),
> FOREIGN KEY(SUPERSSN) REFERENCES EMPLOYEE(SSN),
> FOREIGN KEY(DNO) REFERENCES DEPARTMENT(DNUMBER) DEFERRABLE
> INITIALLY DEFERRED
> )
> CREATE TABLE DEPARTMENT
> (
> DNAME VARCHAR(15) NOT NULL,
> DNUMBER INT NOT NULL,
> MGRSSN CHAR(9) NOT NULL,
> MGRSTARTDATE DATE,
> PRIMARY KEY(DNUMBER),
> UNIQUE(DNAME),
> FOREIGN KEY(MGRSSN) REFERENCES EMPLOYEE(SSN))
> __________________________________________________________________
> I hope I have not reported something very stupid here, but it is my
> first time.
>
> Just give your opinion:
> Why do you think the author chose such a complicated example? 8-(
>
> Thanks a lot.

Is your username "myschema"? Looks like it's not. Replace myschema with your username. Full docu on create schema can be found on tahiti.oracle.com Is this an oracle book anyway?

-- 
Regards, Frank van Bortel