Oracle XML DB is a feature of the Oracle Database. It provides a high-performance, native XML storage and retrieval technology. Oracle XML DB is installed automatically in the following situations: If Database Configuration Assistant (DBCA) is used to build Oracle Database using the general-purpose template.
![](/uploads/1/2/8/1/128130581/980288386.jpg)
The Sample Schemas provide a common platform for examples in each release of. They are easy to use for testing and training purposes.
All documentation and training materials refer to the Sample Schemas environment.Following are Oracle Sample Schemas– OE (Order Entry schema) – useful for dealing with matters of intermediate complexity. Many data types are available in this schema, including non-scalar data types.– HR (Human Resources schema) – useful for introducing basic topics. An extension to this schema supports Oracle Internet Directory demos.– PM (Product Media schema) is dedicated to multimedia data types.– IX (Information Exchange main schema) includes a set of schemas for demonstrate Oracle Advanced Queuing capabilities– SH (Sales History schema) is designed to allow for demos with large amounts of data. An extension to this schema provides support for advanced analytic processing.– SCOTT – old-fashioned famous schema with its two prominent tables EMP and DEPT that is used by Oracle for many years.– BI – includes only synonyms on SH schemaWith this simplicity I personally found difficulties in creating Sample Schemas in Oracle 11g database. In fact I could not do it in a standard way with Oracle installation binaries before 11.2.0.3.
![Supplier2 Schema Oracle 11g Installation Supplier2 Schema Oracle 11g Installation](/uploads/1/2/8/1/128130581/426742549.png)
If somebody experienced similar issues, I give below the way how to install Sample Schemas manually.1. Create a new fresh Oracle database with following prerequisites– with US7ASCII character set– with database components (JVM, XML DB, Multimedia, Spatial)– WITHOUT Sample Schemas component– No new tablespaces should be created after the database creation2.
![](/uploads/1/2/8/1/128130581/980288386.jpg)