DBA Tips Archive for Oracle

  


Creating the Oracle Sample Schema - (Release 9i and 10g)

by Jeff Hunter, Sr. Database Administrator


Contents

  1. Overview
  2. About the Sample Schemas
  3. Schema Dependencies
  4. The EXAMPLE Tablespace
  5. Running the Schema Creation Scripts - (9i)
  6. Running the Schema Creation Scripts - (10g)



Overview

Developer's and DBA's who have worked with Oracle in the past should be familiar with the ever popular SCOTT schema which contained the two tables EMP and DEPT. With all of the advances in Oracle technology (i.e. partitions, dimensions, objects, materialized views, etc.), these tables have become inadequate to show even the most basic features of the Oracle database and other Oracle products. As a result, many other schemas have been created over the years to suit the needs of product documentation, courseware, and software development and application demos.

There are several ways in which to installed the sample schemas:

  1. When you perform a complete installation of Oracle9i, the Sample Schemas are installed automatically with the seed database. If for some reason the seed database is removed from your system, you will need to reinstall the Sample Schemas.

    The new Oracle9i Sample Schemas serve to provide a common platform for examples in Oracle9i and future releases. The new Oracle9i Sample Schemas are a set of interlinked schemas. This set of schemas is aimed at providing a layered approach to complexity:

    • A simple schema (Human Resources, HR) for introducing basic topics. An extension to this schema supports Oracle Internet Directory demos.

    • A second schema (Order Entry, OE) for dealing with matters of intermediate complexity. A multitude of datatypes is available in this schema.

    • The Online Catalog (OC) subschema is a collection of object-relational database objects built inside the OE schema.

    • A schema dedicated to multimedia datatypes (Product Media, PM)

    • A set of schemas gathered under the main schema name QS (Queued Shipping, QS) to demonstrate Oracle Advanced Queuing capabilities.

    • A schema designed to allow for demos with larger amounts of data (Sales History, SH). An extension to this schema provides support for advanced analytic processing.
  2. Using DBCA is by far the most intuitive and simple way to install the Sample Schemas. Step 4 of the database creation process lets you configure the Sample Schemas you wish to use in your database.

  3. Manual method, using SQL scripts.

This article provides the steps necessary to manually setup all of the example schemas and objects available with Oracle9i.



About the Sample Schemas

The new Oracle9i Sample Schemas serve to provide a common platform for examples in Oracle9i and future releases. The new Oracle9i Sample Schemas are a set of interlinked schemas. This set of schemas is aimed at providing a layered approach to complexity:



Schema Dependencies

Before going into the schema creation details, let's first talk about the dependencies within the schemas.

NOTE: The following list will not only document the dependencies between the different schemas, but will also show the sequence used to create the schemas.

Also remember that the Sample Schemas are ordered, both in complexity and dependencies, in alphabetical order.

  1. HR : Has no dependencies. This should be the first schema to create.

  2. OE : The HR schema must already be present, and you must know the password for the HR so that you can grant HR object privileges to OE. Some HR tables are visible to the OE user through the use of private synonyms. In addition, some OE tables have foreign key relationships to HR tables.

    The OE schema also requires the Oracle Spatial option be installed. This can be done during installation or afterward using the Database Configuration Assistant.

  3. PM : Foreign key relationships require that the OE schema alread exist when the PM schema is created. You will need to know the password for the OE user in order to grant to the PM user, the right to establish and use these foreign keys.

    The PM schema also requires the the database to be enabled for the Java Virtual Machine (Oracle JVM) and interMedia. This can be accomplished during installation or afterward using the Database Configuration Assistant.

  4. QS : The shipping schema, QS, is based on order entry data in OE. Again, foreign key relationships require that the OE schema already be present when the QS schema is created. You will need to know the password for the OE user in order to grant to QS the right to establish and use these foreign keys.

  5. SH : The SH schema logically depends on the OE schema, although there is nothing that prevents your from creating this schema on its own, without the four other schemas.

    The SH schema also requires the partitioning option to be installed.



The EXAMPLE Tablespace

Before you attempt to run the schema creation scripts, you will need to first create the tablespace that will hold all of the schema's segments. Oracle uses a tablespace named EXAMPLE by default. The following SQL will create the EXAMPLE tablespace:
CREATE TABLESPACE "EXAMPLE"
LOGGING DATAFILE '/u10/app/oradata/ORA920/example01.dbf' SIZE 50M REUSE
AUTOEXTEND ON   NEXT 50M   MAXSIZE 1000M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;



Running the Schema Creation Scripts - (9i)

Finally, it is time to run the scripts necessary to create all of the Sample Schemas. If you simply want to create all Sample Schemas, Oracle provides a master script that runs all of the main scripts in their proper sequence. To call this script, you will need to provide the SYS and SYSTEM passwords as well as providing the passwords for the HR, OE, PM, all of the QS schema's, and SH users as follows:
SQL> @?/demo/schema/mksample systempwd syspwd hrpwd oepwd pmpwd pspwd shpwd
Here is an example call:
% sqlplus /nolog

SQL> @?/demo/schema/mksample manager change_on_install hr oe pm qs sh

NOTE: The first 4 Sample Schemas take little time to be created. The SH schema takes about 30 to 45 minutes to complete.

Query Sample Schema Objects Output
OWNER      OBJECT_TYPE        OBJECT_NAME                                             SUBOBJECT_NAME       STATUS
---------- ------------------ ------------------------------------------------------- -------------------- -------
HR         INDEX              COUNTRY_C_ID_PK                                                              VALID
HR         INDEX              DEPT_ID_PK                                                                   VALID
HR         INDEX              DEPT_LOCATION_IX                                                             VALID
HR         INDEX              EMP_DEPARTMENT_IX                                                            VALID
HR         INDEX              EMP_EMAIL_UK                                                                 VALID
HR         INDEX              EMP_EMP_ID_PK                                                                VALID
HR         INDEX              EMP_JOB_IX                                                                   VALID
HR         INDEX              EMP_MANAGER_IX                                                               VALID
HR         INDEX              EMP_NAME_IX                                                                  VALID
HR         INDEX              JHIST_DEPARTMENT_IX                                                          VALID
HR         INDEX              JHIST_EMPLOYEE_IX                                                            VALID
HR         INDEX              JHIST_EMP_ID_ST_DATE_PK                                                      VALID
HR         INDEX              JHIST_JOB_IX                                                                 VALID
HR         INDEX              JOB_ID_PK                                                                    VALID
HR         INDEX              LOC_CITY_IX                                                                  VALID
HR         INDEX              LOC_COUNTRY_IX                                                               VALID
HR         INDEX              LOC_ID_PK                                                                    VALID
HR         INDEX              LOC_STATE_PROVINCE_IX                                                        VALID
HR         INDEX              REG_ID_PK                                                                    VALID
HR         PROCEDURE          ADD_JOB_HISTORY                                                              VALID
HR         PROCEDURE          SECURE_DML                                                                   VALID
HR         SEQUENCE           DEPARTMENTS_SEQ                                                              VALID
HR         SEQUENCE           EMPLOYEES_SEQ                                                                VALID
HR         SEQUENCE           LOCATIONS_SEQ                                                                VALID
HR         TABLE              COUNTRIES                                                                    VALID
HR         TABLE              DEPARTMENTS                                                                  VALID
HR         TABLE              EMPLOYEES                                                                    VALID
HR         TABLE              JOBS                                                                         VALID
HR         TABLE              JOB_HISTORY                                                                  VALID
HR         TABLE              LOCATIONS                                                                    VALID
HR         TABLE              REGIONS                                                                      VALID
HR         TRIGGER            SECURE_EMPLOYEES                                                             VALID
HR         TRIGGER            UPDATE_JOB_HISTORY                                                           VALID
HR         VIEW               EMP_DETAILS_VIEW                                                             VALID
OE         INDEX              CUSTOMERS_PK                                                                 VALID
OE         INDEX              CUST_ACCOUNT_MANAGER_IX                                                      VALID
OE         INDEX              CUST_EMAIL_IX                                                                VALID
OE         INDEX              CUST_LNAME_IX                                                                VALID
OE         INDEX              CUST_UPPER_NAME_IX                                                           VALID
OE         INDEX              INVENTORY_PK                                                                 VALID
OE         INDEX              INV_PRODUCT_IX                                                               VALID
OE         INDEX              INV_WAREHOUSE_IX                                                             VALID
OE         INDEX              ITEM_ORDER_IX                                                                VALID
OE         INDEX              ITEM_PRODUCT_IX                                                              VALID
OE         INDEX              ORDER_ITEMS_PK                                                               VALID
OE         INDEX              ORDER_ITEMS_UK                                                               VALID
OE         INDEX              ORDER_PK                                                                     VALID
OE         INDEX              ORD_CUSTOMER_IX                                                              VALID
OE         INDEX              ORD_ORDER_DATE_IX                                                            VALID
OE         INDEX              ORD_SALES_REP_IX                                                             VALID
OE         INDEX              PRD_DESC_PK                                                                  VALID
OE         INDEX              PRODUCT_INFORMATION_PK                                                       VALID
OE         INDEX              PROD_NAME_IX                                                                 VALID
OE         INDEX              PROD_SUPPLIER_IX                                                             VALID
OE         INDEX              WAREHOUSES_PK                                                                VALID
OE         INDEX              WHS_LOCATION_IX                                                              VALID
OE         SEQUENCE           ORDERS_SEQ                                                                   VALID
OE         SYNONYM            COUNTRIES                                                                    VALID
OE         SYNONYM            DEPARTMENTS                                                                  VALID
OE         SYNONYM            EMPLOYEES                                                                    VALID
OE         SYNONYM            JOBS                                                                         VALID
OE         SYNONYM            JOB_HISTORY                                                                  VALID
OE         SYNONYM            LOCATIONS                                                                    VALID
OE         TABLE              CATEGORIES_TAB                                                               VALID
OE         TABLE              CUSTOMERS                                                                    VALID
OE         TABLE              INVENTORIES                                                                  VALID
OE         TABLE              ORDERS                                                                       VALID
OE         TABLE              ORDER_ITEMS                                                                  VALID
OE         TABLE              PRODUCT_DESCRIPTIONS                                                         VALID
OE         TABLE              PRODUCT_INFORMATION                                                          VALID
OE         TABLE              PRODUCT_REF_LIST_NESTEDTAB                                                   VALID
OE         TABLE              SUBCATEGORY_REF_LIST_NESTEDTAB                                               VALID
OE         TABLE              WAREHOUSES                                                                   VALID
OE         TRIGGER            INSERT_ORD_LINE                                                              VALID
OE         TRIGGER            ORDERS_ITEMS_TRG                                                             VALID
OE         TRIGGER            ORDERS_TRG                                                                   VALID
OE         TYPE               CATALOG_TYP                                             $VSN_1               VALID
OE         TYPE               CATALOG_TYP                                                                  VALID
OE         TYPE               CATEGORY_TYP                                            $VSN_1               VALID
OE         TYPE               CATEGORY_TYP                                                                 VALID
OE         TYPE               COMPOSITE_CATEGORY_TYP                                  $VSN_1               VALID
OE         TYPE               COMPOSITE_CATEGORY_TYP                                                       VALID
OE         TYPE               CORPORATE_CUSTOMER_TYP                                                       VALID
OE         TYPE               CUSTOMER_TYP                                                                 VALID
OE         TYPE               CUST_ADDRESS_TYP                                                             VALID
OE         TYPE               INVENTORY_LIST_TYP                                                           VALID
OE         TYPE               INVENTORY_TYP                                                                VALID
OE         TYPE               LEAF_CATEGORY_TYP                                       $VSN_1               VALID
OE         TYPE               LEAF_CATEGORY_TYP                                                            VALID
OE         TYPE               ORDER_ITEM_LIST_TYP                                                          VALID
OE         TYPE               ORDER_ITEM_TYP                                                               VALID
OE         TYPE               ORDER_LIST_TYP                                                               VALID
OE         TYPE               ORDER_TYP                                                                    VALID
OE         TYPE               PHONE_LIST_TYP                                                               VALID
OE         TYPE               PRODUCT_INFORMATION_TYP                                                      VALID
OE         TYPE               PRODUCT_REF_LIST_TYP                                                         VALID
OE         TYPE               SUBCATEGORY_REF_LIST_TYP                                                     VALID
OE         TYPE               WAREHOUSE_TYP                                                                VALID
OE         TYPE BODY          CATALOG_TYP                                                                  VALID
OE         TYPE BODY          COMPOSITE_CATEGORY_TYP                                                       VALID
OE         TYPE BODY          LEAF_CATEGORY_TYP                                                            VALID
OE         VIEW               BOMBAY_INVENTORY                                                             VALID
OE         VIEW               OC_CORPORATE_CUSTOMERS                                                       VALID
OE         VIEW               OC_CUSTOMERS                                                                 VALID
OE         VIEW               OC_INVENTORIES                                                               VALID
OE         VIEW               OC_ORDERS                                                                    VALID
OE         VIEW               OC_PRODUCT_INFORMATION                                                       VALID
OE         VIEW               PRODUCTS                                                                     VALID
OE         VIEW               PRODUCT_PRICES                                                               VALID
OE         VIEW               SYDNEY_INVENTORY                                                             VALID
OE         VIEW               TORONTO_INVENTORY                                                            VALID
PM         INDEX              ONLINEMEDIA_PK                                                               VALID
PM         INDEX              PRINTMEDIA_PK                                                                VALID
PM         TABLE              ONLINE_MEDIA                                                                 VALID
PM         TABLE              PRINT_MEDIA                                                                  VALID
PM         TABLE              TEXTDOCS_NESTEDTAB                                                           VALID
PM         TYPE               ADHEADER_TYP                                                                 VALID
PM         TYPE               TEXTDOC_TAB                                                                  VALID
PM         TYPE               TEXTDOC_TYP                                                                  VALID
QS         EVALUATION CONTEXT AQ$_AQ$_MEM_MC_V                                                             VALID
QS         EVALUATION CONTEXT AQ$_QS_ORDERS_PR_MQTAB_V                                                     VALID
QS         INDEX              AQ$_QS_ORDERS_SQTAB_I                                                        VALID
QS         INDEX              AQ$_QS_ORDERS_SQTAB_T                                                        VALID
QS         QUEUE              AQ$_AQ$_MEM_MC_E                                                             VALID
QS         QUEUE              AQ$_QS_ORDERS_PR_MQTAB_E                                                     VALID
QS         QUEUE              AQ$_QS_ORDERS_SQTAB_E                                                        VALID
QS         QUEUE              LOGON_LOGOFF                                                                 VALID
QS         QUEUE              QS_BOOKEDORDERS_QUE                                                          VALID
QS         QUEUE              QS_NEWORDERS_QUE                                                             VALID
QS         RULE SET           QS_BOOKEDORDERS_QUE_R                                                        VALID
QS         SEQUENCE           AQ$_AQ$_MEM_MC_N                                                             VALID
QS         SEQUENCE           AQ$_QS_ORDERS_PR_MQTAB_N                                                     VALID
QS         TABLE              AQ$_AQ$_MEM_MC_H                                                             VALID
QS         TABLE              AQ$_AQ$_MEM_MC_I                                                             VALID
QS         TABLE              AQ$_AQ$_MEM_MC_NR                                                            VALID
QS         TABLE              AQ$_AQ$_MEM_MC_S                                                             VALID
QS         TABLE              AQ$_AQ$_MEM_MC_T                                                             VALID
QS         TABLE              AQ$_MEM_MC                                                                   VALID
QS         TABLE              AQ$_QS_ORDERS_PR_MQTAB_H                                                     VALID
QS         TABLE              AQ$_QS_ORDERS_PR_MQTAB_I                                                     VALID
QS         TABLE              AQ$_QS_ORDERS_PR_MQTAB_NR                                                    VALID
QS         TABLE              AQ$_QS_ORDERS_PR_MQTAB_S                                                     VALID
QS         TABLE              AQ$_QS_ORDERS_PR_MQTAB_T                                                     VALID
QS         TABLE              QS_ORDERS_PR_MQTAB                                                           VALID
QS         TABLE              QS_ORDERS_SQTAB                                                              VALID
QS         VIEW               AQ$AQ$_MEM_MC                                                                VALID
QS         VIEW               AQ$AQ$_MEM_MC_S                                                              VALID
QS         VIEW               AQ$QS_ORDERS_PR_MQTAB                                                        VALID
QS         VIEW               AQ$QS_ORDERS_PR_MQTAB_R                                                      VALID
QS         VIEW               AQ$QS_ORDERS_PR_MQTAB_S                                                      VALID
QS         VIEW               AQ$QS_ORDERS_SQTAB                                                           VALID
QS_ADM     PACKAGE            QS_APPLICATIONS                                                              VALID
QS_ADM     PACKAGE BODY       QS_APPLICATIONS                                                              VALID
QS_ADM     TYPE               CUSTOMER_TYP                                                                 VALID
QS_ADM     TYPE               ORDERITEMLIST_VARTYP                                                         VALID
QS_ADM     TYPE               ORDERITEM_TYP                                                                VALID
QS_ADM     TYPE               ORDER_TYP                                                                    VALID
QS_ADM     TYPE               SIMPLEORDER_TYP                                                              VALID
QS_CBADM   EVALUATION CONTEXT AQ$_QS_CBADM_ORDERS_MQTAB_V                                                  VALID
QS_CBADM   INDEX              AQ$_QS_CBADM_ORDERS_SQTAB_I                                                  VALID
QS_CBADM   INDEX              AQ$_QS_CBADM_ORDERS_SQTAB_T                                                  VALID
QS_CBADM   QUEUE              AQ$_QS_CBADM_ORDERS_MQTAB_E                                                  VALID
QS_CBADM   QUEUE              AQ$_QS_CBADM_ORDERS_SQTAB_E                                                  VALID
QS_CBADM   QUEUE              QS_CBADM_BILLEDORDERS_Q                                                      VALID
QS_CBADM   QUEUE              QS_CBADM_SHIPPEDORDERS_Q                                                     VALID
QS_CBADM   RULE SET           QS_CBADM_BILLEDORDERS_Q_R                                                    VALID
QS_CBADM   SEQUENCE           AQ$_QS_CBADM_ORDERS_MQTAB_N                                                  VALID
QS_CBADM   TABLE              AQ$_QS_CBADM_ORDERS_MQTAB_H                                                  VALID
QS_CBADM   TABLE              AQ$_QS_CBADM_ORDERS_MQTAB_I                                                  VALID
QS_CBADM   TABLE              AQ$_QS_CBADM_ORDERS_MQTAB_NR                                                 VALID
QS_CBADM   TABLE              AQ$_QS_CBADM_ORDERS_MQTAB_S                                                  VALID
QS_CBADM   TABLE              AQ$_QS_CBADM_ORDERS_MQTAB_T                                                  VALID
QS_CBADM   TABLE              QS_CBADM_ORDERS_MQTAB                                                        VALID
QS_CBADM   TABLE              QS_CBADM_ORDERS_SQTAB                                                        VALID
QS_CBADM   VIEW               AQ$QS_CBADM_ORDERS_MQTAB                                                     VALID
QS_CBADM   VIEW               AQ$QS_CBADM_ORDERS_MQTAB_R                                                   VALID
QS_CBADM   VIEW               AQ$QS_CBADM_ORDERS_MQTAB_S                                                   VALID
QS_CBADM   VIEW               AQ$QS_CBADM_ORDERS_SQTAB                                                     VALID
QS_CS      EVALUATION CONTEXT AQ$_QS_CS_ORDER_STATUS_QT_V                                                  VALID
QS_CS      QUEUE              AQ$_QS_CS_ORDER_STATUS_QT_E                                                  VALID
QS_CS      QUEUE              QS_CS_BACKORDERS_QUE                                                         VALID
QS_CS      QUEUE              QS_CS_BILLEDORDERS_QUE                                                       VALID
QS_CS      QUEUE              QS_CS_BOOKEDORDERS_QUE                                                       VALID
QS_CS      QUEUE              QS_CS_SHIPPEDORDERS_QUE                                                      VALID
QS_CS      RULE SET           QS_CS_BACKORDERS_QUE_R                                                       VALID
QS_CS      RULE SET           QS_CS_BILLEDORDERS_QUE_R                                                     VALID
QS_CS      RULE SET           QS_CS_BOOKEDORDERS_QUE_R                                                     VALID
QS_CS      RULE SET           QS_CS_SHIPPEDORDERS_QUE_R                                                    VALID
QS_CS      SEQUENCE           AQ$_QS_CS_ORDER_STATUS_QT_N                                                  VALID
QS_CS      TABLE              AQ$_QS_CS_ORDER_STATUS_QT_H                                                  VALID
QS_CS      TABLE              AQ$_QS_CS_ORDER_STATUS_QT_I                                                  VALID
QS_CS      TABLE              AQ$_QS_CS_ORDER_STATUS_QT_NR                                                 VALID
QS_CS      TABLE              AQ$_QS_CS_ORDER_STATUS_QT_S                                                  VALID
QS_CS      TABLE              AQ$_QS_CS_ORDER_STATUS_QT_T                                                  VALID
QS_CS      TABLE              ORDER_STATUS_TABLE                                                           VALID
QS_CS      TABLE              QS_CS_ORDER_STATUS_QT                                                        VALID
QS_CS      VIEW               AQ$QS_CS_ORDER_STATUS_QT                                                     VALID
QS_CS      VIEW               AQ$QS_CS_ORDER_STATUS_QT_R                                                   VALID
QS_CS      VIEW               AQ$QS_CS_ORDER_STATUS_QT_S                                                   VALID
QS_ES      EVALUATION CONTEXT AQ$_QS_ES_ORDERS_MQTAB_V                                                     VALID
QS_ES      EVALUATION CONTEXT AQ$_QS_ES_ORDERS_PR_MQTAB_V                                                  VALID
QS_ES      QUEUE              AQ$_QS_ES_ORDERS_MQTAB_E                                                     VALID
QS_ES      QUEUE              AQ$_QS_ES_ORDERS_PR_MQTAB_E                                                  VALID
QS_ES      QUEUE              QS_ES_BACKORDERS_QUE                                                         VALID
QS_ES      QUEUE              QS_ES_BOOKEDORDERS_QUE                                                       VALID
QS_ES      QUEUE              QS_ES_SHIPPEDORDERS_QUE                                                      VALID
QS_ES      RULE SET           QS_ES_BACKORDERS_QUE_R                                                       VALID
QS_ES      RULE SET           QS_ES_BOOKEDORDERS_QUE_R                                                     VALID
QS_ES      RULE SET           QS_ES_SHIPPEDORDERS_QUE_R                                                    VALID
QS_ES      SEQUENCE           AQ$_QS_ES_ORDERS_MQTAB_N                                                     VALID
QS_ES      SEQUENCE           AQ$_QS_ES_ORDERS_PR_MQTAB_N                                                  VALID
QS_ES      TABLE              AQ$_QS_ES_ORDERS_MQTAB_H                                                     VALID
QS_ES      TABLE              AQ$_QS_ES_ORDERS_MQTAB_I                                                     VALID
QS_ES      TABLE              AQ$_QS_ES_ORDERS_MQTAB_NR                                                    VALID
QS_ES      TABLE              AQ$_QS_ES_ORDERS_MQTAB_S                                                     VALID
QS_ES      TABLE              AQ$_QS_ES_ORDERS_MQTAB_T                                                     VALID
QS_ES      TABLE              AQ$_QS_ES_ORDERS_PR_MQTAB_H                                                  VALID
QS_ES      TABLE              AQ$_QS_ES_ORDERS_PR_MQTAB_I                                                  VALID
QS_ES      TABLE              AQ$_QS_ES_ORDERS_PR_MQTAB_NR                                                 VALID
QS_ES      TABLE              AQ$_QS_ES_ORDERS_PR_MQTAB_S                                                  VALID
QS_ES      TABLE              AQ$_QS_ES_ORDERS_PR_MQTAB_T                                                  VALID
QS_ES      TABLE              QS_ES_ORDERS_MQTAB                                                           VALID
QS_ES      TABLE              QS_ES_ORDERS_PR_MQTAB                                                        VALID
QS_ES      VIEW               AQ$QS_ES_ORDERS_MQTAB                                                        VALID
QS_ES      VIEW               AQ$QS_ES_ORDERS_MQTAB_R                                                      VALID
QS_ES      VIEW               AQ$QS_ES_ORDERS_MQTAB_S                                                      VALID
QS_ES      VIEW               AQ$QS_ES_ORDERS_PR_MQTAB                                                     VALID
QS_ES      VIEW               AQ$QS_ES_ORDERS_PR_MQTAB_R                                                   VALID
QS_ES      VIEW               AQ$QS_ES_ORDERS_PR_MQTAB_S                                                   VALID
QS_OS      EVALUATION CONTEXT AQ$_QS_OS_ORDERS_MQTAB_V                                                     VALID
QS_OS      EVALUATION CONTEXT AQ$_QS_OS_ORDERS_PR_MQTAB_V                                                  VALID
QS_OS      QUEUE              AQ$_QS_OS_ORDERS_MQTAB_E                                                     VALID
QS_OS      QUEUE              AQ$_QS_OS_ORDERS_PR_MQTAB_E                                                  VALID
QS_OS      QUEUE              QS_OS_BACKORDERS_QUE                                                         VALID
QS_OS      QUEUE              QS_OS_BOOKEDORDERS_QUE                                                       VALID
QS_OS      QUEUE              QS_OS_SHIPPEDORDERS_QUE                                                      VALID
QS_OS      RULE SET           QS_OS_BACKORDERS_QUE_R                                                       VALID
QS_OS      RULE SET           QS_OS_BOOKEDORDERS_QUE_R                                                     VALID
QS_OS      RULE SET           QS_OS_SHIPPEDORDERS_QUE_R                                                    VALID
QS_OS      SEQUENCE           AQ$_QS_OS_ORDERS_MQTAB_N                                                     VALID
QS_OS      SEQUENCE           AQ$_QS_OS_ORDERS_PR_MQTAB_N                                                  VALID
QS_OS      TABLE              AQ$_QS_OS_ORDERS_MQTAB_H                                                     VALID
QS_OS      TABLE              AQ$_QS_OS_ORDERS_MQTAB_I                                                     VALID
QS_OS      TABLE              AQ$_QS_OS_ORDERS_MQTAB_NR                                                    VALID
QS_OS      TABLE              AQ$_QS_OS_ORDERS_MQTAB_S                                                     VALID
QS_OS      TABLE              AQ$_QS_OS_ORDERS_MQTAB_T                                                     VALID
QS_OS      TABLE              AQ$_QS_OS_ORDERS_PR_MQTAB_H                                                  VALID
QS_OS      TABLE              AQ$_QS_OS_ORDERS_PR_MQTAB_I                                                  VALID
QS_OS      TABLE              AQ$_QS_OS_ORDERS_PR_MQTAB_NR                                                 VALID
QS_OS      TABLE              AQ$_QS_OS_ORDERS_PR_MQTAB_S                                                  VALID
QS_OS      TABLE              AQ$_QS_OS_ORDERS_PR_MQTAB_T                                                  VALID
QS_OS      TABLE              QS_OS_ORDERS_MQTAB                                                           VALID
QS_OS      TABLE              QS_OS_ORDERS_PR_MQTAB                                                        VALID
QS_OS      VIEW               AQ$QS_OS_ORDERS_MQTAB                                                        VALID
QS_OS      VIEW               AQ$QS_OS_ORDERS_MQTAB_R                                                      VALID
QS_OS      VIEW               AQ$QS_OS_ORDERS_MQTAB_S                                                      VALID
QS_OS      VIEW               AQ$QS_OS_ORDERS_PR_MQTAB                                                     VALID
QS_OS      VIEW               AQ$QS_OS_ORDERS_PR_MQTAB_R                                                   VALID
QS_OS      VIEW               AQ$QS_OS_ORDERS_PR_MQTAB_S                                                   VALID
QS_WS      EVALUATION CONTEXT AQ$_QS_WS_ORDERS_MQTAB_V                                                     VALID
QS_WS      EVALUATION CONTEXT AQ$_QS_WS_ORDERS_PR_MQTAB_V                                                  VALID
QS_WS      QUEUE              AQ$_QS_WS_ORDERS_MQTAB_E                                                     VALID
QS_WS      QUEUE              AQ$_QS_WS_ORDERS_PR_MQTAB_E                                                  VALID
QS_WS      QUEUE              QS_WS_BACKORDERS_QUE                                                         VALID
QS_WS      QUEUE              QS_WS_BOOKEDORDERS_QUE                                                       VALID
QS_WS      QUEUE              QS_WS_SHIPPEDORDERS_QUE                                                      VALID
QS_WS      RULE SET           QS_WS_BACKORDERS_QUE_R                                                       VALID
QS_WS      RULE SET           QS_WS_BOOKEDORDERS_QUE_R                                                     VALID
QS_WS      RULE SET           QS_WS_SHIPPEDORDERS_QUE_R                                                    VALID
QS_WS      SEQUENCE           AQ$_QS_WS_ORDERS_MQTAB_N                                                     VALID
QS_WS      SEQUENCE           AQ$_QS_WS_ORDERS_PR_MQTAB_N                                                  VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_MQTAB_H                                                     VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_MQTAB_I                                                     VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_MQTAB_NR                                                    VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_MQTAB_S                                                     VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_MQTAB_T                                                     VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_PR_MQTAB_H                                                  VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_PR_MQTAB_I                                                  VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_PR_MQTAB_NR                                                 VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_PR_MQTAB_S                                                  VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_PR_MQTAB_T                                                  VALID
QS_WS      TABLE              QS_WS_ORDERS_MQTAB                                                           VALID
QS_WS      TABLE              QS_WS_ORDERS_PR_MQTAB                                                        VALID
QS_WS      VIEW               AQ$QS_WS_ORDERS_MQTAB                                                        VALID
QS_WS      VIEW               AQ$QS_WS_ORDERS_MQTAB_R                                                      VALID
QS_WS      VIEW               AQ$QS_WS_ORDERS_MQTAB_S                                                      VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_MQTAB_T                                                     VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_PR_MQTAB_H                                                  VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_PR_MQTAB_I                                                  VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_PR_MQTAB_NR                                                 VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_PR_MQTAB_S                                                  VALID
QS_WS      TABLE              AQ$_QS_WS_ORDERS_PR_MQTAB_T                                                  VALID
QS_WS      TABLE              QS_WS_ORDERS_MQTAB                                                           VALID
QS_WS      TABLE              QS_WS_ORDERS_PR_MQTAB                                                        VALID
QS_WS      VIEW               AQ$QS_WS_ORDERS_MQTAB                                                        VALID
QS_WS      VIEW               AQ$QS_WS_ORDERS_MQTAB_R                                                      VALID
QS_WS      VIEW               AQ$QS_WS_ORDERS_MQTAB_S                                                      VALID
QS_WS      VIEW               AQ$QS_WS_ORDERS_PR_MQTAB                                                     VALID
QS_WS      VIEW               AQ$QS_WS_ORDERS_PR_MQTAB_R                                                   VALID
QS_WS      VIEW               AQ$QS_WS_ORDERS_PR_MQTAB_S                                                   VALID
SH         DIMENSION          CHANNELS_DIM                                                                 VALID
SH         DIMENSION          CUSTOMERS_DIM                                                                VALID
SH         DIMENSION          PRODUCTS_DIM                                                                 VALID
SH         DIMENSION          PROMOTIONS_DIM                                                               VALID
SH         DIMENSION          TIMES_DIM                                                                    VALID
SH         INDEX              CHAN_PK                                                                      VALID
SH         INDEX              COSTS_PROD_BIX                                                               VALID
SH         INDEX              COSTS_TIME_BIX                                                               VALID
SH         INDEX              COUNTRY_PK                                                                   VALID
SH         INDEX              CUSTOMERS_GENDER_BIX                                                         VALID
SH         INDEX              CUSTOMERS_MARITAL_BIX                                                        VALID
SH         INDEX              CUSTOMERS_PK                                                                 VALID
SH         INDEX              CUSTOMERS_YOB_BIX                                                            VALID
SH         INDEX              FW_PSC_S_MV_CHAN_BIX                                                         VALID
SH         INDEX              FW_PSC_S_MV_PROMO_BIX                                                        VALID
SH         INDEX              FW_PSC_S_MV_SUBCAT_BIX                                                       VALID
SH         INDEX              FW_PSC_S_MV_WD_BIX                                                           VALID
SH         INDEX              I_SNAP$_CAL_MONTH_SALES_MV                                                   VALID
SH         INDEX              I_SNAP$_FWEEK_PSCAT_SALES_                                                   VALID
SH         INDEX              PRODUCTS_PK                                                                  VALID
SH         INDEX              PRODUCTS_PROD_CAT_IX                                                         VALID
SH         INDEX              PRODUCTS_PROD_STATUS_BIX                                                     VALID
SH         INDEX              PRODUCTS_PROD_SUBCAT_IX                                                      VALID
SH         INDEX              PROMO_PK                                                                     VALID
SH         INDEX              SALES_CHANNEL_BIX                                                            VALID
SH         INDEX              SALES_CUST_BIX                                                               VALID
SH         INDEX              SALES_PROD_BIX                                                               VALID
SH         INDEX              SALES_PROMO_BIX                                                              VALID
SH         INDEX              SALES_TIME_BIX                                                               VALID
SH         INDEX              TIME_PK                                                                      VALID
SH         INDEX PARTITION    COSTS_PROD_BIX                                          COSTS_Q1_1998        VALID
SH         INDEX PARTITION    COSTS_PROD_BIX                                          COSTS_Q1_1999        VALID
SH         INDEX PARTITION    COSTS_PROD_BIX                                          COSTS_Q1_2000        VALID
SH         INDEX PARTITION    COSTS_PROD_BIX                                          COSTS_Q2_1998        VALID
SH         INDEX PARTITION    COSTS_PROD_BIX                                          COSTS_Q2_1999        VALID
SH         INDEX PARTITION    COSTS_PROD_BIX                                          COSTS_Q2_2000        VALID
SH         INDEX PARTITION    COSTS_PROD_BIX                                          COSTS_Q3_1998        VALID
SH         INDEX PARTITION    COSTS_PROD_BIX                                          COSTS_Q3_1999        VALID
SH         INDEX PARTITION    COSTS_PROD_BIX                                          COSTS_Q3_2000        VALID
SH         INDEX PARTITION    COSTS_PROD_BIX                                          COSTS_Q4_1998        VALID
SH         INDEX PARTITION    COSTS_PROD_BIX                                          COSTS_Q4_1999        VALID
SH         INDEX PARTITION    COSTS_PROD_BIX                                          COSTS_Q4_2000        VALID
SH         INDEX PARTITION    COSTS_TIME_BIX                                          COSTS_Q1_1998        VALID
SH         INDEX PARTITION    COSTS_TIME_BIX                                          COSTS_Q1_1999        VALID
SH         INDEX PARTITION    COSTS_TIME_BIX                                          COSTS_Q1_2000        VALID
SH         INDEX PARTITION    COSTS_TIME_BIX                                          COSTS_Q2_1998        VALID
SH         INDEX PARTITION    COSTS_TIME_BIX                                          COSTS_Q2_1999        VALID
SH         INDEX PARTITION    COSTS_TIME_BIX                                          COSTS_Q2_2000        VALID
SH         INDEX PARTITION    COSTS_TIME_BIX                                          COSTS_Q3_1998        VALID
SH         INDEX PARTITION    COSTS_TIME_BIX                                          COSTS_Q3_1999        VALID
SH         INDEX PARTITION    COSTS_TIME_BIX                                          COSTS_Q3_2000        VALID
SH         INDEX PARTITION    COSTS_TIME_BIX                                          COSTS_Q4_1998        VALID
SH         INDEX PARTITION    COSTS_TIME_BIX                                          COSTS_Q4_1999        VALID
SH         INDEX PARTITION    COSTS_TIME_BIX                                          COSTS_Q4_2000        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_1995           VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_1996           VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_H1_1997        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_H2_1997        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_Q1_1998        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_Q1_1999        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_Q1_2000        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_Q2_1998        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_Q2_1999        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_Q2_2000        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_Q3_1998        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_Q3_1999        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_Q3_2000        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_Q4_1998        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_Q4_1999        VALID
SH         INDEX PARTITION    SALES_CHANNEL_BIX                                       SALES_Q4_2000        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_1995           VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_1996           VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_H1_1997        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_H2_1997        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_Q1_1998        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_Q1_1999        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_Q1_2000        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_Q2_1998        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_Q2_1999        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_Q2_2000        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_Q3_1998        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_Q3_1999        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_Q3_2000        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_Q4_1998        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_Q4_1999        VALID
SH         INDEX PARTITION    SALES_CUST_BIX                                          SALES_Q4_2000        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_1995           VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_1996           VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_H1_1997        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_H2_1997        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_Q1_1998        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_Q1_1999        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_Q1_2000        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_Q2_1998        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_Q2_1999        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_Q2_2000        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_Q3_1998        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_Q3_1999        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_Q3_2000        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_Q4_1998        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_Q4_1999        VALID
SH         INDEX PARTITION    SALES_PROD_BIX                                          SALES_Q4_2000        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_1995           VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_1996           VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_H1_1997        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_H2_1997        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_Q1_1998        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_Q1_1999        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_Q1_2000        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_Q2_1998        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_Q2_1999        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_Q2_2000        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_Q3_1998        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_Q3_1999        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_Q3_2000        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_Q4_1998        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_Q4_1999        VALID
SH         INDEX PARTITION    SALES_PROMO_BIX                                         SALES_Q4_2000        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_1995           VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_1996           VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_H1_1997        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_H2_1997        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_Q1_1998        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_Q1_1999        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_Q1_2000        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_Q2_1998        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_Q2_1999        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_Q2_2000        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_Q3_1998        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_Q3_1999        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_Q3_2000        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_Q4_1998        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_Q4_1999        VALID
SH         INDEX PARTITION    SALES_TIME_BIX                                          SALES_Q4_2000        VALID
SH         MATERIALIZED VIEW  CAL_MONTH_SALES_MV                                                           VALID
SH         MATERIALIZED VIEW  FWEEK_PSCAT_SALES_MV                                                         VALID
SH         TABLE              CAL_MONTH_SALES_MV                                                           VALID
SH         TABLE              CHANNELS                                                                     VALID
SH         TABLE              COSTS                                                                        VALID
SH         TABLE              COUNTRIES                                                                    VALID
SH         TABLE              CUSTOMERS                                                                    VALID
SH         TABLE              FWEEK_PSCAT_SALES_MV                                                         VALID
SH         TABLE              MVIEW$_EXCEPTIONS                                                            VALID
SH         TABLE              MV_CAPABILITIES_TABLE                                                        VALID
SH         TABLE              PLAN_TABLE                                                                   VALID
SH         TABLE              PRODUCTS                                                                     VALID
SH         TABLE              PROMOTIONS                                                                   VALID
SH         TABLE              REWRITE_TABLE                                                                VALID
SH         TABLE              SALES                                                                        VALID
SH         TABLE              SALES_TRANSACTIONS_EXT                                                       VALID
SH         TABLE              TIMES                                                                        VALID
SH         TABLE PARTITION    COSTS                                                   COSTS_Q1_1998        VALID
SH         TABLE PARTITION    COSTS                                                   COSTS_Q1_1999        VALID
SH         TABLE PARTITION    COSTS                                                   COSTS_Q1_2000        VALID
SH         TABLE PARTITION    COSTS                                                   COSTS_Q2_1998        VALID
SH         TABLE PARTITION    COSTS                                                   COSTS_Q2_1999        VALID
SH         TABLE PARTITION    COSTS                                                   COSTS_Q2_2000        VALID
SH         TABLE PARTITION    COSTS                                                   COSTS_Q3_1998        VALID
SH         TABLE PARTITION    COSTS                                                   COSTS_Q3_1999        VALID
SH         TABLE PARTITION    COSTS                                                   COSTS_Q3_2000        VALID
SH         TABLE PARTITION    COSTS                                                   COSTS_Q4_1998        VALID
SH         TABLE PARTITION    COSTS                                                   COSTS_Q4_1999        VALID
SH         TABLE PARTITION    COSTS                                                   COSTS_Q4_2000        VALID
SH         TABLE PARTITION    SALES                                                   SALES_1995           VALID
SH         TABLE PARTITION    SALES                                                   SALES_1996           VALID
SH         TABLE PARTITION    SALES                                                   SALES_H1_1997        VALID
SH         TABLE PARTITION    SALES                                                   SALES_H2_1997        VALID
SH         TABLE PARTITION    SALES                                                   SALES_Q1_1998        VALID
SH         TABLE PARTITION    SALES                                                   SALES_Q1_1999        VALID
SH         TABLE PARTITION    SALES                                                   SALES_Q1_2000        VALID
SH         TABLE PARTITION    SALES                                                   SALES_Q2_1998        VALID
SH         TABLE PARTITION    SALES                                                   SALES_Q2_1999        VALID
SH         TABLE PARTITION    SALES                                                   SALES_Q2_2000        VALID
SH         TABLE PARTITION    SALES                                                   SALES_Q3_1998        VALID
SH         TABLE PARTITION    SALES                                                   SALES_Q3_1999        VALID
SH         TABLE PARTITION    SALES                                                   SALES_Q3_2000        VALID
SH         TABLE PARTITION    SALES                                                   SALES_Q4_1998        VALID
SH         TABLE PARTITION    SALES                                                   SALES_Q4_1999        VALID
SH         TABLE PARTITION    SALES                                                   SALES_Q4_2000        VALID

468 rows selected.


OWNER      OBJECT_TYPE        STATUS    COUNT(*)
---------- ------------------ ------- ----------
OE         LOB                VALID            5
OE         TYPE               VALID            5
OE         INDEX              VALID            4
PM         LOB                VALID           17
PM         INDEX              VALID            1
QS         LOB                VALID            1
QS         INDEX              VALID           13
QS         TABLE              VALID            2
QS_CS      INDEX              VALID            6
QS_CS      TABLE              VALID            1
QS_ES      INDEX              VALID           12
QS_ES      TABLE              VALID            2
QS_OS      INDEX              VALID           12
QS_OS      TABLE              VALID            2
QS_WS      INDEX              VALID           12
QS_WS      TABLE              VALID            2
QS_CBADM   INDEX              VALID            7
QS_CBADM   TABLE              VALID            1

18 rows selected.


OWNER      TABLE_NAME                       NUM_ROWS
---------- ------------------------------ ----------
HR         COUNTRIES                              25
HR         DEPARTMENTS                            27
HR         EMPLOYEES                             107
HR         JOBS                                   19
HR         JOB_HISTORY                            10
HR         LOCATIONS                              23
HR         REGIONS                                 4
OE         CUSTOMERS                             319
OE         INVENTORIES                          1112
OE         ORDERS                                105
OE         ORDER_ITEMS                           665
OE         PRODUCT_DESCRIPTIONS                 8640
OE         PRODUCT_INFORMATION                   288
OE         PRODUCT_REF_LIST_NESTEDTAB
OE         SUBCATEGORY_REF_LIST_NESTEDTAB
OE         WAREHOUSES                              9
PM         ONLINE_MEDIA                            9
PM         PRINT_MEDIA                             4
QS         AQ$_AQ$_MEM_MC_H
QS         AQ$_AQ$_MEM_MC_I
QS         AQ$_AQ$_MEM_MC_NR
QS         AQ$_AQ$_MEM_MC_S
QS         AQ$_AQ$_MEM_MC_T
QS         AQ$_MEM_MC
QS         AQ$_QS_ORDERS_PR_MQTAB_H
QS         AQ$_QS_ORDERS_PR_MQTAB_I
QS         AQ$_QS_ORDERS_PR_MQTAB_NR
QS         AQ$_QS_ORDERS_PR_MQTAB_S
QS         AQ$_QS_ORDERS_PR_MQTAB_T
QS         QS_ORDERS_PR_MQTAB
QS         QS_ORDERS_SQTAB
QS         SYS_IOT_OVER_29683
QS         SYS_IOT_OVER_29708
QS_CBADM   AQ$_QS_CBADM_ORDERS_MQTAB_H
QS_CBADM   AQ$_QS_CBADM_ORDERS_MQTAB_I
QS_CBADM   AQ$_QS_CBADM_ORDERS_MQTAB_NR
QS_CBADM   AQ$_QS_CBADM_ORDERS_MQTAB_S
QS_CBADM   AQ$_QS_CBADM_ORDERS_MQTAB_T
QS_CBADM   QS_CBADM_ORDERS_MQTAB
QS_CBADM   QS_CBADM_ORDERS_SQTAB
QS_CBADM   SYS_IOT_OVER_29868
QS_CS      AQ$_QS_CS_ORDER_STATUS_QT_H
QS_CS      AQ$_QS_CS_ORDER_STATUS_QT_I
QS_CS      AQ$_QS_CS_ORDER_STATUS_QT_NR
QS_CS      AQ$_QS_CS_ORDER_STATUS_QT_S
QS_CS      AQ$_QS_CS_ORDER_STATUS_QT_T
QS_CS      ORDER_STATUS_TABLE
QS_CS      QS_CS_ORDER_STATUS_QT
QS_CS      SYS_IOT_OVER_29892
QS_ES      AQ$_QS_ES_ORDERS_MQTAB_H
QS_ES      AQ$_QS_ES_ORDERS_MQTAB_I
QS_ES      AQ$_QS_ES_ORDERS_MQTAB_NR
QS_ES      AQ$_QS_ES_ORDERS_MQTAB_S
QS_ES      AQ$_QS_ES_ORDERS_MQTAB_T
QS_ES      AQ$_QS_ES_ORDERS_PR_MQTAB_H
QS_ES      AQ$_QS_ES_ORDERS_PR_MQTAB_I
QS_ES      AQ$_QS_ES_ORDERS_PR_MQTAB_NR
QS_ES      AQ$_QS_ES_ORDERS_PR_MQTAB_S
QS_ES      AQ$_QS_ES_ORDERS_PR_MQTAB_T
QS_ES      QS_ES_ORDERS_MQTAB
QS_ES      QS_ES_ORDERS_PR_MQTAB
QS_ES      SYS_IOT_OVER_29727
QS_ES      SYS_IOT_OVER_29745
QS_OS      AQ$_QS_OS_ORDERS_MQTAB_H
QS_OS      AQ$_QS_OS_ORDERS_MQTAB_I
QS_OS      AQ$_QS_OS_ORDERS_MQTAB_NR
QS_OS      AQ$_QS_OS_ORDERS_MQTAB_S
QS_OS      AQ$_QS_OS_ORDERS_MQTAB_T
QS_OS      AQ$_QS_OS_ORDERS_PR_MQTAB_H
QS_OS      AQ$_QS_OS_ORDERS_PR_MQTAB_I
QS_OS      AQ$_QS_OS_ORDERS_PR_MQTAB_NR
QS_OS      AQ$_QS_OS_ORDERS_PR_MQTAB_S
QS_OS      AQ$_QS_OS_ORDERS_PR_MQTAB_T
QS_OS      QS_OS_ORDERS_MQTAB
QS_OS      QS_OS_ORDERS_PR_MQTAB
QS_OS      SYS_IOT_OVER_29817
QS_OS      SYS_IOT_OVER_29835
QS_WS      AQ$_QS_WS_ORDERS_MQTAB_H
QS_WS      AQ$_QS_WS_ORDERS_MQTAB_I
QS_WS      AQ$_QS_WS_ORDERS_MQTAB_NR
QS_WS      AQ$_QS_WS_ORDERS_MQTAB_S
QS_WS      AQ$_QS_WS_ORDERS_MQTAB_T
QS_WS      AQ$_QS_WS_ORDERS_PR_MQTAB_H
QS_WS      AQ$_QS_WS_ORDERS_PR_MQTAB_I
QS_WS      AQ$_QS_WS_ORDERS_PR_MQTAB_NR
QS_WS      AQ$_QS_WS_ORDERS_PR_MQTAB_S
QS_WS      AQ$_QS_WS_ORDERS_PR_MQTAB_T
QS_WS      QS_WS_ORDERS_MQTAB
QS_WS      QS_WS_ORDERS_PR_MQTAB
QS_WS      SYS_IOT_OVER_29772
QS_WS      SYS_IOT_OVER_29790
SH         CAL_MONTH_SALES_MV                     35
SH         CHANNELS                                5
SH         COSTS                              787766
SH         COUNTRIES                              19
SH         CUSTOMERS                           50000
SH         FWEEK_PSCAT_SALES_MV               149325
SH         MVIEW$_EXCEPTIONS                       0
SH         MV_CAPABILITIES_TABLE
SH         PLAN_TABLE
SH         PRODUCTS                            10000
SH         PROMOTIONS                            501
SH         REWRITE_TABLE
SH         SALES                             1016271
SH         SALES_TRANSACTIONS_EXT            1016271
SH         TIMES                                1461

106 rows selected.



Running the Schema Creation Scripts - (10g)

Finally, it is time to run the scripts necessary to create all of the Sample Schemas. If you simply want to create all Sample Schemas, Oracle provides a master script that runs all of the main scripts in their proper sequence. To call this script, you will need to provide the SYSTEM and SYS passwords as well as providing the passwords for the HR, OE, PM, IX, SH, and BI schema's. You will also need to supply the name of the default tablespace to use (i.e. EXAMPLE) along with the temporary tablespace (i.e. TEMP). And finally, the last variable is the directory name (including trailing delimiter) for all log files to be written to, all as follows:
SQL> @?/demo/schema/mksample systempwd syspwd hrpwd oepwd pmpwd ixpwd shpwd bipwd deflt_tbls temp_tbls log_dir
Here is an example call:
% sqlplus /nolog

SQL> @?/demo/schema/mksample manager change_on_install hr oe pm ix sh bi example temp $ORACLE_HOME/demo/schema/log/

NOTE: The entire process takes about 30 to 45 minutes to complete.

  If you are using Oracle10g Enterprise Edition - (Version: 10.1.0.2 to 10.1.0.4) and all ready to run the script $ORACLE_HOME/demo/schema/mksample.sql, you will notice that it is missing! In this directory, only the following files/directories are found:

  • mkplug.sql
  • mk_dir.sql
  • Directories for HR, OE, etc.

The actual sample schema scripts are not present as part of a default Enterprise Edition (EE) install. So, where do we get these missing script files? All demos are provided on the Companion CD.

You will need to execute the following steps to have access to the sample schema scripts:

  1. When installing the Companion CD, select the Oracle Home for your current database software installation (i.e. OraDb10g_home1). Also, select "Oracle Database 10g Products" from the "Install the Select a Product to Install" screen. (This is the first option)
  2. You can use the DBCA to create the sample schemas or use the master script "$ORACLE_HOME/demo/schema/mksample.sql". Also keep in mind that the mksample.sql script does not create the EXAMPLE tablespace, so you'll need to create it before running mksample.sql.
  3. If there was a patchset applied to the Oracle Database installation before installing the companion CD, (i.e. 10.1.0.4), that patchset should be installed again as the installed products in the OUI Inventory lists the patch set as an additional line under:

    • Oracle Database 10g 10.1.0.2.0
    • Oracle Database 10g 10.1.0.4.0

Query Sample Schema Objects Output
OWNER  OBJECT_TYPE          OBJECT_NAME                    SUBOBJECT_NAME   STATUS
------ -------------------- ------------------------------ ---------------- --------
BI     SYNONYM              CHANNELS                                        VALID
BI     SYNONYM              COSTS                                           VALID
BI     SYNONYM              COUNTRIES                                       VALID
BI     SYNONYM              CUSTOMERS                                       VALID
BI     SYNONYM              PRODUCTS                                        VALID
BI     SYNONYM              PROMOTIONS                                      VALID
BI     SYNONYM              SALES                                           VALID
BI     SYNONYM              TIMES                                           VALID
HR     INDEX                COUNTRY_C_ID_PK                                 VALID
HR     INDEX                DEPT_ID_PK                                      VALID
HR     INDEX                DEPT_LOCATION_IX                                VALID
HR     INDEX                EMP_DEPARTMENT_IX                               VALID
HR     INDEX                EMP_EMAIL_UK                                    VALID
HR     INDEX                EMP_EMP_ID_PK                                   VALID
HR     INDEX                EMP_JOB_IX                                      VALID
HR     INDEX                EMP_MANAGER_IX                                  VALID
HR     INDEX                EMP_NAME_IX                                     VALID
HR     INDEX                JHIST_DEPARTMENT_IX                             VALID
HR     INDEX                JHIST_EMPLOYEE_IX                               VALID
HR     INDEX                JHIST_EMP_ID_ST_DATE_PK                         VALID
HR     INDEX                JHIST_JOB_IX                                    VALID
HR     INDEX                JOB_ID_PK                                       VALID
HR     INDEX                LOC_CITY_IX                                     VALID
HR     INDEX                LOC_COUNTRY_IX                                  VALID
HR     INDEX                LOC_ID_PK                                       VALID
HR     INDEX                LOC_STATE_PROVINCE_IX                           VALID
HR     INDEX                REG_ID_PK                                       VALID
HR     PROCEDURE            ADD_JOB_HISTORY                                 VALID
HR     PROCEDURE            SECURE_DML                                      VALID
HR     SEQUENCE             DEPARTMENTS_SEQ                                 VALID
HR     SEQUENCE             EMPLOYEES_SEQ                                   VALID
HR     SEQUENCE             LOCATIONS_SEQ                                   VALID
HR     TABLE                COUNTRIES                                       VALID
HR     TABLE                DEPARTMENTS                                     VALID
HR     TABLE                EMPLOYEES                                       VALID
HR     TABLE                JOBS                                            VALID
HR     TABLE                JOB_HISTORY                                     VALID
HR     TABLE                LOCATIONS                                       VALID
HR     TABLE                REGIONS                                         VALID
HR     TRIGGER              SECURE_EMPLOYEES                                VALID
HR     TRIGGER              UPDATE_JOB_HISTORY                              VALID
HR     VIEW                 EMP_DETAILS_VIEW                                VALID
IX     EVALUATION CONTEXT   AQ$_ORDERS_QUEUETABLE_V                         VALID
IX     EVALUATION CONTEXT   AQ$_STREAMS_QUEUE_TABLE_V                       VALID
IX     QUEUE                AQ$_ORDERS_QUEUETABLE_E                         VALID
IX     QUEUE                AQ$_STREAMS_QUEUE_TABLE_E                       VALID
IX     QUEUE                ORDERS_QUEUE                                    VALID
IX     QUEUE                STREAMS_QUEUE                                   VALID
IX     RULE SET             ORDERS_QUEUE_N                                  VALID
IX     RULE SET             ORDERS_QUEUE_R                                  VALID
IX     RULE SET             STREAMS_QUEUE_N                                 VALID
IX     RULE SET             STREAMS_QUEUE_R                                 VALID
IX     SEQUENCE             AQ$_ORDERS_QUEUETABLE_N                         VALID
IX     SEQUENCE             AQ$_STREAMS_QUEUE_TABLE_N                       VALID
IX     TABLE                AQ$_ORDERS_QUEUETABLE_G                         VALID
IX     TABLE                AQ$_ORDERS_QUEUETABLE_H                         VALID
IX     TABLE                AQ$_ORDERS_QUEUETABLE_I                         VALID
IX     TABLE                AQ$_ORDERS_QUEUETABLE_S                         VALID
IX     TABLE                AQ$_ORDERS_QUEUETABLE_T                         VALID
IX     TABLE                AQ$_STREAMS_QUEUE_TABLE_G                       VALID
IX     TABLE                AQ$_STREAMS_QUEUE_TABLE_H                       VALID
IX     TABLE                AQ$_STREAMS_QUEUE_TABLE_I                       VALID
IX     TABLE                AQ$_STREAMS_QUEUE_TABLE_S                       VALID
IX     TABLE                AQ$_STREAMS_QUEUE_TABLE_T                       VALID
IX     TABLE                ORDERS_QUEUETABLE                               VALID
IX     TABLE                STREAMS_QUEUE_TABLE                             VALID
IX     TYPE                 ORDER_EVENT_TYP                                 VALID
IX     VIEW                 AQ$ORDERS_QUEUETABLE                            VALID
IX     VIEW                 AQ$ORDERS_QUEUETABLE_R                          VALID
IX     VIEW                 AQ$ORDERS_QUEUETABLE_S                          VALID
IX     VIEW                 AQ$STREAMS_QUEUE_TABLE                          VALID
IX     VIEW                 AQ$STREAMS_QUEUE_TABLE_R                        VALID
IX     VIEW                 AQ$STREAMS_QUEUE_TABLE_S                        VALID
OE     FUNCTION             GET_PHONE_NUMBER_F                              VALID
OE     INDEX                CUSTOMERS_PK                                    VALID
OE     INDEX                CUST_ACCOUNT_MANAGER_IX                         VALID
OE     INDEX                CUST_EMAIL_IX                                   VALID
OE     INDEX                CUST_LNAME_IX                                   VALID
OE     INDEX                CUST_UPPER_NAME_IX                              VALID
OE     INDEX                INVENTORY_IX                                    VALID
OE     INDEX                INV_PRODUCT_IX                                  VALID
OE     INDEX                ITEM_ORDER_IX                                   VALID
OE     INDEX                ITEM_PRODUCT_IX                                 VALID
OE     INDEX                ORDER_ITEMS_PK                                  VALID
OE     INDEX                ORDER_ITEMS_UK                                  VALID
OE     INDEX                ORDER_PK                                        VALID
OE     INDEX                ORD_CUSTOMER_IX                                 VALID
OE     INDEX                ORD_ORDER_DATE_IX                               VALID
OE     INDEX                ORD_SALES_REP_IX                                VALID
OE     INDEX                PRD_DESC_PK                                     VALID
OE     INDEX                PRODUCT_INFORMATION_PK                          VALID
OE     INDEX                PROD_NAME_IX                                    VALID
OE     INDEX                PROD_SUPPLIER_IX                                VALID
OE     INDEX                PROMO_ID_PK                                     VALID
OE     INDEX                REFERENCE_IS_UNIQUE                             VALID
OE     INDEX                WAREHOUSES_PK                                   VALID
OE     INDEX                WHS_LOCATION_IX                                 VALID
OE     SEQUENCE             ORDERS_SEQ                                      VALID
OE     SYNONYM              COUNTRIES                                       VALID
OE     SYNONYM              DEPARTMENTS                                     VALID
OE     SYNONYM              EMPLOYEES                                       VALID
OE     SYNONYM              JOBS                                            VALID
OE     SYNONYM              JOB_HISTORY                                     VALID
OE     SYNONYM              LOCATIONS                                       VALID
OE     TABLE                CATEGORIES_TAB                                  VALID
OE     TABLE                CUSTOMERS                                       VALID
OE     TABLE                INVENTORIES                                     VALID
OE     TABLE                ORDERS                                          VALID
OE     TABLE                ORDER_ITEMS                                     VALID
OE     TABLE                PRODUCT_DESCRIPTIONS                            VALID
OE     TABLE                PRODUCT_INFORMATION                             VALID
OE     TABLE                PRODUCT_REF_LIST_NESTEDTAB                      VALID
OE     TABLE                PROMOTIONS                                      VALID
OE     TABLE                PURCHASEORDERS                                  VALID
OE     TABLE                STYLESHEET_TAB                                  VALID
OE     TABLE                SUBCATEGORY_REF_LIST_NESTEDTAB                  VALID
OE     TABLE                WAREHOUSES                                      VALID
OE     TRIGGER              INSERT_ORD_LINE                                 VALID
OE     TRIGGER              ORDERS_ITEMS_TRG                                VALID
OE     TRIGGER              ORDERS_TRG                                      VALID
OE     TRIGGER              PURCHASEORDERS$xd                               VALID
OE     TYPE                 CATALOG_TYP                    $VSN_1           VALID
OE     TYPE                 CATALOG_TYP                                     VALID
OE     TYPE                 CATEGORY_TYP                   $VSN_1           VALID
OE     TYPE                 CATEGORY_TYP                                    VALID
OE     TYPE                 COMPOSITE_CATEGORY_TYP         $VSN_1           VALID
OE     TYPE                 COMPOSITE_CATEGORY_TYP                          VALID
OE     TYPE                 CORPORATE_CUSTOMER_TYP                          VALID
OE     TYPE                 CUSTOMER_TYP                                    VALID
OE     TYPE                 CUST_ADDRESS_TYP                                VALID
OE     TYPE                 INVENTORY_LIST_TYP                              VALID
OE     TYPE                 INVENTORY_TYP                                   VALID
OE     TYPE                 LEAF_CATEGORY_TYP              $VSN_1           VALID
OE     TYPE                 LEAF_CATEGORY_TYP                               VALID
OE     TYPE                 ORDER_ITEM_LIST_TYP                             VALID
OE     TYPE                 ORDER_ITEM_TYP                                  VALID
OE     TYPE                 ORDER_LIST_TYP                                  VALID
OE     TYPE                 ORDER_TYP                                       VALID
OE     TYPE                 PHONE_LIST_TYP                                  VALID
OE     TYPE                 PRODUCT_INFORMATION_TYP                         VALID
OE     TYPE                 PRODUCT_REF_LIST_TYP                            VALID
OE     TYPE                 SUBCATEGORY_REF_LIST_TYP                        VALID
OE     TYPE                 WAREHOUSE_TYP                                   VALID
OE     TYPE                 XDBPO_ACTIONS_TYPE                              VALID
OE     TYPE                 XDBPO_ACTION_COLLECTION                         VALID
OE     TYPE                 XDBPO_ACTION_TYPE                               VALID
OE     TYPE                 XDBPO_LINEITEMS_TYPE                            VALID
OE     TYPE                 XDBPO_LINEITEM_COLLECTION                       VALID
OE     TYPE                 XDBPO_LINEITEM_TYPE                             VALID
OE     TYPE                 XDBPO_PART_TYPE                                 VALID
OE     TYPE                 XDBPO_REJECTION_TYPE                            VALID
OE     TYPE                 XDBPO_SHIPINSTRUCTIONS_TYPE                     VALID
OE     TYPE                 XDBPO_TYPE                                      VALID
OE     TYPE BODY            CATALOG_TYP                                     VALID
OE     TYPE BODY            COMPOSITE_CATEGORY_TYP                          VALID
OE     TYPE BODY            LEAF_CATEGORY_TYP                               VALID
OE     VIEW                 ACCOUNT_MANAGERS                                VALID
OE     VIEW                 BOMBAY_INVENTORY                                VALID
OE     VIEW                 CUSTOMERS_VIEW                                  VALID
OE     VIEW                 DEPTVIEW                                        VALID
OE     VIEW                 OC_CORPORATE_CUSTOMERS                          VALID
OE     VIEW                 OC_CUSTOMERS                                    VALID
OE     VIEW                 OC_INVENTORIES                                  VALID
OE     VIEW                 OC_ORDERS                                       VALID
OE     VIEW                 OC_PRODUCT_INFORMATION                          VALID
OE     VIEW                 ORDERS_VIEW                                     VALID
OE     VIEW                 PRODUCTS                                        VALID
OE     VIEW                 PRODUCT_PRICES                                  VALID
OE     VIEW                 SYDNEY_INVENTORY                                VALID
OE     VIEW                 TORONTO_INVENTORY                               VALID
PM     INDEX                ONLINEMEDIA_PK                                  VALID
PM     INDEX                PRINTMEDIA_PK                                   VALID
PM     TABLE                ONLINE_MEDIA                                    VALID
PM     TABLE                PRINT_MEDIA                                     VALID
PM     TABLE                TEXTDOCS_NESTEDTAB                              VALID
PM     TYPE                 ADHEADER_TYP                                    VALID
PM     TYPE                 TEXTDOC_TAB                                     VALID
PM     TYPE                 TEXTDOC_TYP                                     VALID
SH     DIMENSION            CHANNELS_DIM                                    VALID
SH     DIMENSION            CUSTOMERS_DIM                                   VALID
SH     DIMENSION            PRODUCTS_DIM                                    VALID
SH     DIMENSION            PROMOTIONS_DIM                                  VALID
SH     DIMENSION            TIMES_DIM                                       VALID
SH     INDEX                CHANNELS_PK                                     VALID
SH     INDEX                COSTS_PROD_BIX                                  VALID
SH     INDEX                COSTS_TIME_BIX                                  VALID
SH     INDEX                COUNTRIES_PK                                    VALID
SH     INDEX                CUSTOMERS_GENDER_BIX                            VALID
SH     INDEX                CUSTOMERS_MARITAL_BIX                           VALID
SH     INDEX                CUSTOMERS_PK                                    VALID
SH     INDEX                CUSTOMERS_YOB_BIX                               VALID
SH     INDEX                DR$SUP_TEXT_IDX$X                               VALID
SH     INDEX                FW_PSC_S_MV_CHAN_BIX                            VALID
SH     INDEX                FW_PSC_S_MV_PROMO_BIX                           VALID
SH     INDEX                FW_PSC_S_MV_SUBCAT_BIX                          VALID
SH     INDEX                FW_PSC_S_MV_WD_BIX                              VALID
SH     INDEX                PRODUCTS_PK                                     VALID
SH     INDEX                PRODUCTS_PROD_CAT_IX                            VALID
SH     INDEX                PRODUCTS_PROD_STATUS_BIX                        VALID
SH     INDEX                PRODUCTS_PROD_SUBCAT_IX                         VALID
SH     INDEX                PROMO_PK                                        VALID
SH     INDEX                SALES_CHANNEL_BIX                               VALID
SH     INDEX                SALES_CUST_BIX                                  VALID
SH     INDEX                SALES_PROD_BIX                                  VALID
SH     INDEX                SALES_PROMO_BIX                                 VALID
SH     INDEX                SALES_TIME_BIX                                  VALID
SH     INDEX                SUP_TEXT_IDX                                    VALID
SH     INDEX                TIMES_PK                                        VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_1995       VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_1996       VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_H1_1997    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_H2_1997    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q1_1998    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q1_1999    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q1_2000    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q1_2001    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q1_2002    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q1_2003    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q2_1998    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q2_1999    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q2_2000    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q2_2001    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q2_2002    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q2_2003    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q3_1998    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q3_1999    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q3_2000    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q3_2001    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q3_2002    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q3_2003    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q4_1998    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q4_1999    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q4_2000    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q4_2001    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q4_2002    VALID
SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q4_2003    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_1995       VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_1996       VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_H1_1997    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_H2_1997    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q1_1998    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q1_1999    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q1_2000    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q1_2001    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q1_2002    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q1_2003    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q2_1998    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q2_1999    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q2_2000    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q2_2001    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q2_2002    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q2_2003    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q3_1998    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q3_1999    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q3_2000    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q3_2001    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q3_2002    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q3_2003    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q4_1998    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q4_1999    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q4_2000    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q4_2001    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q4_2002    VALID
SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q4_2003    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_1995       VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_1996       VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_H1_1997    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_H2_1997    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q1_1998    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q1_1999    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q1_2000    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q1_2001    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q1_2002    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q1_2003    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q2_1998    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q2_1999    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q2_2000    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q2_2001    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q2_2002    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q2_2003    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q3_1998    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q3_1999    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q3_2000    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q3_2001    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q3_2002    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q3_2003    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q4_1998    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q4_1999    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q4_2000    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q4_2001    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q4_2002    VALID
SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q4_2003    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_1995       VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_1996       VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_H1_1997    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_H2_1997    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q1_1998    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q1_1999    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q1_2000    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q1_2001    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q1_2002    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q1_2003    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q2_1998    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q2_1999    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q2_2000    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q2_2001    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q2_2002    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q2_2003    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q3_1998    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q3_1999    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q3_2000    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q3_2001    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q3_2002    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q3_2003    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q4_1998    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q4_1999    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q4_2000    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q4_2001    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q4_2002    VALID
SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q4_2003    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_1995       VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_1996       VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_H1_1997    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_H2_1997    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q1_1998    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q1_1999    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q1_2000    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q1_2001    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q1_2002    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q1_2003    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q2_1998    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q2_1999    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q2_2000    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q2_2001    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q2_2002    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q2_2003    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q3_1998    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q3_1999    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q3_2000    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q3_2001    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q3_2002    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q3_2003    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q4_1998    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q4_1999    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q4_2000    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q4_2001    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q4_2002    VALID
SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q4_2003    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_1995       VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_1996       VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_H1_1997    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_H2_1997    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q1_1998    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q1_1999    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q1_2000    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q1_2001    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q1_2002    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q1_2003    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q2_1998    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q2_1999    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q2_2000    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q2_2001    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q2_2002    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q2_2003    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q3_1998    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q3_1999    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q3_2000    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q3_2001    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q3_2002    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q3_2003    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q4_1998    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q4_1999    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q4_2000    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q4_2001    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q4_2002    VALID
SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q4_2003    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_1995       VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_1996       VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_H1_1997    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_H2_1997    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q1_1998    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q1_1999    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q1_2000    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q1_2001    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q1_2002    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q1_2003    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q2_1998    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q2_1999    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q2_2000    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q2_2001    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q2_2002    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q2_2003    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q3_1998    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q3_1999    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q3_2000    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q3_2001    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q3_2002    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q3_2003    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q4_1998    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q4_1999    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q4_2000    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q4_2001    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q4_2002    VALID
SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q4_2003    VALID
SH     MATERIALIZED VIEW    CAL_MONTH_SALES_MV                              VALID
SH     MATERIALIZED VIEW    FWEEK_PSCAT_SALES_MV                            VALID
SH     TABLE                CAL_MONTH_SALES_MV                              VALID
SH     TABLE                CHANNELS                                        VALID
SH     TABLE                COSTS                                           VALID
SH     TABLE                COUNTRIES                                       VALID
SH     TABLE                CUSTOMERS                                       VALID
SH     TABLE                DR$SUP_TEXT_IDX$I                               VALID
SH     TABLE                DR$SUP_TEXT_IDX$K                               VALID
SH     TABLE                DR$SUP_TEXT_IDX$N                               VALID
SH     TABLE                DR$SUP_TEXT_IDX$R                               VALID
SH     TABLE                FWEEK_PSCAT_SALES_MV                            VALID
SH     TABLE                MVIEW$_EXCEPTIONS                               VALID
SH     TABLE                PRODUCTS                                        VALID
SH     TABLE                PROMOTIONS                                      VALID
SH     TABLE                SALES                                           VALID
SH     TABLE                SALES_TRANSACTIONS_EXT                          VALID
SH     TABLE                SUPPLEMENTARY_DEMOGRAPHICS                      VALID
SH     TABLE                TIMES                                           VALID
SH     TABLE PARTITION      COSTS                          COSTS_1995       VALID
SH     TABLE PARTITION      COSTS                          COSTS_1996       VALID
SH     TABLE PARTITION      COSTS                          COSTS_H1_1997    VALID
SH     TABLE PARTITION      COSTS                          COSTS_H2_1997    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q1_1998    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q1_1999    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q1_2000    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q1_2001    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q1_2002    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q1_2003    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q2_1998    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q2_1999    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q2_2000    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q2_2001    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q2_2002    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q2_2003    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q3_1998    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q3_1999    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q3_2000    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q3_2001    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q3_2002    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q3_2003    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q4_1998    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q4_1999    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q4_2000    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q4_2001    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q4_2002    VALID
SH     TABLE PARTITION      COSTS                          COSTS_Q4_2003    VALID
SH     TABLE PARTITION      SALES                          SALES_1995       VALID
SH     TABLE PARTITION      SALES                          SALES_1996       VALID
SH     TABLE PARTITION      SALES                          SALES_H1_1997    VALID
SH     TABLE PARTITION      SALES                          SALES_H2_1997    VALID
SH     TABLE PARTITION      SALES                          SALES_Q1_1998    VALID
SH     TABLE PARTITION      SALES                          SALES_Q1_1999    VALID
SH     TABLE PARTITION      SALES                          SALES_Q1_2000    VALID
SH     TABLE PARTITION      SALES                          SALES_Q1_2001    VALID
SH     TABLE PARTITION      SALES                          SALES_Q1_2002    VALID
SH     TABLE PARTITION      SALES                          SALES_Q1_2003    VALID
SH     TABLE PARTITION      SALES                          SALES_Q2_1998    VALID
SH     TABLE PARTITION      SALES                          SALES_Q2_1999    VALID
SH     TABLE PARTITION      SALES                          SALES_Q2_2000    VALID
SH     TABLE PARTITION      SALES                          SALES_Q2_2001    VALID
SH     TABLE PARTITION      SALES                          SALES_Q2_2002    VALID
SH     TABLE PARTITION      SALES                          SALES_Q2_2003    VALID
SH     TABLE PARTITION      SALES                          SALES_Q3_1998    VALID
SH     TABLE PARTITION      SALES                          SALES_Q3_1999    VALID
SH     TABLE PARTITION      SALES                          SALES_Q3_2000    VALID
SH     TABLE PARTITION      SALES                          SALES_Q3_2001    VALID
SH     TABLE PARTITION      SALES                          SALES_Q3_2002    VALID
SH     TABLE PARTITION      SALES                          SALES_Q3_2003    VALID
SH     TABLE PARTITION      SALES                          SALES_Q4_1998    VALID
SH     TABLE PARTITION      SALES                          SALES_Q4_1999    VALID
SH     TABLE PARTITION      SALES                          SALES_Q4_2000    VALID
SH     TABLE PARTITION      SALES                          SALES_Q4_2001    VALID
SH     TABLE PARTITION      SALES                          SALES_Q4_2002    VALID
SH     TABLE PARTITION      SALES                          SALES_Q4_2003    VALID
SH     VIEW                 PROFITS                                         VALID

480 rows selected.


Data types used

OWNER  DATA_TYPE                           DATA_TYPE_OWNER  DAT   COUNT(*)
------ ----------------------------------- ---------------- --- ----------
PM     ADHEADER_TYP                        PM                            1
IX     ANYDATA                             SYS                           4
IX     AQ$_SIG_PROP                        SYS                           4
PM     BFILE                                                             1
PM     BLOB                                                              2
SH     BLOB                                                              2
HR     CHAR                                                              3
OE     CHAR                                                              2
SH     CHAR                                                              5
IX     CLOB                                                              2
PM     CLOB                                                              3
OE     CUSTOMER_TYP                        OE               REF          1
OE     CUST_ADDRESS_TYP                    OE                            3
HR     DATE                                                              3
IX     DATE                                                              6
OE     DATE                                                              2
SH     DATE                                                             19
OE     INTERVAL YEAR(2) TO MONTH                                         3
OE     INVENTORY_LIST_TYP                  OE                            1
PM     NCLOB                                                             1
HR     NUMBER                                                           21
IX     NUMBER                                                           66
OE     NUMBER                                                           81
PM     NUMBER                                                            3
SH     NUMBER                                                          101
OE     NVARCHAR2                                                         7
PM     ORDAUDIO                            ORDSYS                        1
PM     ORDDOC                              ORDSYS                        1
IX     ORDER_EVENT_TYP                     IX                            2
OE     ORDER_ITEM_LIST_TYP                 OE                            1
OE     ORDER_LIST_TYP                      OE                            2
PM     ORDIMAGE                            ORDSYS                        2
PM     ORDIMAGESIGNATURE                   ORDSYS                        1
PM     ORDVIDEO                            ORDSYS                        1
OE     PHONE_LIST_TYP                      OE                            3
IX     RAW                                                              24
IX     ROWID                                                             4
SH     ROWID                                                             2
OE     SDO_GEOMETRY                        MDSYS                         2
PM     TEXTDOC_TAB                         PM                            1
IX     TIMESTAMP(6)                                                     18
OE     TIMESTAMP(6) WITH LOCAL TIME ZONE                                 1
IX     TIMESTAMP(9)                                                      2
HR     VARCHAR2                                                         24
IX     VARCHAR2                                                         97
OE     VARCHAR2                                                         53
SH     VARCHAR2                                                         51
OE     WAREHOUSE_TYP                       OE                            1
OE     XMLTYPE                             OE                            1
OE     XMLTYPE                             SYS                           3

50 rows selected.


XML tables

OWNER  TABLE_NAME                     SCHEMA_OWNER     STORAGE_TYPE
------ ------------------------------ ---------------- --------------------
OE     PURCHASEORDERS                 OE               OBJECT-RELATIONAL

1 row selected.


All objects named 'SYS%' (LOBs etc)

OWNER  OBJECT_TYPE          STATUS     COUNT(*)
------ -------------------- -------- ----------
IX     INDEX                VALID            12
OE     INDEX                VALID             5
PM     INDEX                VALID             1
SH     INDEX                VALID             2
IX     LOB                  VALID             3
OE     LOB                  VALID            15
PM     LOB                  VALID            17
SH     LOB                  VALID             2
IX     TABLE                VALID             2
OE     TYPE                 VALID             5

10 rows selected.


All constraints

OWNER  CONSTRAINT_TYPE      STATUS   VALIDATED        GENERATED          COUNT(*)
------ -------------------- -------- ---------------- ---------------- ----------
HR     Check or Not Null    ENABLED  VALIDATED        USER NAME                15
IX     Check or Not Null    ENABLED  VALIDATED        GENERATED NAME            4
OE     Check or Not Null    ENABLED  VALIDATED        USER NAME                13
OE     Check or Not Null    ENABLED  VALIDATED        GENERATED NAME            2
SH     Check or Not Null    ENABLED  VALIDATED        GENERATED NAME          126
SH     Foreign key          DISABLED NOT VALIDATED    USER NAME                 2
OE     Foreign key          ENABLED  NOT VALIDATED    USER NAME                 2
SH     Foreign key          ENABLED  NOT VALIDATED    USER NAME                 8
HR     Foreign key          ENABLED  VALIDATED        USER NAME                10
OE     Foreign key          ENABLED  VALIDATED        USER NAME                 8
PM     Foreign key          ENABLED  VALIDATED        USER NAME                 2
SH     Primary key          DISABLED NOT VALIDATED    USER NAME                 1
SH     Primary key          ENABLED  NOT VALIDATED    USER NAME                 6
HR     Primary key          ENABLED  VALIDATED        USER NAME                 7
IX     Primary key          ENABLED  VALIDATED        GENERATED NAME           12
OE     Primary key          ENABLED  VALIDATED        USER NAME                 8
OE     Primary key          ENABLED  VALIDATED        GENERATED NAME            1
PM     Primary key          ENABLED  VALIDATED        USER NAME                 2
SH     Primary key          ENABLED  VALIDATED        GENERATED NAME            2
HR     Read only view       ENABLED  NOT VALIDATED    GENERATED NAME            1
IX     Read only view       ENABLED  NOT VALIDATED    GENERATED NAME            6
HR     Unique key           ENABLED  VALIDATED        USER NAME                 1
OE     Unique key           ENABLED  VALIDATED        USER NAME                 1
OE     Unique key           ENABLED  VALIDATED        GENERATED NAME            4
PM     Unique key           ENABLED  VALIDATED        GENERATED NAME            1

25 rows selected.


All dimensions

OWNER  DIMENSION_NAME       I COMPILE_STATE
------ -------------------- - -------------
SH     CHANNELS_DIM         N VALID
SH     CUSTOMERS_DIM        N VALID
SH     PRODUCTS_DIM         N VALID
SH     PROMOTIONS_DIM       N VALID
SH     TIMES_DIM            N VALID

5 rows selected.


All granted roles

GRANTED_ROLE              GRANTEE
------------------------- -------
AQ_ADMINISTRATOR_ROLE     IX
AQ_USER_ROLE              IX
CONNECT                   BI
CONNECT                   HR
CONNECT                   IX
CONNECT                   OE
CONNECT                   PM
CONNECT                   SH
RESOURCE                  BI
RESOURCE                  HR
RESOURCE                  IX
RESOURCE                  OE
RESOURCE                  PM
RESOURCE                  SH
SELECT_CATALOG_ROLE       IX
SELECT_CATALOG_ROLE       SH
XDBADMIN                  OE

17 rows selected.


All granted system privileges

PRIVILEGE                 GRANTEE
------------------------- -------
ALTER SESSION             IX
CREATE CLUSTER            IX
CREATE DATABASE LINK      IX
CREATE DIMENSION          SH
CREATE INDEXTYPE          IX
CREATE MATERIALIZED VIEW  OE
CREATE MATERIALIZED VIEW  SH
CREATE OPERATOR           IX
CREATE PROCEDURE          IX
CREATE RULE               IX
CREATE RULE SET           IX
CREATE SEQUENCE           IX
CREATE SESSION            IX
CREATE SYNONYM            IX
CREATE TABLE              IX
CREATE TRIGGER            IX
CREATE TYPE               IX
CREATE VIEW               IX
QUERY REWRITE             OE
QUERY REWRITE             SH
SELECT ANY DICTIONARY     IX
UNLIMITED TABLESPACE      BI
UNLIMITED TABLESPACE      HR
UNLIMITED TABLESPACE      IX
UNLIMITED TABLESPACE      OE
UNLIMITED TABLESPACE      PM
UNLIMITED TABLESPACE      SH

27 rows selected.


All granted object privileges

OWNER  TABLE_NAME                     PRIVILEGE                 GRANTEE
------ ------------------------------ ------------------------- -------
HR     COUNTRIES                      REFERENCES                OE
HR     COUNTRIES                      SELECT                    OE
HR     DEPARTMENTS                    SELECT                    OE
HR     EMPLOYEES                      REFERENCES                OE
HR     EMPLOYEES                      SELECT                    OE
HR     JOBS                           SELECT                    OE
HR     JOB_HISTORY                    SELECT                    OE
HR     LOCATIONS                      REFERENCES                OE
HR     LOCATIONS                      SELECT                    OE
OE     BOMBAY_INVENTORY               SELECT                    BI
OE     CUSTOMERS                      SELECT                    BI
OE     CUSTOMERS                      SELECT                    PM
OE     INVENTORIES                    SELECT                    BI
OE     INVENTORIES                    SELECT                    PM
OE     ORDERS                         SELECT                    BI
OE     ORDERS                         SELECT                    PM
OE     ORDER_ITEMS                    SELECT                    BI
OE     ORDER_ITEMS                    SELECT                    PM
OE     PRODUCTS                       SELECT                    BI
OE     PRODUCT_DESCRIPTIONS           SELECT                    BI
OE     PRODUCT_DESCRIPTIONS           SELECT                    PM
OE     PRODUCT_INFORMATION            REFERENCES                PM
OE     PRODUCT_INFORMATION            SELECT                    BI
OE     PRODUCT_INFORMATION            SELECT                    PM
OE     PRODUCT_PRICES                 SELECT                    BI
OE     PROMOTIONS                     SELECT                    BI
OE     SYDNEY_INVENTORY               SELECT                    BI
OE     TORONTO_INVENTORY              SELECT                    BI
OE     WAREHOUSES                     SELECT                    BI
OE     WAREHOUSES                     SELECT                    PM
SH     CAL_MONTH_SALES_MV             SELECT                    BI
SH     CHANNELS                       SELECT                    BI
SH     COSTS                          SELECT                    BI
SH     COUNTRIES                      SELECT                    BI
SH     CUSTOMERS                      SELECT                    BI
SH     FWEEK_PSCAT_SALES_MV           SELECT                    BI
SH     PRODUCTS                       SELECT                    BI
SH     PROMOTIONS                     SELECT                    BI
SH     SALES                          SELECT                    BI
SH     TIMES                          SELECT                    BI
SYS    DATA_FILE_DIR                  READ                      SH
SYS    DBMS_APPLY_ADM                 EXECUTE                   IX
SYS    DBMS_AQ                        EXECUTE                   IX
SYS    DBMS_AQADM                     EXECUTE                   IX
SYS    DBMS_AQ_BQVIEW                 EXECUTE                   IX
SYS    DBMS_CAPTURE_ADM               EXECUTE                   IX
SYS    DBMS_FLASHBACK                 EXECUTE                   IX
SYS    DBMS_PROPAGATION_ADM           EXECUTE                   IX
SYS    DBMS_STATS                     EXECUTE                   HR
SYS    DBMS_STATS                     EXECUTE                   IX
SYS    DBMS_STATS                     EXECUTE                   OE
SYS    DBMS_STATS                     EXECUTE                   PM
SYS    DBMS_STATS                     EXECUTE                   SH
SYS    DBMS_STREAMS_ADM               EXECUTE                   IX
SYS    LOG_FILE_DIR                   READ                      SH
SYS    LOG_FILE_DIR                   WRITE                     SH
SYS    MEDIA_DIR                      READ                      PM
SYS    QT58899_BUFFER                 SELECT                    IX
SYS    QT58924_BUFFER                 SELECT                    IX

59 rows selected.


Space usage

OWNER  SEGMENT_TYPE         SUM(BYTES)
------ -------------------- ----------
HR     INDEX                   1245184
HR     TABLE                    393216
HR                             1638400
IX     INDEX                    786432
IX     TABLE                    393216
IX     LOBINDEX                 196608
IX     LOBSEGMENT               196608
IX                             1572864
OE     INDEX                   2555904
OE     TABLE                   4325376
OE     LOBINDEX                 983040
OE     LOBSEGMENT               983040
OE     NESTED TABLE             131072
OE                             8978432
PM     INDEX                    196608
PM     TABLE                    131072
PM     LOBINDEX                1114112
PM     LOBSEGMENT             10944512
PM     NESTED TABLE              65536
PM                            12451840
SH     INDEX                   2490368
SH     TABLE                  18874368
SH     LOBINDEX                 131072
SH     LOBSEGMENT               131072
SH     INDEX PARTITION        17170432
SH     TABLE PARTITION        18481152
SH                            57278464
                              81920000

28 rows selected.


Table cardinality relational and object tables

OWNER  TABLE_NAME                       NUM_ROWS
------ ------------------------------ ----------
HR     COUNTRIES                              25
HR     DEPARTMENTS                            27
HR     EMPLOYEES                             107
HR     JOBS                                   19
HR     JOB_HISTORY                            10
HR     LOCATIONS                              23
HR     REGIONS                                 4
IX     AQ$_ORDERS_QUEUETABLE_G                 0
IX     AQ$_ORDERS_QUEUETABLE_H                 2
IX     AQ$_ORDERS_QUEUETABLE_I                 0
IX     AQ$_ORDERS_QUEUETABLE_S                 4
IX     AQ$_ORDERS_QUEUETABLE_T                 2
IX     AQ$_STREAMS_QUEUE_TABLE_G               0
IX     AQ$_STREAMS_QUEUE_TABLE_H               0
IX     AQ$_STREAMS_QUEUE_TABLE_I               0
IX     AQ$_STREAMS_QUEUE_TABLE_S               1
IX     AQ$_STREAMS_QUEUE_TABLE_T               0
IX     ORDERS_QUEUETABLE                       1
IX     STREAMS_QUEUE_TABLE                     0
IX     SYS_IOT_OVER_58912                      0
IX     SYS_IOT_OVER_58939                      0
OE     CATEGORIES_TAB                         22
OE     CUSTOMERS                             319
OE     INVENTORIES                          1112
OE     ORDERS                                105
OE     ORDER_ITEMS                           665
OE     PRODUCT_DESCRIPTIONS                 8640
OE     PRODUCT_INFORMATION                   288
OE     PRODUCT_REF_LIST_NESTEDTAB            288
OE     PROMOTIONS                              2
OE     PURCHASEORDERS                        138
OE     STYLESHEET_TAB                          1
OE     SUBCATEGORY_REF_LIST_NESTEDTAB         21
OE     WAREHOUSES                              9
PM     ONLINE_MEDIA                            9
PM     PRINT_MEDIA                             4
PM     TEXTDOCS_NESTEDTAB                     12
SH     CAL_MONTH_SALES_MV                     48
SH     CHANNELS                                5
SH     COSTS                                   0
SH     COUNTRIES                              23
SH     CUSTOMERS                           55500
SH     DR$SUP_TEXT_IDX$I
SH     DR$SUP_TEXT_IDX$K
SH     DR$SUP_TEXT_IDX$N
SH     DR$SUP_TEXT_IDX$R
SH     FWEEK_PSCAT_SALES_MV                11266
SH     MVIEW$_EXCEPTIONS                       0
SH     PRODUCTS                               72
SH     PROMOTIONS                            503
SH     SALES                              918843
SH     SALES_TRANSACTIONS_EXT
SH     SUPPLEMENTARY_DEMOGRAPHICS           4500
SH     TIMES                                1826

54 rows selected.


Index cardinality (without  LOB indexes)

OWNER  INDEX_NAME                DISTINCT_KEYS   NUM_ROWS
------ ------------------------- ------------- ----------
HR     COUNTRY_C_ID_PK                      25         25
HR     DEPT_ID_PK                           27         27
HR     DEPT_LOCATION_IX                      7         27
HR     EMP_DEPARTMENT_IX                    11        106
HR     EMP_EMAIL_UK                        107        107
HR     EMP_EMP_ID_PK                       107        107
HR     EMP_JOB_IX                           19        107
HR     EMP_MANAGER_IX                       18        106
HR     EMP_NAME_IX                         107        107
HR     JHIST_DEPARTMENT_IX                   6         10
HR     JHIST_EMPLOYEE_IX                     7         10
HR     JHIST_EMP_ID_ST_DATE_PK              10         10
HR     JHIST_JOB_IX                          8         10
HR     JOB_ID_PK                            19         19
HR     LOC_CITY_IX                          23         23
HR     LOC_COUNTRY_IX                       14         23
HR     LOC_ID_PK                            23         23
HR     LOC_STATE_PROVINCE_IX                17         17
HR     REG_ID_PK                             4          4
OE     CUSTOMERS_PK                        319        319
OE     CUST_ACCOUNT_MANAGER_IX               4        319
OE     CUST_EMAIL_IX                       319        319
OE     CUST_LNAME_IX                       176        319
OE     CUST_UPPER_NAME_IX                  319        319
OE     INVENTORY_IX                       1112       1112
OE     INV_PRODUCT_IX                      208       1112
OE     ITEM_ORDER_IX                       105        665
OE     ITEM_PRODUCT_IX                     185        665
OE     ORDER_ITEMS_PK                      665        665
OE     ORDER_ITEMS_UK                      665        665
OE     ORDER_PK                            105        105
OE     ORD_CUSTOMER_IX                      47        105
OE     ORD_ORDER_DATE_IX                   105        105
OE     ORD_SALES_REP_IX                      9         70
OE     PRD_DESC_PK                        8640       8640
OE     PRODUCT_INFORMATION_PK              288        288
OE     PROD_NAME_IX                       3727       8640
OE     PROD_SUPPLIER_IX                     62        288
OE     PROMO_ID_PK                           2          2
OE     REFERENCE_IS_UNIQUE                 138        138
OE     WAREHOUSES_PK                         9          9
OE     WHS_LOCATION_IX                       9          9
PM     ONLINEMEDIA_PK                        9          9
PM     PRINTMEDIA_PK                         4          4
SH     CHANNELS_PK                           5          5
SH     COSTS_PROD_BIX                        0          0
SH     COSTS_TIME_BIX                        0          0
SH     COUNTRIES_PK                         23         23
SH     CUSTOMERS_GENDER_BIX                  2          5
SH     CUSTOMERS_MARITAL_BIX                11         18
SH     CUSTOMERS_PK                      55500      55500
SH     CUSTOMERS_YOB_BIX                    75         75
SH     DR$SUP_TEXT_IDX$X
SH     FW_PSC_S_MV_CHAN_BIX                  4          4
SH     FW_PSC_S_MV_PROMO_BIX                 4          4
SH     FW_PSC_S_MV_SUBCAT_BIX               21         21
SH     FW_PSC_S_MV_WD_BIX                  210        210
SH     PRODUCTS_PK                          72         72
SH     PRODUCTS_PROD_CAT_IX                  5         72
SH     PRODUCTS_PROD_STATUS_BIX              1          1
SH     PRODUCTS_PROD_SUBCAT_IX              21         72
SH     PROMO_PK                            503        503
SH     SALES_CHANNEL_BIX                     4         92
SH     SALES_CUST_BIX                     7059      35808
SH     SALES_PROD_BIX                       72       1074
SH     SALES_PROMO_BIX                       4         54
SH     SALES_TIME_BIX                     1460       1460
SH     SUP_TEXT_IDX
SH     TIMES_PK                           1826       1826

69 rows selected.



Copyright (c) 1998-2017 Jeffrey M. Hunter. All rights reserved.

All articles, scripts and material located at the Internet address of http://www.idevelopment.info is the copyright of Jeffrey M. Hunter and is protected under copyright laws of the United States. This document may not be hosted on any other site without my express, prior, written permission. Application to host any of the material elsewhere can be made by contacting me at jhunter@idevelopment.info.

I have made every effort and taken great care in making sure that the material included on my web site is technically accurate, but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on it. I will in no case be liable for any monetary damages arising from such loss, damage or destruction.

Last modified on
Thursday, 18-Nov-2010 18:14:30 EST
Page Count: 72930