This content has been marked as final. Show 3 replies
947805 wrote:manually load & create the desired obects
Just put Express Edition on download. Was wondering if I will be able to access the 10G/11G enterprise edition demo tables. Such as the legendary "SCOTT" schema. Please enlighten me.
If they don't come in with Express Edition then how can I make them work manually.
There is a sample download on http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html
I haven't tried it, I'm assuming it is the hr stuff.
If you want the old scott schema, find the files mentioned in http://www.orafaq.com/wiki/SCOTT I think I've seen them online somewhere, but don't have time to look just now.
Edit: Just tried hr in my express, and it is there but locked. So you may simply have to unlock the accounts, which I believe is in some docs somewhere.
Edited by: jgarry on Jul 20, 2012 9:30 AM
These links may help
Some of these examples may require features not available in XE - http://docs.oracle.com/cd/E17781_01/license.112/e18068/toc.htm#BABJBGGA