通过dbca建库如果选择的是 定制创建数据库 这个模板 示例方案还没法选上,建库之后又不知道如何添加进来,如果选择一般用途或者数据仓库模板建库,hr schema是进来了,但是其他schema也进来一堆,所以没法区分,下面简单介绍一下如何手动添加hrschema吧,不过从doc的描述来看hr shcema应该就是 示例方案:
About Sample Schema HR
The HR
schema is a sample schema that can be installed as part of Oracle Database. This schema contains information about employees—their departments, locations, work histories, and related information. Like all schemas, the HR
schema has tables, views, indexes, procedures, functions, and other attributes of a database schema.
The examples and tutorials in this document use the HR
schema.
See Also:
Oracle Database Sample Schemas for a complete description of the
HR
schema
这个网上有现成的,别人总结的,我拿过来引用一下,防止连接过期,拷贝出来一份:
http://blog.csdn.net/ecjtuxuan/article/details/6365294
先将附件上的 10 个 .sql 文件放入这个路径中 :
E:/oracle/product/10.1.0/db_1/demo/schema/human_resources
Script Name | Description |
hr_analz.sql | Collects statistics on the tables in the schema. |
hr_code.sql | Creates procedural objects in the schema. |
hr_comnt.sql | Creates comments for each object in the schema. |
hr_cre.sql | Creates the HR objects. |
hr_dn_c.sql | Adds the distinguished name column used by Oracle Internet Directory to the employees and departments tables. |
hr_dn_d.sql | Drops the Oracle Internet Directory distinguished name column from employees and departments . |
hr_drop.sql | Drops the HR schema and all its objects. |
hr_idx.sql | Creates indexes on the HR tables. |
hr_main.sql | Main script for the HR schema; calls other scripts. |
hr_popul.sql | Populates the objects. |
然后在 SQL*PLUS 上执行 hr_main.sq 这个文件。
a) SQL>@e:/oracle/product/10.1.0/db_1/demo/schema/human_resources/hr_main.sq
b) Specify password for HR as parameter 1:
c) Enter value for 1: hr
d) Specify default tablespeace for HR as parameter 2:
e) Enter value for 2: users
f) Specify temporary tablespace for HR as parameter 3:
g) Enter value for 3: temp
h) Specify password for SYS as parameter 4:
i) Enter value for 4: welcome1
j) Specify log path as parameter 5:
k) Enter value for 5: C:/oracle/product/10.1.0/db_1/RDBMS/log
可以通过此命令来查看 HR 用户是否已经建立成功。
desc dba_users;
Select username, account_status from dba_users;
备注:关于 这个样例数据库用户的 script 文件在我的资源下载中有,名字是Oracle HR Schema
可以去下载 然后 里面有附有说明文档。
下载地址:
http://download.csdn.net/source/3228255
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1060529/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19602/viewspace-1060529/