Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> SQL*Plus and running demobld.SQL
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
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 )
32 -- ============================================================33 -- 2 Object: Table Dmns
34 -- ============================================================......
![]() |
![]() |