Applying It

Independent Exercise 1:

  • Download both INSTALL scripts from www.quepublishing.com.
  • Review the Oracle9i directory structure on your computer.
  • Edit INSTALL_Sales_Tracking_Database.sql and validate/change the file locations on the various CREATE TABLESPACE statements
  • Execute the edited INSTALL_Sales_Tracking_Database.sql to create the book example Tablespaces.
  • Review the LOG file for any errors.

Independent Exercise 2:

  • Review the INSTALL_Sales_Trackng_Objects.sql.
  • Execute the INSTALL_Sales_Tracking_Object.sql to create the book example objects.
  • Review the LOG file for any errors.

Independent Exercise 3:

  • Download the EXPORT_Sales_Tracking.dmp file ...

Get Oracle9i™ Development by Example 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.