This discussion is archived
7 Replies Latest reply: Feb 7, 2013 2:31 AM by 984441 RSS

download order entry schema for XE?

984441 Newbie
Currently Being Moderated
How can I get the current version of the order entry schema for XE?

There' s another question marked as answered, but the download links don't work.
The oracle developer days vm comes with a folder order_entry, but it contains the oc schema only.

Can anybody help me? I tried several things, it didn't work.
  • 1. Re: download order entry schema for XE?
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl post OS and XE versions.

    Have you looked at the install guide - http://docs.oracle.com/cd/E11882_01/server.112/e10831/toc.htm ?

    HTH
    Srini
  • 2. Re: download order entry schema for XE?
    984441 Newbie
    Currently Being Moderated
    Thanks for youre response.

    The XE version is 11.2.0 running on Windows 8.

    I want to follow the examples of the oracle press book "Quick Start Guide to Oracle Fusion Development", which are based on the OE schema.
    I already have successfuly installed the required HR schema, following this installation guide, chapter "Manually Installing Sample Schemas":

    http://docs.oracle.com/cd/B28359_01/server.111/b28328/installation.htm#CHDHGIHA

    This folder contains the HR schema only:
    C:\oraclexe\app\oracle\product\11.2.0\server\demo\schema

    The OE schema ist missing, so I can't proceed. It looks like a have to obtain the OR-Scripts anywhere.

    Is it possible to download the OE schema separetly?

    Ralf
  • 3. Re: download order entry schema for XE?
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl see if this link can help

    http://docs.oracle.com/cd/E11882_01/install.112/e24501/toc.htm#BABBIBJF

    HTH
    Srini
  • 4. Re: download order entry schema for XE?
    984441 Newbie
    Currently Being Moderated
    Thanks again Srini, I have tried your suggestion.
    The installation of the database examples aborts with inconsistent confusing error messages. it says (in german) something like: "the examples can only be installed in an existing oracle home. the oracle home already contains folders. oracle home contains software, which is leading to a conflict. "

    But oracle home is correct:
    C:\oraclexe\app\oracle\product\11.2.0\server

    There's enough disk space and admin privileges.
    Is it generally possible to use the examples whith XE?

    Ralf
  • 5. Re: download order entry schema for XE?
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Yes it should be possible to use the examples with XE - I do not believe they have any special requirements. Can you pl post the complete error messages and codes ?

    HTH
    Srini
  • 6. Re: download order entry schema for XE?
    orafad Oracle ACE
    Currently Being Moderated
    How come you have chosen XE for db server?

    The Examples installation is based on OUI, but XE isn't, which could be why you get that error.

    Take a look at the OTN dev license -- it may fit your case and purpose, so possibly you may base environment for learning on EE or SE instead. (otn.oracle.com -> Downloads)

    Oh, I did not even think of it before.... Since you need to agree to the license to be able to download and use the Examples media in the first place, this should not be an issue.


    If you want to continue with XE anyway, follow info/links in this thread about manual install of Samples Schemas on XE:
    Error installing Sample Schemas in Oracle XE11

    The "demo" scripts for manual install of Sample Schemas can be extracted from examples\stage\Components\oracle.rdbms.companion\11.2.0.1.0\1\DataFiles\filegroupX.jar
    Where X = 13 for OE and X = 10 for HR.

    Parts of OE may not be possible to create with XE, since certain features are not included. You may also need to drop the included HR and install HR from Examples demo scripts first, since OE depends on it and the version included with XE may not be the "full" HR Sample schema.


    Edit;
    added extract and install stuff

    Edited by: orafad on Feb 6, 2013 7:39 PM

    Edited by: orafad on Feb 7, 2013 12:05 AM
  • 7. Re: download order entry schema for XE?
    984441 Newbie
    Currently Being Moderated
    Sorry, I didn't know about the dev license.
    Of course I am going to use Standard/Enterprise Edition.

    I already tried the installation of the standard edition on my windows 8 PC and encountered a problem with the NET configuration.
    But I think this doesn't belong to the XE forum here.

    Maybe I return to XE for a small project later.

    Thank you guys for your great help and support.

    Ralf

Legend

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