将下载的文件上传至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用户。
亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。