Hi I am new to Data base administration.I have using Oracle 10.2.0.1 with fedora 9.0.I am trying to run the demobld script which gives me some default tables but when I am trying to runi it,its throwing me an error like the demobld script not found.I ran to the ORACLE_HOME/sqlplus and checked ,there is no script as demobld,Please help me where I can found the script ??
10-17-2008, 09:20 AM
Just in case you haven't found it yet.
-- Copyright (c) Oracle Corporation 1999. All Rights Reserved.
-- This script creates the SQL*Plus demonstration tables in the
-- current schema. It should be STARTed by each user wishing to
-- access the tables. To remove the tables use the demodrop.sql
-- SQL> START demobld.sql
SET TERMOUT ON
PROMPT Building demonstration tables. Please wait.
SET TERMOUT OFF
DROP TABLE EMP;
DROP TABLE DEPT;
DROP TABLE BONUS;
DROP TABLE SALGRADE;
DROP TABLE DUMMY;
CREATE TABLE EMP
(EMPNO NUMBER(4) NOT NULL,
SAL NUMBER(7, 2),
COMM NUMBER(7, 2),