Installing OE (order entry schema) into Oracle 11G XE

3178473

I was able to successfully install the HR Schema, which came with Oracle 11g XE

I was able to downloade the log? files needed to install the OE schema and I placed it in the "schema" folder, which is the same location as the HR schema. C:\oraclexe\app\oracle\product\11.2.0\server\demo\schema\order_entry

I conneced as user "system" and attempted to install the OE schema in sql plus.  Just below are the following prompts and the commands I have used.  Can you tell what I am doing wrong?  I understand this is a detailed question and any help is much appreciated.

After logging in I typed in "@C:\oraclexe\app\oracle\product\11.2.0\server\demo\schema\order_entry\oe_main.sql"

Prompt 1

PROMPT specify password for OE as parameter 1:

I typed in "OE"

PROMPT 2

PROMPT specify default tablespeace for OE as parameter 2:

I typed in "table"

PROMPT 3

PROMPT specify temporary tablespace for OE as parameter 3:

DEFINE ttbs

I typed in "temp"

PROMPT 4

PROMPT specify password for HR as parameter 4:

I typed in "HR"

PROMPT 5

PROMPT specify password for SYS as parameter 5:

I typed in "SYS"

PROMPT 6

PROMPT specify directory path for the data files as parameter 6:

I typed in "@C:\oraclexe\app\oracle\product\11.2.0\server\demo\schema\order_entry"

PROMPT 7

PROMPT writeable directory path for the log files as parameter 7:

I typed in "@C:\oraclexe\app\oracle\product\11.2.0\server\demo\schema\order_entry"

PROMPT 8

PROMPT specify version as parameter 8:

I had no idea what to put here

Dude!

I suggest to post in the forum for closer topic alignment.

It is possible that you need EE or standard edition in order to use these scripts.