Shulou(Shulou.com)06/01 Report--

Oracle 11g provides a sample schema for the data warehouse, and you can download the sample installation file at the link 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 extract it.

[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

Run global_11g_install.sql using sqlplus

[oracle@localhost] $lsglobal_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 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. . 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 and sets a password for global when prompted.

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.