oracle10g设置hr,oracle 10g 创建HR用户步骤

1.下载相关脚本 ：点击打开链接

2.上传到：$ORACLE_HOME/demo/schema/human_resources  目录下

3.切换到脚本目录下执行脚本 ：@hr_main.sql

specify password for HR as parameter 1:

Enter value for 1: hr

specify default tablespeace for HR as parameter 2:

Enter value for 2: users

specify temporary tablespace for HR as parameter 3:

Enter value for 3: temp

specify password for SYS as parameter 4:

Enter value for 4: test

specify log path as parameter 5:

Enter value for 5: /u01/oracle/rdbms/log

4.查询执行结果：

SQL> select table_name from user_tables;

TABLE_NAME

------------------------------

REGIONS

LOCATIONS

DEPARTMENTS

JOBS

EMPLOYEES

JOB_HISTORY

COUNTRIES

7 rows selected.

练习SQL 的HR Schema关系图