Installing the Oracle9i Sample Schemas If you have dropped the sample schemas from Oracle9i or did not install them in the first place you should install them following the instructions in the Sample Schemas documentation which is available as part of the Oracle9i Database documentation set and on OTN (Oracle Technology Network) at http://otn.oracle.com. From OTN, navigate to Documentation. Select Oracle9i Database, then HTML & PDF Oracle9i Database Online Documentation. From the List of books, find Sample Schemas. If you are using the sample schemas for the first time, you may find that you have to unlock the HR and OE sample schema users, and then grant CONNECT and RESOURCE roles to them. You can do this using the Oracle Enterprise Manager, which is part of Oracle9i.