Forum Stats

  • 3,757,055 Users
  • 2,251,192 Discussions
  • 7,869,716 Comments

Discussions

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

3178473
3178473 Member Posts: 2

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

Tagged:
3178473

Answers

This discussion has been closed.