Home » SQL & PL/SQL » SQL & PL/SQL » oracle sample schemas(hr,oe)
oracle sample schemas(hr,oe) [message #355229] Thu, 23 October 2008 03:32 Go to next message
onoank
Messages: 3
Registered: October 2008
Karma: 0
Junior Member
Hello everyone
I am very new to oracle tech. I am working with 10g. So i follow some tutorials for jdeveloper. But i have not sample schmeas under oracle directories. So i found hr schmea's hr_install.sql script from jdeveloper handbook authors web site and created and populated hr schema. But i can not find scripts for other schemas.Especially i need oe schemas script.

In http://download.oracle.com/docs/cd/B10501_01/server.920/a96539/scripts.htm#26747
there are some scripts but there are no scripts for populating schemas

Where can i find that scripts to create and populate schemas

Thanks

[Updated on: Thu, 23 October 2008 03:34]

Report message to a moderator

Re: oracle sample schemas(hr,oe) [message #355235 is a reply to message #355229] Thu, 23 October 2008 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
They are on the database server CD.

Regards
Michel
Re: oracle sample schemas(hr,oe) [message #355240 is a reply to message #355229] Thu, 23 October 2008 03:47 Go to previous messageGo to next message
onoank
Messages: 3
Registered: October 2008
Karma: 0
Junior Member
thanks but there is no chance to find cd
Re: oracle sample schemas(hr,oe) [message #355255 is a reply to message #355240] Thu, 23 October 2008 05:16 Go to previous messageGo to next message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
CD is a generic term, you can find the same to download on otn:
http://www.oracle.com/technology/software/products/oracle9i/index.html

Regards
Michel
Re: oracle sample schemas(hr,oe) [message #355270 is a reply to message #355255] Thu, 23 October 2008 05:40 Go to previous messageGo to next message
onoank
Messages: 3
Registered: October 2008
Karma: 0
Junior Member
thanks but it is not possible for me to download 700mb file because of my slow internet connection.

If someone can show me way of just downloading samples, i will be very happy

thanks michel
Re: oracle sample schemas(hr,oe) [message #355417 is a reply to message #355270] Fri, 24 October 2008 00:01 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Karma: 0
Senior Member
How did you get your db installed then?
Re: oracle sample schemas(hr,oe) [message #541700 is a reply to message #355229] Wed, 01 February 2012 22:29 Go to previous message
qfar
Messages: 1
Registered: February 2012
Location: Ireland
Karma: 0
Junior Member
Hi,

I had the same problem and noticed that Oracle Database 10/11g Express Edition doesn't come with OE schema pré installed, only the HR. Neither brings the necessary files for manual installation.

I was able to obtain the OE schema files in here:
(http) slimlab.net/downloads/viewdownload/4-database/5-oracle-database-sample-schemas-oe-order-entry.html

And then follow the procedure on this guide:
(http) docs.oracle.com/cd/B28359_01/server.111/b28328/title.htm

Hope this helps.

Cheers
Previous Topic: Comparing similar strings in a table
Next Topic: looking for records with newest dates (merged)
Goto Forum:
  


Current Time: Tue Aug 22 13:47:14 CDT 2017

Total time taken to generate the page: 0.01807 seconds