Oracle Learning Data Warehouse (i) Import Oracle 11g Global samples schema

Oracle 11g provides a sample schema for the Data Warehouse, and you can download the sample installation files by following the links below.

Http://www.oracle.com/technology/products/bi/olap/doc_sample_schemas/global_11g_schema.zip

Upload the downloaded file to the Oracle server and unzip it.

[[email protected] ~]$ mkdir global_11g_schema     [[email  protected] ~]$ 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

Run Global_11g_install.sql with Sqlplus

[[email protected] ~]$ lsglobal_11g_install.sql  global_11g_readme.html   Global_11g_remove.sql  global_11g_source.dmp  templates[[email protected] 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 2015copyright  (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 2015copyright  (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 productionwith  the partitioning, olap, data mining and real application testing  optionsExport file created by EXPORT:V11.01.00 via conventional  pathimport done in al32utf8 character set and al16utf16 nchar  character setimport 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.&nbsP;.  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 importedabout to enable constraints ... Import terminated successfully without warnings. Sql>

The script creates a global user with the prompt to set a password for global.

Enter the system user password for the database to log in to the database to establish a global user.

This article is from the "Ding Dong" blog, please be sure to keep this source http://lqding.blog.51cto.com/9123978/1694384

Oracle Learning Data Warehouse (i) Import Oracle 11g Global samples schema