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用户。
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。