While imprting iam facing this errot

Import: Release 12.2.0.1.0 – Production on Thu Mar 14 10:08:43 2019

 

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

 

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production

 

Warning: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.

 

Master table “SYSTEM”.”SYS_IMPORT_SCHEMA_01″ successfully loaded/unloaded

import done in AL32UTF8 character set and AL16UTF16 NCHAR character set

export done in US7ASCII character set and AL16UTF16 NCHAR character set

Starting “SYSTEM”.”SYS_IMPORT_SCHEMA_01″:  system/********@localhost:1521/orcl.ucsf.edu DIRECTORY=hitachi dumpfile=HITACHI.DMP schemas=hitachi logfile=HITACHIFULL.log remap_schema=HITACHI:HITACHIFULL REMAP_TABLESPACE=SFEDB1:USERS,SFEDB1IX:USERS,SFIID1:USERS,SFCTL1:USERS,SFUSER:USERS,SFIID1IX:USERS,SFCTL1IX:USERS

Processing object type SCHEMA_EXPORT/USER

ORA-39083: Object type USER:”HITACHIFULL” failed to create with error:

ORA-65096: invalid common user or role name

 

Failing sql is:

CREATE USER “HITACHIFULL” IDENTIFIED BY VALUES ‘S:C6F40BA111E9201EF01FAD270CC3C95BE11D1787D5802314000C4DC98320;T:C3CEA0080EB4D62D14CEF88E9DC41786DB8E244159F4A48AB20E19E80355202D9BAFBF463640192C01B3168D0BF534F612F737C33F74C877EB0AFD4E1E0DC82887BCDC1E3D3B287CA2B9A5D9238352A5;A80965D728BE2C4A’ DEFAULT TABLESPACE “USERS” TEMPORARY TABLESPACE “PSTEMP”

 

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

ORA-39083: Object type ROLE_GRANT failed to create with error:

ORA-01919: role ‘EDB_ROLE’ does not exist

 

Failing sql is:

GRANT “EDB_ROLE” TO “HITACHIFULL”

 

ORA-39083: Object type ROLE_GRANT failed to create with error:

ORA-01919: role ‘FIN_ROLE’ does not exist

 

Failing sql is:

GRANT “FIN_ROLE” TO “HITACHIFULL”

 

ORA-39083: Object type ROLE_GRANT failed to create with error:

ORA-01919: role ‘UCPATH_ROLE’ does not exist

 

Failing sql is:

GRANT “UCPATH_ROLE” TO “HITACHIFULL”

 

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM

Processing object type SCHEMA_EXPORT/TABLE/TABLE

ORA-39083: Object type TABLE:”HITACHIFULL”.”SF0IDB” failed to create with error:

ORA-28365: wallet is not open

 

Failing sql is:

CREATE TABLE “HITACHIFULL”.”SF0IDB” (“IDB_INDIVIDUAL_ID” VARCHAR2(9 BYTE) NOT NULL ENABLE, “IDB_SSN” VARCHAR2(9 BYTE) ENCRYPT USING ‘AES192’ ‘SHA-1’ NO SALT  NOT NULL ENABLE, “IDB_BIRTHDATE” DATE NOT NULL ENABLE, “IDB_BIRTH_CITY” VARCHAR2(30 BYTE) NOT NULL ENABLE, “IDB_BIRTH_STATE” VARCHAR2(2 BYTE) NOT NULL ENABLE, “IDB_BIRTH_CY” VARCHAR2(2 BYTE) NOT NULL ENABLE, “IDB_PASSPORT_ID” VARCHAR2(30 BYTE) NOT NULL ENABLE, “IDB_PASSPORT_CY” VARCHAR2(2 BYTE) NOT NULL ENABLE, “IDB_DL_ID” VARCHAR2(30 BYTE) NOT NULL ENABLE, “IDB_DL_ID_STATE” VARCHAR2(2 BYTE) NOT NULL ENABLE, “IDB_DL_ID_CY” VARCHAR2(2 BYTE) NOT NULL ENABLE, “IDB_TEMP_SSN” VARCHAR2(9 BYTE) ENCRYPT USING ‘AES192’ ‘SHA-1’ NO SALT  NOT NULL ENABLE, “IDB_CLOAKED_FLAG” VARCHAR2(1 BYTE) NOT NULL ENABLE, “IDB_STATUS” VARCHAR2(1 BYTE) NOT NULL ENABLE, “IDB_REFERRED_ID” VARCHAR2(9 BYTE) NOT NULL ENABLE, “IDB_ASSIGNED_AT” DATE NOT NULL ENABLE, “IDB_MIN_INM_SOURCE” VARCHAR2(8 BYTE) NOT NULL ENABLE, “IDB_UUID” VARCHAR2(50 BYTE) NOT NULL ENABLE, “IDB_CHANGED_BY” VARCHAR2(8 BYTE) NOT NULL ENABLE, “IDB_CHANGED_AT” DATE NOT NULL ENABLE) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 5242880 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 MAXSIZE UNLIMITED BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE “USERS”

 

ORA-39083: Object type TABLE:”HITACHIFULL”.”RFSTBPER” failed to create with error:

ORA-28365: wallet is not open

 

Failing sql is:

CREATE TABLE “HITACHIFULL”.”RFSTBPER” (“UCSFID” VARCHAR2(9 BYTE) NOT NULL ENABLE, “SSN” VARCHAR2(9 BYTE) ENCRYPT USING ‘AES192’ ‘SHA-1’ NO SALT  NOT NULL ENABLE, “NAME” VARCHAR2(26 BYTE) NOT NULL ENABLE, “SUFFIX” VARCHAR2(4 BYTE) NOT NULL ENABLE, “SEX” VARCHAR2(1 BYTE) NOT NULL ENABLE, “ETHNIC” VARCHAR2(1 BYTE) NOT NULL ENABLE, “BIRTHDATE” DATE NOT NULL ENABLE, “CITCNTRY” VARCHAR2(2 BYTE) NOT NULL ENABLE, “VISA” VARCHAR2(2 BYTE) NOT NULL ENABLE, “UCSFDOCNUM” VARCHAR2(5 BYTE) NOT NULL ENABLE, “CALPHYSLIC” VARCHAR2(9 BYTE) NOT NULL ENABLE, “CALPHYSEXDT” DATE NOT NULL ENABLE, “ECFMGNUM” VARCHAR2(7 BYTE) NOT NULL ENABLE, “ECFMGDT” DATE NOT NULL ENABLE, “AOA” VARCHAR2(1 BYTE) NOT NULL ENABLE, “RELNAME” VARCHAR2(1 BYTE) NOT NULL ENABLE, “RELBIRTHDT” VARCHAR2(1 BYTE) NOT NULL ENABLE, “RELHADDR” VARCHAR2(1 BYTE) NOT NULL ENABLE, “RELHPHONE” VARCHAR2(1 BYTE) NOT NULL ENABLE, “RELLADDR” VARCHAR2(1 BYTE) NOT NULL ENABLE, “RELLPHONE” VARCHAR2(1 BYTE) NOT NULL ENABLE, “RELATTDTS” VARCHAR2(1 BYTE) NOT NULL ENABLE, “RELPCTTM” VARCHAR2(1 BYTE) NOT NULL ENABLE, “RELSPEC” VARCHAR2(1 BYTE) NOT NULL ENABLE, “RELDEGREE” VARCHAR2(1 BYTE) NOT NULL ENABLE, “RELTITLE” VARCHAR2(1 BYTE) NOT NULL ENABLE, “RELHOSP” VARCHAR2(1 BYTE) NOT NULL ENABLE, “RELLSTSCHL” VARCHAR2(1 BYTE) NOT NULL ENABLE, “HOSADD1” VARCHAR2(30 BYTE) NOT NULL ENABLE, “HOSADD2” VARCHAR2(30 BYTE) NOT NULL ENABLE, “HOSCITY” VARCHAR2(21 BYTE) NOT NULL ENABLE, “HOSSTATE” VARCHAR2(2 BYTE) NOT NULL ENABLE, “HOSZIP” VARCHAR2(9 BYTE) NOT NUL

 

ORA-39083: Object type TABLE:”HITACHIFULL”.”ACCLRUN” failed to create with error:

ORA-00959: tablespace ‘SFPCD1’ does not exist

 

Failing sql is:

CREATE TABLE “HITACHIFULL”.”ACCLRUN” (“PROGRAM_IDENTIFIER” VARCHAR2(8 BYTE) NOT NULL ENABLE, “RUN_NUM_DAY” NUMBER NOT NULL ENABLE, “RUN_NUM_WEEK” NUMBER NOT NULL ENABLE, “RUN_NUM_MONTH” NUMBER NOT NULL ENABLE, “RUN_NUM_YEAR” NUMBER NOT NULL ENABLE, “RUN_NUM_LIFE” NUMBER NOT NULL ENABLE, “LAST_RUN” DATE) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 MAXSIZE UNLIMITED BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE “SFPCD1″

 

ORA-39083: Object type TABLE:”HITACHIFULL”.”ACCESSCD_EXT” failed to create with error:

ORA-06564: object HITACHI_DIR does not exist

 

Failing sql is:

CREATE TABLE “HITACHIFULL”.”ACCESSCD_EXT” (“ACCESS_CODE” VARCHAR2(6 BYTE), “FILLER” VARCHAR2(1 BYTE), “ACCESS_NAME” VARCHAR2(80 BYTE)) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY “HITACHI_DIR” ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE

LOAD WHEN

(ACCESS_CODE != BLANKS) AND

(FILLER      != BLANKS)

BADFILE     ‘HITACHI_DIR’:’ACCESSCD_EXT.bad’

DISCARDFILE ‘HITACHI_DIR’:’ACCESSCD_EXT.dsc’

LOGFILE     ‘HITACHI_DIR’:’ACCESSCD_EXT.log’

FIELDS

(ACCESS_CODE   (1:6) CHAR(6),

FILLER        (7:7)   CHAR(1),

ACCESS_NAME   (8:87)  CHAR(80)

)    ) LOCATION ( ‘ACCESSCD’ ) )

 

ORA-39083: Object type TABLE:”HITACHIFULL”.”MAILBOX_EXT” failed to create with error:

ORA-06564: object HITACHI_DIR does not exist

 

Failing sql is:

CREATE TABLE “HITACHIFULL”.”MAILBOX_EXT” (“MAILBOX_CODE” VARCHAR2(4 BYTE), “DEPARTMENT_CODE” VARCHAR2(6 BYTE), “ADDRESSEE” VARCHAR2(30 BYTE), “ADDRESS” VARCHAR2(30 BYTE)) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY “HITACHI_DIR” ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE

LOAD WHEN

(MAILBOX_CODE         != BLANKS) AND

(DEPARTMENT_CODE      != BLANKS)

BADFILE     ‘HITACHI_DIR’:’MAILBOX_EXT.bad’

DISCARDFILE ‘HITACHI_DIR’:’MAILBOX_EXT.dsc’

LOGFILE     ‘HITACHI_DIR’:’MAILBOX_EXT.log’

FIELDS

(MAILBOX_CODE           (1:4)     CHAR(4),

DEPARTMENT_CODE        (5:10)    CHAR(6),

ADDRESSEE              (11:40)   CHAR(30),

ADDRESS                (41:70)   CHAR(30)

)    ) LOCATION ( ‘MAILBOX’ ) )

 

ORA-39083: Object type TABLE:”HITACHIFULL”.”BUILDING_EXT” failed to create with error:

ORA-06564: object HITACHI_DIR does not exist

 

Failing sql is:

CREATE TABLE “HITACHIFULL”.”BUILDING_EXT” (“BLD_ID” VARCHAR2(8 BYTE), “BLD_NAME” VARCHAR2(64 BYTE), “BLD_ADDRESS_1” VARCHAR2(50 BYTE), “BLD_ADDRESS_2” VARCHAR2(50 BYTE), “BLD_CITY_NAME” VARCHAR2(32 BYTE), “BLD_CITY_ID” VARCHAR2(4 BYTE), “BLD_STATE_NAME” VARCHAR2(32 BYTE), “BLD_ZIP” VARCHAR2(10 BYTE), “BLD_SITE_ID” VARCHAR2(16 BYTE), “BLD_SITE_NAME” VARCHAR2(32 BYTE), “FILLER” VARCHAR2(192 BYTE)) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY “HITACHI_DIR” ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE

LOAD WHEN

(BLD_ID         != BLANKS)

BADFILE     ‘HITACHI_DIR’:’BUILDING_EXT.bad’

DISCARDFILE ‘HITACHI_DIR’:’BUILDING_EXT.dsc’

LOGFILE     ‘HITACHI_DIR’:’BUILDING_EXT.log’

FIELDS

(BLD_ID                 (1:8)       CHAR(8),

BLD_NAME               (9:72)      CHAR(64),

BLD_ADDRESS_1          (73:122)    CHAR(50),

BLD_ADDRESS_2          (123:172)   CHAR(50),

BLD_CITY_NAME          (173:204)   CHAR(32),

BLD_CITY_ID            (205:208)   CHAR(4),

BLD_STATE_NAME         (209:240)   CHAR(32),

BLD_ZIP                (241:250)   CHAR(10),

BLD_SITE_ID            (251:266)   CHAR(16),

BLD_SITE_NAME          (267:298)   CHAR(32),

FILLER                 (299:490)   CHAR(192)

)    ) LOCATION ( ‘BUILDING’ ) )

 

ORA-39083: Object type TABLE:”HITACHIFULL”.”PPSEMP_EXT” failed to create with error:

ORA-06564: object HITACHI_DIR does not exist

 

Failing sql is:

CREATE TABLE “HITACHIFULL”.”PPSEMP_EXT” (“EMPLOYEE_ID” VARCHAR2(9 BYTE), “FIRST_NAME” VARCHAR2(30 BYTE), “MIDDLE_NAME” VARCHAR2(30 BYTE), “LAST_NAME” VARCHAR2(30 BYTE), “DATE_OF_BIRTH” DATE, “EMPLOYEE_STATUS” VARCHAR2(1 BYTE), “HOME_DEPT” VARCHAR2(6 BYTE), “PRIMARY_TITLE” VARCHAR2(6 BYTE), “HIRE_DATE” DATE, “SEPARATION_DATE” DATE, “APP_START_DATE” DATE, “APP_END_DATE” DATE) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY “HITACHI_DIR” ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE

LOAD WHEN

(EMPLOYEE_ID         != BLANKS)

BADFILE     ‘HITACHI_DIR’:’PPSEMP_EXT.bad’

DISCARDFILE ‘HITACHI_DIR’:’PPSEMP_EXT.dsc’

LOGFILE     ‘HITACHI_DIR’:’PPSEMP_EXT.log’

FIELDS

(EMPLOYEE_ID      (1:9)         CHAR(9),

FIRST_NAME       (10:39)       CHAR(30),

MIDDLE_NAME      (40:69)       CHAR(30),

LAST_NAME        (70:99)       CHAR(30),

DATE_OF_BIRTH    (100:109)     CHAR(10) DATE_FORMAT DATE MASK “MM/DD/YYYY”,

EMPLOYEE_STATUS  (110:110)     CHAR(1),

HOME_DEPT        (111:116)     CHAR(6),

PRIMARY_TITLE    (117:122)     CHAR(6),

HIRE_DATE        (123:132)     CHAR(10) DATE_FORMAT DATE MASK “MM/DD/YYYY”,

SEPARATION_DATE  (133:142)     CHAR(10) DATE_FORMAT DATE MASK “MM/DD/YYYY”,

APP_START_DATE   (143:152)     CHAR(10) DATE_FORMAT DATE MASK “MM/DD/YYYY”,

APP_END_DATE     (153:162)     CHAR(10) DATE_FORMAT DATE MASK “MM/DD/YYYY”

)    ) LOCATION ( ‘PPSEMP’ ) )

 

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

. . imported “HITACHIFULL”.”SF0ISA”                      45.19 MB  783526 rows

. . imported “HITACHIFULL”.”SF0INM”                      21.66 MB  320808 rows

. . imported “HITACHIFULL”.”PS_JOB_IDM”                  26.23 MB  212419 rows

. . imported “HITACHIFULL”.”CLSCLS”                      23.10 MB  157323 rows

. . imported “HITACHIFULL”.”SF0IXB”                      20.79 MB  448598 rows

. . imported “HITACHIFULL”.”SF0RC1″                      12.21 MB  135750 rows

. . imported “HITACHIFULL”.”SF0RC1_BKP_050319″           12.21 MB  135750 rows

. . imported “HITACHIFULL”.”SF0AFF”                      9.723 MB  146106 rows

. . imported “HITACHIFULL”.”CLSPHN”                      6.961 MB  117483 rows

. . imported “HITACHIFULL”.”SF0SIS”                      5.082 MB   29593 rows

. . imported “HITACHIFULL”.”RFSTBAPP”                    4.127 MB   47256 rows

. . imported “HITACHIFULL”.”PPSEMP_TEMP”                 3.448 MB   42093 rows

. . imported “HITACHIFULL”.”SF0EMP”                      3.019 MB   42093 rows

. . imported “HITACHIFULL”.”CLSDEG”                      1.522 MB   40854 rows

. . imported “HITACHIFULL”.”PS_JOBCODE_TBL”              579.3 KB    9180 rows

. . imported “HITACHIFULL”.”SF0TRV”                      571.0 KB    9765 rows

. . imported “HITACHIFULL”.”SF0TRV_29JAN”                576.5 KB    9805 rows

. . imported “HITACHIFULL”.”CLSUID”                      342.6 KB    7550 rows

. . imported “HITACHIFULL”.”PPPCTT”                      310.0 KB    8260 rows

. . imported “HITACHIFULL”.”SF0VND”                      139.3 KB    2575 rows

. . imported “HITACHIFULL”.”RFSTBPGM”                    118.0 KB     516 rows

. . imported “HITACHIFULL”.”SF0RC1_01FEBBKP”             70.11 KB     573 rows

. . imported “HITACHIFULL”.”CLSBOX”                      59.31 KB     627 rows

. . imported “HITACHIFULL”.”CLSBOX_23OCTDEV”             58.71 KB     627 rows

. . imported “HITACHIFULL”.”ACCESSCD_TEMP”               52.85 KB    1426 rows

. . imported “HITACHIFULL”.”MAILBOX_TEMP”                48.67 KB     627 rows

. . imported “HITACHIFULL”.”CLSBLD”                      38.05 KB     229 rows

. . imported “HITACHIFULL”.”CLSBLD_23OCTDEV”             37.69 KB     227 rows

. . imported “HITACHIFULL”.”CLSAST”                      34.46 KB     649 rows

. . imported “HITACHIFULL”.”BUILDING_TEMP”               26.01 KB     179 rows

. . imported “HITACHIFULL”.”CLSDGB”                      14.50 KB     193 rows

. . imported “HITACHIFULL”.”PPPFCT”                      14.07 KB     271 rows

. . imported “HITACHIFULL”.”RFSTBAPP_09FEB”              12.49 KB       2 rows

. . imported “HITACHIFULL”.”TEMP_DATE”                   5.078 KB       1 rows

. . imported “HITACHIFULL”.”BAHU_TEMP”                       0 KB       0 rows

. . imported “HITACHIFULL”.”EMPLOYEE_O2_ML_TMP”              0 KB       0 rows

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”SF0RC1″ TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”SF0RC1″ TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”SF0RC1″ TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”SF0RC1″ TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”PPSEMP_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”PPSEMP_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”PPSEMP_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”PPSEMP_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”ACCESSCD_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”ACCESSCD_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”ACCESSCD_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”ACCESSCD_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”MAILBOX_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”MAILBOX_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”MAILBOX_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”MAILBOX_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”BUILDING_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”BUILDING_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”BUILDING_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”BUILDING_TEMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”PPPCTT” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”PPPCTT” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”PPPCTT” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”PPPCTT” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”CLSDGB” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”CLSDGB” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”CLSDGB” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”CLSDGB” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”CLSPHN” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”CLSPHN” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”CLSPHN” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”CLSPHN” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”TEMP_DATE” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”TEMP_DATE” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”TEMP_DATE” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”TEMP_DATE” TO “HITACHI_ROLE”

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”SELECT” skipped, base object type TABLE:”HITACHIFULL”.”PPSEMP_EXT” creation failed

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”SELECT” skipped, base object type TABLE:”HITACHIFULL”.”MAILBOX_EXT” creation failed

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”SELECT” skipped, base object type TABLE:”HITACHIFULL”.”BUILDING_EXT” creation failed

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”SELECT” skipped, base object type TABLE:”HITACHIFULL”.”ACCESSCD_EXT” creation failed

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”PS_JOB_IDM” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”PS_JOBCODE_TBL” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”CLSBLD” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”CLSBLD” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”CLSBLD” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”CLSBLD” TO “HITACHI_ROLE”

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”DELETE” skipped, base object type TABLE:”HITACHIFULL”.”ACCLRUN” creation failed

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”INSERT” skipped, base object type TABLE:”HITACHIFULL”.”ACCLRUN” creation failed

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”SELECT” skipped, base object type TABLE:”HITACHIFULL”.”ACCLRUN” creation failed

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”UPDATE” skipped, base object type TABLE:”HITACHIFULL”.”ACCLRUN” creation failed

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”SF0EMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”SF0EMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”SF0EMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”SF0EMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”CLSAST” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”CLSAST” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”CLSAST” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”CLSAST” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”CLSCLS” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”CLSCLS” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”CLSCLS” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”CLSCLS” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”CLSDEG” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”CLSDEG” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”CLSDEG” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”CLSDEG” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”CLSUID” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”CLSUID” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”CLSUID” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”CLSUID” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”SF0AFF” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”SF0AFF” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”SF0AFF” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”SF0AFF” TO “HITACHI_ROLE”

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”DELETE” skipped, base object type TABLE:”HITACHIFULL”.”SF0IDB” creation failed

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”INSERT” skipped, base object type TABLE:”HITACHIFULL”.”SF0IDB” creation failed

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”SELECT” skipped, base object type TABLE:”HITACHIFULL”.”SF0IDB” creation failed

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”UPDATE” skipped, base object type TABLE:”HITACHIFULL”.”SF0IDB” creation failed

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”SF0INM” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”SF0INM” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”SF0INM” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”SF0INM” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”SF0ISA” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”SF0ISA” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”SF0ISA” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”SF0ISA” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”SF0IXB” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”SF0IXB” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”SF0IXB” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”SF0IXB” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”SF0SIS” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”SF0SIS” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”SF0SIS” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”SF0SIS” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”SF0TRV” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”SF0TRV” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”SF0TRV” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”SF0TRV” TO “HITACHI_ROLE”

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”DELETE” skipped, base object type TABLE:”HITACHIFULL”.”RFSTBPER” creation failed

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”INSERT” skipped, base object type TABLE:”HITACHIFULL”.”RFSTBPER” creation failed

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”SELECT” skipped, base object type TABLE:”HITACHIFULL”.”RFSTBPER” creation failed

 

ORA-39112: Dependent object type OBJECT_GRANT:”HITACHIFULL”.”UPDATE” skipped, base object type TABLE:”HITACHIFULL”.”RFSTBPER” creation failed

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”RFSTBAPP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”RFSTBAPP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”RFSTBAPP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”RFSTBAPP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”RFSTBPGM” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”RFSTBPGM” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”RFSTBPGM” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”RFSTBPGM” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”CLSBOX” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”CLSBOX” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”CLSBOX” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”CLSBOX” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”EMPLOYEE_O2_ML_TMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT DELETE ON “HITACHIFULL”.”EMPLOYEE_O2_ML_TMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT UPDATE ON “HITACHIFULL”.”EMPLOYEE_O2_ML_TMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT INSERT ON “HITACHIFULL”.”EMPLOYEE_O2_ML_TMP” TO “HITACHI_ROLE”

 

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role ‘HITACHI_ROLE’ does not exist

 

Failing sql is:

GRANT SELECT ON “HITACHIFULL”.”PPPFCT” TO “HITACHI_ROLE”

 

Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION

Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION

Processing object type SCHEMA_EXPORT/VIEW/VIEW

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

ORA-39112: Dependent object type INDEX:”HITACHIFULL”.”SF0XIDB2″ skipped, base object type TABLE:”HITACHIFULL”.”SF0IDB” creation failed

 

ORA-39112: Dependent object type INDEX:”HITACHIFULL”.”SF0XIDB1″ skipped, base object type TABLE:”HITACHIFULL”.”SF0IDB” creation failed

 

ORA-39112: Dependent object type INDEX:”HITACHIFULL”.”SF0XIDB” skipped, base object type TABLE:”HITACHIFULL”.”SF0IDB” creation failed

 

ORA-39112: Dependent object type INDEX:”HITACHIFULL”.”SF0XIDB3″ skipped, base object type TABLE:”HITACHIFULL”.”SF0IDB” creation failed

 

ORA-39112: Dependent object type INDEX:”HITACHIFULL”.”RFSXTBPER” skipped, base object type TABLE:”HITACHIFULL”.”RFSTBPER” creation failed

 

Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

ORA-39082: Object type VIEW:”HITACHIFULL”.”AHVZPAY_PAY_SSN_ZERO” created with compilation warnings

 

Job “SYSTEM”.”SYS_IMPORT_SCHEMA_01″ completed with 136 error(s) at Thu Mar 14 10:09:11 2019 elapsed 0 00:00:27

 

Default Asked on March 16, 2019 in ORACLE.
Add Comment
1 Answer(s)

Try to import into the pluggable database, instead of container .

Newbie Answered on March 28, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.