2 Replies Latest reply: Jun 27, 2011 5:40 AM by 871553 RSS

    file read errors when installing the oe schema.

    871553
      Hi,

      I'm new to Oracle and I've been playing around with the sample hr schema that came included with Oracle 11g XE (installed on a machine running Windows 7). I downloaded the oe schema off the otn website and I'm trying to install the sample database. I've pasted the errors I get in SQL Plus below.

      I'm assuming the 'unable to open *.sql' errors are because oracle is looking for them in a different directory. Those files are present in the same directory as oe_main.sql whose location I specify at the start. Should'nt this be enough?

      Thanks,
      Aditya

      #####################################################
      SQL*Plus: Release 11.2.0.2.0 Beta on Mon Jun 27 13:45:03 2011

      Copyright (c) 1982, 2010, Oracle. All rights reserved.

      SQL> connect sys as sysdba
      Enter password:
      Connected.
      SQL> @?/demo/schema/oe/oe_main.sql
      Enter value for sys_password: oe

      User dropped.

      old 1: CREATE USER OE IDENTIFIED BY &pass
      new 1: CREATE USER OE IDENTIFIED BY OE

      User created.

      old 1: ALTER USER OE DEFAULT TABLESPACE &tbs
      new 1: ALTER USER OE DEFAULT TABLESPACE users
      old 2: QUOTA UNLIMITED ON &tbs
      new 2: QUOTA UNLIMITED ON users

      User altered.

      old 1: ALTER USER OE TEMPORARY TABLESPACE &ttbs
      new 1: ALTER USER OE TEMPORARY TABLESPACE temp

      User altered.


      Grant succeeded.


      Grant succeeded.

      Connected.

      Grant succeeded.

      Connected.

      Session altered.


      Session altered.

      SP2-0310: unable to open file "oe_cre.sql"
      SP2-0310: unable to open file "oe_p_cat.sql"
      SP2-0310: unable to open file "oe_p_pi.sql"
      SP2-0310: unable to open file "oe_p_cus.sql"
      SP2-0310: unable to open file "oe_p_ord.sql"
      SP2-0310: unable to open file "oe_p_itm.sql"
      SQL>

      Edited by: 868550 on 27-Jun-2011 01:26