Sample schema is very important especially at your learning phase as it gives you access to an already creates schema's which are having objects with some sample data for your use.
With these sample schemas, you already have some data existing in your database to play with.
How to Install Sample Schemas?
- Either you can have them configured at the time of database installation.
- OR you can skip at the time of installation and later can manually create them using the scripts provided by Oracle. In the article, we are going to discuss the manual approach.
Let's begin.
1) Download the Sample Schema files from Oracle Git repository.
https://github.com/oracle-samples/db-sample-schemas/releases
You can download the sample schema based on Oracle version that you are using. For this article, I have download sample schema for Oracle 19c since it's the version I am using currently.
2) Copy the zip to any directory you want considering Oracle user has R/W privileges there. I have copied the zip file to '/home/oracle' directory. And unzip.
[root@oravm19c oracle]# su - oracle [oracle@oravm19c ~]$ ls db-sample-schemas-19c.zip [oracle@oravm19c ~]$ unzip db-sample-schemas-19c.zip
3) The following Perl command will replace "__SUB__CWD__" tag in some of the scripts with your current working directory. If you are using an alternate working directory, 'cd' to that directory before running the Perl command.
[oracle@oravm19c db-sample-schemas-19c]$ $ORACLE_HOME/perl/bin/perl -p -i.bak -e 's#__SUB__CWD__#'$(pwd)'#g' *.sql */*.sql */*.dat
4) Now we can proceed with installation. We'll be using SYSTEM schema to run the scripts.
Note: If using multitenant architecture, you must run the scripts in PDB. Since it's applicable to my case, so I'll be running scripts in my pluggable database PDB2 residing in CDB1 container.
[oracle@oravm19c db-sample-schemas-19c]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jan 18 04:39:31 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
5 PDB2 READ WRITE NO
5) Installing Schemas: All the schemas would be installed in one go, you just need to call "mksample.sql" from your CDB instance. In the prompt options, you need to provide CONNECT_STRING where you'll need to provide details to connect to PDB. Also it will ask for credentials to SYSTEM, SYS and different sample schemas that will be created with script. Adding to this, it will ask for default tablespace to hold schema data and temporary tablespace for these schemas.
Confirm if you are on right path.
SQL> !ls bus_intelligence drop_sch.sql info_exchange mk_dir.sql mksample.sql mkverify.sql product_media README.txt shipping CONTRIBUTING.md human_resources LICENSE.md mkplug.sql mkunplug.sql order_entry README.md sales_history
6) Verify the connectivity to PDB instance using CONNECT_STRING.
SQL> connect system/CdbP$#wd1@oravm19c.practice.com:1521/pdb2.practice.com Connected.
7) You are ready to run the script now. Ensure you are connected to CDB instance, if yes, call 'mksample.sql' script and provide details when prompted.
SQL> @mksample.sql specify password for SYSTEM as parameter 1: Enter value for 1: CdbP$#wd1 specify password for SYS as parameter 2: Enter value for 2: CdbP$#wd1 specify password for HR as parameter 3: Enter value for 3: hrpwd specify password for OE as parameter 4: Enter value for 4: oepwd specify password for PM as parameter 5: Enter value for 5: pmpwd specify password for IX as parameter 6: Enter value for 6: ixpwd specify password for SH as parameter 7: Enter value for 7: shpwd specify password for BI as parameter 8: Enter value for 8: bipwd specify default tablespace as parameter 9: Enter value for 9: users specify temporary tablespace as parameter 10: Enter value for 10: temp specify log file directory (including trailing delimiter) as parameter 11: Enter value for 11: /home/oracle/samplelog specify connect string as parameter 12: Enter value for 12: oravm19c.practice.com:1521/pdb2.practice.com Sample Schemas are being created ...
Entire log can be too much overwhelming, so I'll just paste the part showing created schemas with objects list.
All named objects and statistics 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 INDEX AQ$_STREAMS_QUEUE_TABLE_Y 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_L VALID IX TABLE AQ$_ORDERS_QUEUETABLE_S VALID IX TABLE AQ$_ORDERS_QUEUETABLE_T VALID IX TABLE AQ$_STREAMS_QUEUE_TABLE_C 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_L 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 IX VIEW AQ$_ORDERS_QUEUETABLE_F VALID IX VIEW AQ$_STREAMS_QUEUE_TABLE_F VALID OE FUNCTION GET_PHONE_NUMBER_F VALID OE INDEX ACTION_TABLE_MEMBERS 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 LINEITEM_TABLE_MEMBERS 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 WAREHOUSES_PK VALID OE INDEX WHS_LOCATION_IX VALID OE LOB EXTRADATA46_L VALID OE LOB NAMESPACES47_L 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 ACTION_TABLE VALID OE TABLE CATEGORIES_TAB VALID OE TABLE CUSTOMERS VALID OE TABLE INVENTORIES VALID OE TABLE LINEITEM_TABLE 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 PURCHASEORDER 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 PURCHASEORDER$xd VALID OE TYPE ACTIONS_T VALID OE TYPE ACTION_T VALID OE TYPE ACTION_V 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 LINEITEMS_T VALID OE TYPE LINEITEM_T VALID OE TYPE LINEITEM_V 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 PART_T VALID OE TYPE PHONE_LIST_TYP VALID OE TYPE PRODUCT_INFORMATION_TYP VALID OE TYPE PRODUCT_REF_LIST_TYP VALID OE TYPE PURCHASEORDER_T VALID OE TYPE REJECTION_T VALID OE TYPE SHIPPING_INSTRUCTIONS_T 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 ACCOUNT_MANAGERS VALID OE VIEW BOMBAY_INVENTORY VALID OE VIEW CUSTOMERS_VIEW 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 PRINTMEDIA_PK 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$KD VALID SH INDEX DR$SUP_TEXT_IDX$KR 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$U VALID SH TABLE FWEEK_PSCAT_SALES_MV 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 488 rows selected.
I hope this helps !!
No comments:
Post a Comment