Create hr users and tables

By default, hr users and tables are not created. You can create a table by using dbca or script.

Now I create hr users and tables in script Mode

1. Obtain the hr user script from the Internet

2. Add the script to the $ Oracle_HOME/demo/schema/human_resources directory.

Hr_anz. SQL hr_comnt. SQL hr_dn_c. SQL hr_drop. SQL hr_main. SQL
Hr_code. SQL hr_cre. SQL hr_dn_d. SQL hr_idx. SQL hr_popul. SQL

Put the preceding script in the $ ORACLE_HOME/demo/schema/human_resources directory.

1. Cd $ ORACLE_HOME/demo/Schema/Human_resources
2. [Root @ IM-8-201 human_resources] # sqlplus sys/sysAsSysdba @ hr_main. SQL
4. SQL * Plus: Release 10.2.0.4.0-ProductionOnTue Nov 15 21:40:44 2011
6. Copyright (c) 1982,200 7, Oracle.AllRights Reserved.
9. ConnectedTo:
10. OracleDatabase10g Enterprise Edition Release 10.2.0.4.0-64bit Production
11. WithThe Partitioning, OLAP, Data MiningAnd RealApplication Testing options
14. SpecifyPassword ForHRAsParameter 1:
15. Enter valueFor1: hr
17. SpecifyDefaultTablespeaceForHRAsParameter 2:
18. Enter valueFor2:User
20. SpecifyTemporaryTablespaceForHRAsParameter 3:
21. Enter valueFor3:Temp
23. SpecifyPassword ForSYSAsParameter 4:
24. Enter valueFor4: sys
25. Specify log pathAsParameter 5:
26. Enter valueFor5:/home/oracle
27. ..............................
28. PL/SQLProcedureSuccessfully completed.
31. PL/SQLProcedureSuccessfully completed.
33. SQL>

3. Verification

1. SQL>SelectTable_nameFromUser_tables;
3. TABLE_NAME
4. ------------------------------
5. REGIONS
6. LOCATIONS
7. Administrative ments
8. JOBS
9. EMPLOYEES
10. JOB_HISTORY
11. COUNTRIES
13. 7RowsSelected.