hr_main. The former part of the SQL (behind the create table) as follows:
Rem
Rem Header: hr_main. SQL 09 - jan - 01
Rem
Rem Copyright (c) 2001, Oracle Corporation. All rights reserved.
Rem
Rem Owner: ahunold
Rem
Rem NAME
Rem hr_main. - the Main SQL script for the HR schema
Rem
Rem DESCRIPTON
Rem HR (Human Resources) is the smallest and most simple one
Rem of the Sample Schemas
Rem
Rem NOTES
Rem Run as SYS or SYSTEM
Rem
Rem MODIFIED (MM/DD/YY)
Rem ahunold 07/13/01 - NLS Territory
Rem ahunold 04/13/01 - parameter 5, notes, spool
Rem ahunold 03/29/01 - spool
Rem ahunold 03/12/01 - prompts
Rem ahunold 03/07/01 - hr_analz. SQL
Rem ahunold 03/03/01 - HR simplification, REGIONS table
Rem ngreenbe 06/01/00 - created
SET the ECHO OFF
REM PROMPT
REM PROMPT specify the password for HR as the parameter 1:
REM DEFINE pass=& amp; 1
REM PROMPT
REM PROMPT specify default tablespeace for HR as the parameter 2:
REM DEFINE TBS=& amp; 2
REM PROMPT
REM PROMPT specify temporary in tablespace for HR as the parameter 3:
REM DEFINE TTBS=& amp; 3
REM PROMPT
REM PROMPT specify the password for SYS as parameter 4:
REM DEFINE pass_sys=& amp; 4
REM PROMPT
REM PROMPT specify the log path as the parameter 5:
REM DEFINE log_path=& amp; 5
REM PROMPT
- The first dot in The spool command below is
- the SQL * Plus concatenation character
REM DEFINE spool_file=c: \ oracle \ hr_main log
SPOOL c: \ oracle \ hr_spool
REM=======================================================
REM cleanup section
REM=======================================================
DROP the USER hr CASCADE;
REM=======================================================
REM the create user
REM three separate commands, so the create user command
REM will succeed they chopped of the existence of the
REM DEMO and TEMP tablespaces
REM=======================================================
The CREATE USER hr IDENTIFIED BY hr;
The ALTER USER hr DEFAULT in TABLESPACE users
QUOTA UNLIMITED ON the users;
The ALTER USER hr TEMPORARY in TABLESPACE temp;
GRANT create session
Create table,
To create procedure
, the create sequence
To create the trigger
To create the view
To create synonym
To alter the session
TO hr.
REM=======================================================
REM grants from sys schema
REM=======================================================
The CONNECT/AS SYSDBA;
GRANT execute ON sys. Dbms_stats TO hr;
REM=======================================================
REM create the hr schema objects
REM=======================================================
CONNECT the hr/hr
ALTER SESSION SET NLS_LANGUAGE=American;
ALTER SESSION SET NLS_TERRITORY=America;
CodePudding user response:
The c: \ oracle this directory permissions, distributed to EveryOneCodePudding user response:
C: \ apps \? Then in the resource manager point right?