Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SQL*Plus and running demobld.SQL

SQL*Plus and running demobld.SQL

From: bob <NoSpam_RSterling_at_bionetrix.com>
Date: 2000/01/07
Message-ID: <BJsd4.25000$W2.300559@iad-read.news.verio.net>#1/1

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 Received on Fri Jan 07 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US