Appendix A. The Schema for Easy Shopping Inc.
We saw in Chapter 2 how to create our database using the GUI tools, but many readers may prefer to create the database directly from SQL. The SQL to achieve this is shown below, but it assumes that the database has already been created.
The example shown here has been created for a Windows system, a simple edit of the file specs is all that is required for a different platform. Also note that the file sizes here are very small compared to what you would use in a production environment.
Creating the Tablespaces and Data Files
The first step is to connect to the database using a powerful user name.
connect system/manager
The next step is to create the tablespaces where the data will reside and their associated ...
Get Oracle 10g Data Warehousing now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
