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
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: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
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: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
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
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
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: ORA-02303: cannot drop or replace a type with type or table dependents
Next Topic: Getting DISTINCT count from two different columns
Goto Forum:
  


Current Time: Thu Dec 08 22:19:31 CST 2016

Total time taken to generate the page: 0.18848 seconds