In this book, we use the ever-familiar Oracle Demo Schemas in our Streams examples. If you wish to practice with the scripts provided in this book and your database does not have the Demo Schemas, you can use the Load_Demo_Schemas.sql
that can be downloaded from the Packt website.
The demo schemas use the EXAMPLES
tablespace and include the following schemas—HR, OE, PM, IX, BI, and SH. Please be aware and forewarned, that if you use the Load_Demo_Schemas.sql
, the EXAMPLES
tablespace (and datafiles), and the HR, OE, PM, IX, BI, and SH schemas will be dropped and recreated. If needed, back up your database or export your existing demo schemas before running the script.