您好,登錄后才能下訂單哦!
Oracle 11g 提供了數(shù)據(jù)倉(cāng)庫(kù)的示例schema,可以通過(guò)如下鏈接下載示例安裝文件。
http://www.oracle.com/technology/products/bi/olap/doc_sample_schemas/global_11g_schema.zip
將下載的文件上傳至Oracle服務(wù)器,并解壓。
[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 運(yùn)行g(shù)lobal_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>
腳本會(huì)創(chuàng)建一個(gè)global用戶,根據(jù)提示為global設(shè)置一個(gè)密碼。
輸入數(shù)據(jù)庫(kù)的system用戶密碼,用來(lái)登錄數(shù)據(jù)庫(kù)以建立global用戶。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。