This discussion is archived
2 Replies Latest reply: Jun 27, 2011 3:40 AM by 871553 RSS

file read errors when installing the oe schema.

871553 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points