| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Plus and running demobld.SQL
bob wrote:
>
> 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
Don't load it. There are very few cases where a sql script should be loaded before being run.
There are three ways of running the script:
You probably also have a shell script named demobld in the $ORACLE_HOME/bin directory. To run it just enter:
$ORACLE_HOME/bin/demobld scott/tiger
..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... ..................................................... .....................................................Received on Mon Jan 10 2000 - 06:54:08 CST
 |
 |