Hello,
I have been looking everywhere for a simple way to install the HR, OE, etc... sample schemas. If you do not have the files already somewhere on your system, this is a pretty good way to get these schemas:
1. Download the Oracle Examples from:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Choose your version and operating system and click on "See All". On the next page select and download the "Examples".
2. Copy the archive to your system
3. Extract the archive, you will have an "examples" folder now.
4. Go to examples/stage/Components/oracle.rdbms.companion/11.2.0.1.0/1/DataFiles
There you find a lot of filegroupX.jar files.
5. For the specific schema you want, extract the filegroupX.jar file:
9 - BI
10 - HR
11 - IX
12 - mksample.sql
13 - OE
14 - PM
15 - SH
For example, for the HR schema, do: unzip filegroup10.jar
This will create a "demo" folder.
6. Copy the whole "human_resources" folder to ORACLE_HOME/demo/schemas/
7. Go into the $ORACLE_HOME/demo/schema/human_resources folder
7. In your SQL-Tool (SQLPLus, SQL Developer, etc..) run the hr_main.sql as SYS-User!!! out of the human_resources folder. This will install the schema for you.
I really like your take on the issue. I now have a clear idea on what this matter is all about.. Pflegetagegeldversicherung
ReplyDeletethank you for your interesting infomation. apartment kroatien
ReplyDeleteI can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me.. Thanks for all your help and wishing you all the success in your business. his comment is here
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteI really loved reading your blog. It was very well authored and easy to understand. Unlike other blogs I have read which are really not that good.Thanks alot! other
ReplyDeleteHi all dear !!
ReplyDeletegreat article and information, with your blogcomment.
I see your blog daily, it is crispy to study.
Your blog is very useful for me & i like so much.
dragoon slots
Ich finde es toll, was ihr so macht. Diese Art von intelligenter Arbeit und Berichten! Machen Sie weiter so, ich habe Sie in meine eigene Blogroll aufgenommen. Schinken
ReplyDeleteHi I did not know the subject, thanks for sharing it helped me a lot to understand a little better I will search more!
ReplyDeletewordpress
ufa88kh.blogspot
youtube
UFA88 online casino in cambodia