Oracle数据库11g新特性:数据仓库和OLAP
2008-12-16 13:01:34 来源:WEB开发网SQL> @global_11g_install
Enter the password for the user GLOBAL:
Enter the password for the user SYSTEM:
Connected.
User created.
Grant succeeded.
Connected.
Import: Release 11.1.0.6.0 - Production on Sat Jun 28 17:08:22 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Export file created by EXPORT:V11.01.00 via conventional path
import done in US7ASCII 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> exit
- ››oracle 中 UPDATE nowait 的使用方法
- ››Oracle ORA-12560解决方法
- ››Oracle 10g RAC 常用维护命令
- ››Oracle如何在ASM中定位文件的分布
- ››Oracle的DBMS_RANDOM.STRING 的用法
- ››oracle 外部表导入时间日期类型数据,多字段导入
- ››Oracle中查找重复记录
- ››oracle修改用户登录密码
- ››Oracle创建删除用户、角色、表空间、导入导出等命...
- ››Oracle中登陆时报ORA-28000: the account is lock...
- ››Oracle数据库在配置文件中更改最大连接数
- ››Oracle中在pl/sql developer修改表的两种方式
更多精彩
赞助商链接