Oracle 學習之數據倉庫（一）導入Oracle 11g Global samples schema

Oracle 學習之數據倉庫（一）導入Oracle 11g Global samples schema

Oracle 11g 提供了數據倉庫的示例schema，可以通過如下鏈接下載示例安裝文件。 http://www.oracle.com/technology/products/bi/olap/doc_sample_schemas/global_11g_schema.zip   將下載的文件上傳至Oracle服務器，並解壓。

[oracle@localhost ~]$ mkdir global_11g_schema     
[oracle@localhost ~]$ unzip -d global_11g_schema global_11g_schema.zip 
Archive:  global_11g_schema.zip
  inflating: global_11g_schema/global_11g_remove.sql  
  inflating: global_11g_schema/global_11g_source.dmp  
  inflating: global_11g_schema/Templates/CHANNEL.XML  
  inflating: global_11g_schema/Templates/CUSTOMER.XML  
  inflating: global_11g_schema/Templates/GLOBAL.XML  
  inflating: global_11g_schema/Templates/GLOBAL_MV.XML  
  inflating: global_11g_schema/Templates/PRICE_CUBE.XML  
  inflating: global_11g_schema/Templates/PRODUCT.XML  
  inflating: global_11g_schema/Templates/TIME.XML  
  inflating: global_11g_schema/Templates/UNITS_CUBE.XML  
  inflating: global_11g_schema/global_11g_install.sql  
  inflating: global_11g_schema/global_11g_readme.html

 

使用sqlplus 運行global_11g_install.sql

[oracle@localhost ~]$ ls
global_11g_install.sql  global_11g_readme.html  global_11g_remove.sql  global_11g_source.dmp  Templates
[oracle@localhost global_11g_schema]$ sqlplus /nolog @global_11g_install.sql 

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 10 09:44:17 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Enter the password for the user GLOBAL: 
Enter the password for the user SYSTEM: 
Connected.

User created.


Grant succeeded.

Connected.

Import: Release 11.2.0.4.0 - Production on Thu Sep 10 09:44:26 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V11.01.00 via conventional path
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing GLOBAL's objects into GLOBAL
. . importing table                      "ACCOUNT"         24 rows imported
. . importing table                  "CHANNEL_DIM"          3 rows imported
. . importing table                 "CUSTOMER_DIM"         61 rows imported
. . importing table                   "PRICE_FACT"       2523 rows imported
. . importing table         "PRODUCT_CHILD_PARENT"         48 rows imported
. . importing table                  "PRODUCT_DIM"         36 rows imported
. . importing table                     "TIME_DIM"        120 rows imported
. . importing table                   "UNITS_FACT"     299446 rows imported
About to enable constraints...
Import terminated successfully without warnings.

SQL>

 

  腳本會創建一個global用戶，根據提示為global設置一個密碼。   輸入數據庫的system用戶密碼，用來登錄數據庫以建立global用戶。