OraFAQ Forum: SQL & PL/SQL » oracle sample schemas(hr,oe)

Home » SQL & PL/SQL » SQL & PL/SQL » oracle sample schemas(hr,oe)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle sample schemas(hr,oe) [message #355229]

Thu, 23 October 2008 03:32

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

They are on the database server CD.

Regards
Michel

Report message to a moderator

Re: oracle sample schemas(hr,oe) [message #355240 is a reply to message #355229]

Thu, 23 October 2008 03:47

onoank
Messages: 3
Registered: October 2008

Junior Member

thanks but there is no chance to find cd

Report message to a moderator

Re: oracle sample schemas(hr,oe) [message #355255 is a reply to message #355240]

Thu, 23 October 2008 05:16

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: oracle sample schemas(hr,oe) [message #355270 is a reply to message #355255]

Thu, 23 October 2008 05:40

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

Report message to a moderator

Re: oracle sample schemas(hr,oe) [message #355417 is a reply to message #355270]

Fri, 24 October 2008 00:01

Frank
Messages: 7901
Registered: March 2000

Senior Member

How did you get your db installed then?

Report message to a moderator

Re: oracle sample schemas(hr,oe) [message #541700 is a reply to message #355229]

Wed, 01 February 2012 22:29

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 17 15:44:54 CDT 2025