首页 > 代码库 > Oracle 11g 的5个常用示例SCHEMA

Oracle 11g 的5个常用示例SCHEMA

 

  HR(Human Resources,人力资源) SCHEMA
   COUNTRIES                      TABLE  
   DEPARTMENTS                  TABLE  
   EMPLOYEES                      TABLE  
   EMP_DETAILS_VIEW          VIEW   
   JOBS                                TABLE  
   JOB_HISTORY                   TABLE  
   LOCATIONS                      TABLE  
   REGIONS                         TABLE

 

  BI(Business Intelligence,商务智能) SCHEMA
   CHANNELS                       SYNONYM
   COSTS                             SYNONYM
   COUNTRIES                      SYNONYM
   CUSTOMERS                     SYNONYM
   PRODUCTS                       SYNONYM
   PROMOTIONS                   SYNONYM
   SALES                             SYNONYM
   TIMES                             SYNONYM

 

  PM(Product Media,产品媒体) SCHEMA
   ONLINE_MEDIA                        TABLE  
   PRINT_MEDIA                           TABLE  
   TEXTDOCS_NESTEDTAB             TABLE

 

  OE(Order Entry,订单录入) SCHEMA

   ACCOUNT_MANAGERS               VIEW   
   ACTION_TABLE                         TABLE  
   BOMBAY_INVENTORY                VIEW   
   CATEGORIES_TAB                    TABLE  
   COUNTRIES                             SYNONYM
   CUSTOMERS                           TABLE  
   CUSTOMERS_VIEW                 VIEW   
   DEPARTMENTS                       SYNONYM
   EMPLOYEES                           SYNONYM
   INVENTORIES                        TABLE

  JOBS                                     SYNONYM
   JOB_HISTORY                       SYNONYM
   LARGE_ORDERS                   TABLE  
   LARGE_ORDERS1                  TABLE  
   LINEITEM_TABLE                  TABLE  
   LOCATIONS                          SYNONYM
   MEDIUM_ORDERS                  TABLE  
   MEDIUM_ORDERS1                 TABLE  
   OC_CORPORATE_CUSTOMERS         VIEW   
   OC_CUSTOMERS                   VIEW   
   OC_INVENTORIES                 VIEW   
   OC_ORDERS                        VIEW   
   OC_PRODUCT_INFORMATION         VIEW   
   ORDERS                             TABLE  
   ORDERS_VIEW                    VIEW   
   ORDER_ITEMS                    TABLE  
   PRODUCTS                         VIEW   
   PRODUCT_DESCRIPTIONS           TABLE 

  PRODUCT_INFORMATION            TABLE  
   PRODUCT_PRICES                     VIEW   
   PRODUCT_REF_LIST_NESTEDTAB     TABLE  
   PROMOTIONS                        TABLE  
   PURCHASEORDER                  TABLE  
   SMALL_ORDERS                   TABLE  
   SMALL_ORDERS1                  TABLE  
   SPECIAL_ORDERS                 TABLE  
   SPECIAL_ORDERS1                TABLE  
   SUBCATEGORY_REF_LIST_NESTEDTAB   TABLE  
   SYDNEY_INVENTORY               VIEW   
   TORONTO_INVENTORY              VIEW   
   WAREHOUSES                        TABLE

 

   SH(Sales History,销售历史) SCHEMA
   CAL_MONTH_SALES_MV             TABLE  
   CHANNELS                         TABLE  
   COSTS                            TABLE  
   COUNTRIES                        TABLE  
   CUSTOMERS                        TABLE  
   DIMENSION_EXCEPTIONS           TABLE  
   DR$SUP_TEXT_IDX$I              TABLE  
   DR$SUP_TEXT_IDX$K              TABLE  
   DR$SUP_TEXT_IDX$N              TABLE  
   DR$SUP_TEXT_IDX$R              TABLE  
   FWEEK_PSCAT_SALES_MV           TABLE  
   PRODUCTS                         TABLE  
   PROFITS                          VIEW   
   PROMOTIONS                     TABLE  
   SALES                            TABLE  
   SALES_TRANSACTIONS_EXT         TABLE  
   SUPPLEMENTARY_DEMOGRAPHICS     TABLE  
   TIMES                            TABLE

 

Oracle 11g 的5个常用示例SCHEMA