Oracle Sample Schema's? [message #296329] |
Fri, 25 January 2008 16:30  |
Maccers
Messages: 2 Registered: January 2008
|
Junior Member |
|
|
Hi,
First off, apologies if this is the wrong place to ask
I have just installed Oracle XE, and have unlocked the HR Schema and all seems fine.
I've been reading around and have found reference to some other sample schema's (BI, IX, OE, PM, and SH).
Could anyone advise if these are these freely available? I have read they are on the "Companion CD", but was wondering if they installation scripts are down-loadable?
I have searched Google and the Oracle site but am going round in circles a bit.
Thanks for your time,
Ross
|
|
|
Re: Oracle Sample Schema's? [message #296333 is a reply to message #296329] |
Fri, 25 January 2008 19:50   |
 |
Barbara Boehmer
Messages: 9104 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
There are various editions for each version, like Enterprise Edition, Personal Edition, Express Edition. The Express Edition that you have is the minimal edition with the fewest features so that it can run on the smallest slowest systems. The Express Edition is the only edition for which there is no corresponding companion CD. In older versions like 9i, all of the sample schema scripts were available in the online documentation, as well as downloadable, and you could just copy and paste from the documentation. You can still find some of them in the 9i documentation:
http://download.oracle.com/docs/cd/B10501_01/server.920/a96539/scripts.htm#SQLRF001
The structures of some of the newer ones are listed in the 10g documentation, but without the complete scripts:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14198/scripts.htm#sthref77
Some of these things may require features that your Express Edition does not have, so they may not run.
|
|
|
|