The New 9i Sample Schemas

Throughout the first three chapters of this book, we have seen the use of database schemas such as SCOTT and HR. If you don’t already know, these database schemas are prepackaged by Oracle with the database. For many years now, Oracle instructors, administrators, programmers, and users have been using the trusty SCOTT schema for simple queries, updates, and deletes in order to learn, test, and/or tune their databases. These schemas are what we call sample schemas. Sample schemas are collections of database objects such as tables, views, and indexes, which come prepopulated with data representative of a small or medium-sized company.