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关系图