手工安装hr表+oracle,[20200825]手工安装HR schema.txt

[20200825]手工安装HR schema.txt

--//我的测试环境没有HR schma,有时候测试需要,需要使用它.不知道为什么我安装没有把它选上.好像现在已经无法选上.

--//手工安装看看.

1.环境:

SYS@test01p> @ ver1

PORT_STRING                    VERSION        BANNER                                                                               CON_ID

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

IBMPC/WIN_NT64-9.1.0           12.2.0.1.0     Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0

2.安装HR;

d:\tmp> sqlplus sys/xxxx@test01p as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Aug 25 20:47:48 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SYS@test01p> @?/demo/schema/human_resources/hr_main.sql

specify password for HR as parameter 1:

Enter value for 1: btbtms

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 log path as parameter 4:

Enter value for 4: d:\tmp

....

3.检查:

HR@test01p> select * from tab ;

TNAME                TABTYPE  CLUSTERID

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

COUNTRIES            TABLE

DEPARTMENTS          TABLE

EMPLOYEES            TABLE

EMP_DETAILS_VIEW     VIEW

JOBS                 TABLE

JOB_HISTORY          TABLE

LOCATIONS            TABLE

REGIONS              TABLE

8 rows selected.

HR@test01p> select * from jobs;

JOB_ID     JOB_TITLE                           MIN_SALARY MAX_SALARY

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

AD_PRES    President                                20080      40000

AD_VP      Administration Vice President            15000      30000

AD_ASST    Administration Assistant                  3000       6000

FI_MGR     Finance Manager                           8200      16000

FI_ACCOUNT Accountant                                4200       9000

AC_MGR     Accounting Manager                        8200      16000

AC_ACCOUNT Public Accountant                         4200       9000

SA_MAN     Sales Manager                            10000      20080

SA_REP     Sales Representative                      6000      12008

PU_MAN     Purchasing Manager                        8000      15000

PU_CLERK   Purchasing Clerk                          2500       5500

ST_MAN     Stock Manager                             5500       8500

ST_CLERK   Stock Clerk                               2008       5000

SH_CLERK   Shipping Clerk                            2500       5500

IT_PROG    Programmer                                4000      10000

MK_MAN     Marketing Manager                         9000      15000

MK_REP     Marketing Representative                  4000       9000

HR_REP     Human Resources Representative            4000       9000

PR_REP     Public Relations Representative           4500      10500

19 rows selected.

--//做一个记录!!