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
Maccers
Messages: 2
Registered: January 2008
Junior Member
Hi,

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,

Ross
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: 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.




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

I will try copying those out.


Thanks for your reply,

Ross

Smile
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: Mon Feb 10 09:38:55 CST 2025