I'm studying Oracle database and have to do some exercises with default "HR" schema. But I think that data in my tables is changed from default values (many students have access to DB and may be someone changed data). Where can I get SQL to construct default "HR" schema?
A:
See this link: http://download.oracle.com/docs/cd/B19306_01/server.102/b14198/installation.htm#sthref33
It's under $ORACLE_HOME/demo/schema/human_resources
René Nyffenegger
2010-03-16 08:37:10
Unfortunately, I haven't access to filesystem on server.
Dmitry
2010-03-16 08:43:26
+1
A:
So, if you don't have access to the server filesystem, you should try http://www.oracle.com/technology/obe/obe11jdev/11/common/files/sample_schema_scripts.zip
As per http://www.oracle.com/technology/obe/obe11jdev/11/common/connection11g.htm#t1s1 it's for Oracle 10g and 11g.
René Nyffenegger
2010-03-16 09:00:13
@Rene, just FYI - you can edit your answer instead of answering again.
Jeffrey Kemp
2010-03-16 09:27:35
Thanks for the info, but I thought the first answer was the more approbriate one for people that DO have access to the file system while this answer is the better answer for people without such access.
René Nyffenegger
2010-03-16 09:33:42