Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Sample Schema's? (Oracle XE)
Oracle Sample Schema's? [message #296329] Fri, 25 January 2008 16:30 Go to next message
Messages: 2
Registered: January 2008
Junior Member

First off, apologies if this is the wrong place to ask Razz

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,

Re: Oracle Sample Schema's? [message #296333 is a reply to message #296329] Fri, 25 January 2008 19:50 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8737
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:


The structures of some of the newer ones are listed in the 10g documentation, but without the complete scripts:


Some of these things may require features that your Express Edition does not have, so they may not run.

Re: Oracle Sample Schema's? [message #296357 is a reply to message #296329] Sat, 26 January 2008 02:31 Go to previous message
Messages: 2
Registered: January 2008
Junior Member

I will try copying those out.

Thanks for your reply,


Previous Topic: How to incorporatet file that will be written to AS using DS package
Next Topic: dataware house query help !
Goto Forum:

Current Time: Wed Aug 23 14:36:53 CDT 2017

Total time taken to generate the page: 0.03823 seconds