Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- set two_task=pdb01
- PDB01 =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = vm21)(PORT = 1521))
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = pdb01)
- )
- )
- connect sys/password@pdb01 as sysdba
- @?/demo/schema/human_resources/hr_main.sql
- specify password for HR as parameter 1:
- Enter value for 1: xxxx
- specify default tablespace 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: xxxx (same as the password of SYS)
- specify log path as parameter 5:
- Enter value for 5: D:appOracleHomeUserproduct12.1.0dbhome_1demoschemalog
- Connected.
- GRANT execute ON sys.dbms_stats TO hr
- *
- ERROR at line 1:
- ORA-01917: user or role 'HR' does not exist
- ERROR:
- ORA-01017: invalid username/password; logon denied
- Warning: You are no longer connected to ORACLE.
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Creating REGIONS table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Creating COUNTRIES table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Creating LOCATIONS table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Creating DEPARTMENTS table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Creating JOBS table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Creating EMPLOYEES table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Creating JOB_HISTORY table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Creating EMP_DETAILS_VIEW view ...
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Populating REGIONS table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Populating COUNTIRES table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Populating LOCATIONS table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Populating DEPARTMENTS table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Populating JOBS table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Populating EMPLOYEES table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- ****** Populating JOB_HISTORY table ....
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0640: Not connected
- SP2-0641: "EXECUTE" requires connection to server
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement