• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • paul wheaton
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
  • Himai Minh
Bartenders:

No new sample schemas in 9i Personal Edition Scandal..

 
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have just managed to successfully install Oracle9i PE Release 9.0.1.1.1.
However, it looks as if the new sample schemas i.e. HR, OE, PM, etc., introduced to show off the newer capabilities of the Oracle database has not been included in this release of Oracle.
I am pretty certain this is the case as when I attempt to unlock one of the users in one of the new sample schemas I get an ORA-01918: user does not exist error message.
Is this some sort of oversight by Oracle? Or do they have a valid reason for this omission? Or am I just to dim to locate these new schemas?
 
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Nathan,
Do you see any scripts in the $ORACLE_HOME/demo/schema directory? If yes, follow the directions in this link
http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90129/Installation.htm#4371

If you are not seeing any scripts, then....you may have to contact oracle???
Beksy
 
Nathan Johnson
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Beksy,
I don't appear to have said scripts so I'll have to get in touch with Oracle.
Thanks again!
 
Nathan Johnson
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Can I do this online i.e. by e-mail!
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Well there is metalink, but you would need to own the full version of Oracle, at least I am pretty sure. But There must be some kind of support for personal Oracle on their web site.
Mark
 
Nathan Johnson
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Mark!
 
reply
    Bookmark Topic Watch Topic
  • New Topic