Re: SQL*Plus and running demobld.SQL

The correct syntax to run existing files is @demobld.sql
or
start demobld.sql

You probably have all statements in one sql buffer, and Oracle now doesn't understand the sqlplus commands
The same applies to the second example.

Hth,

--
Sybrand Bakker, Oracle DBA

bob <NoSpam_RSterling_at_bionetrix.com> wrote in message
news:BJsd4.25000$W2.300559_at_iad-read.news.verio.net...


> I am trying to run the demobld.SQL which is under the sql*plus/demo

> directory.  I load it, do run and it returns:

>

> set termout on

>     *

> ERROR at line 10:

> ORA-00922: missing or invalid option

>

> What are the rules behind using SQL*Plus, or is there a better tool to run

> these scripts?

> Oracle 8.1.5

> NT 4.0 Svc Pack 6

>

> Thanks for the help,

> Bob

>

> I have tried other things, such as a script where I am creating tables and

> have not had any success (similiar problems).

>

>   1  /**********************************************************/

>   2  /*  COPYRIGHT TCI 1999 All Rights Reserved                */

>   3  /*                                                        */

>   4  /*  This Software is Protected by United States Copyright */

>   5  /*  AND International Treaty. Unauthorized Duplication,   */

>   6  /*  Distribution or Use is Prohibited.                    */

>   7  /*                                                        */

>   8  /**********************************************************/

>   9  -- ============================================================

>  10  --   Database name:  biodb

>  11  --   DBMS name    :  ORACLE8i Version 8.1.5

>  12  --   Developed by :  Tatyana Gurevich

>  13  --   Created on   :  08/05/99  10:07 AM

>  14  --   Modified on  :  08/27/99  10:30 AM

>  15  -- ============================================================

>  16  -- ============================================================

>  17  --                                 CREATE

>  18  -- ============================================================

>  19  -- ============================================================

>  20  -- 1  Object: Table Apps

>  21  -- ============================================================

>  22  create table Apps

>  23  (

>  24      AppID                NUMBER(8)           not null,     /*

> Seq_Apps*/

>  25      AppName              NVARCHAR2(128)      not null,

>  26      AppCLSID             NVARCHAR2(50)       not null,

>  27      constraint PK_APPS primary key (AppID),

>  28     constraint UNQ_APPNAME_IDX  UNIQUE (AppName),

>  29     constraint UNQ_APPCLSID_IDX  UNIQUE (AppCLSID)

>  30  )

>  31  /

>  32  -- ============================================================

>  33  --  2 Object: Table Dmns

>  34  -- ============================================================...

> ...

> /

> *

> ERROR at line 31:

> ORA-00922: missing or invalid option

>

>