;;; Import: Release 19.0.0.0.0 - Production on Wed Jun 15 11:19:12 2022 Version 19.9.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. ;;; Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Master table "ALOPEZDIAZ"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded Starting "ALOPEZDIAZ"."SYS_IMPORT_SCHEMA_01": alopezdiaz/******** DIRECTORY=EXPORT_TMPDIR_ALD DUMPFILE=GPT3_OWN_PRESCORE.dmp LOGFILE=IMP_GPT3_OWN_DESSIL.log SCHEMAS=GPT3_OWN Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "GPT3_OWN"."APPLIEDINTOSELECTEDSHIFTS" 79.48 KB 1034 rows . . imported "GPT3_OWN"."UNIT" 44.96 KB 385 rows . . imported "GPT3_OWN"."DIAGNOSTICSB" 0 KB 0 rows . . imported "GPT3_OWN"."POSTABLE2NOTE" 0 KB 0 rows . . imported "GPT3_OWN"."DIAGNOSTICSC" 0 KB 0 rows . . imported "GPT3_OWN"."CAPABILITYVERSION" 0 KB 0 rows . . imported "GPT3_OWN"."CAPABILITY" 0 KB 0 rows . . imported "GPT3_OWN"."SHIFTREQUESTVERSION" 11.16 KB 3 rows . . imported "GPT3_OWN"."PERSONTONOTE" 0 KB 0 rows . . imported "GPT3_OWN"."EXTERNALEMPLOYEEDATA" 1.832 MB 9507 rows . . imported "GPT3_OWN"."CONTRACTTONOTE" 0 KB 0 rows . . imported "GPT3_OWN"."APPLIEDINTOSELECTEDLOCATION" 27.02 KB 250 rows . . imported "GPT3_OWN"."SHIFTTYPEDAY" 12.01 MB 194574 rows . . imported "GPT3_OWN"."CONTRACTDATA" 26.78 KB 89 rows . . imported "GPT3_OWN"."SHIFTPATTERNSETINEMPLOYEE" 334.5 KB 3313 rows . . imported "GPT3_OWN"."PLANNINGSCENARIO" 0 KB 0 rows . . imported "GPT3_OWN"."POSTABLE" 95.18 KB 738 rows . . imported "GPT3_OWN"."EXTADMINUNITVERSION" 344.0 KB 2351 rows . . imported "GPT3_OWN"."CONTRACTDATAVERSION" 30.96 KB 89 rows . . imported "GPT3_OWN"."SHIFTPATTERN" 2.008 MB 27804 rows . . imported "GPT3_OWN"."PERSONVERSION" 1.787 MB 8888 rows . . imported "GPT3_OWN"."POSTABLEVERSION" 342.2 KB 2187 rows . . imported "GPT3_OWN"."PARAMETER" 0 KB 0 rows . . imported "GPT3_OWN"."USERINROLE_UNITAPPLY" 0 KB 0 rows . . imported "GPT3_OWN"."ROLEENTERPRISEPARAM" 0 KB 0 rows . . imported "GPT3_OWN"."CONTRACTPIECE" 423.0 KB 6231 rows . . imported "GPT3_OWN"."EMP2EXT" 930.0 KB 9507 rows . . imported "GPT3_OWN"."COUNTERSET" 9.179 KB 1 rows . . imported "GPT3_OWN"."EMPLOYEETONOTE" 0 KB 0 rows . . imported "GPT3_OWN"."EMPLOYEEDATE" 293.3 MB 3991678 rows . . imported "GPT3_OWN"."USERINROLEUNITPARAMTOAPPLYUNITPERMISSIONS" 0 KB 0 rows . . imported "GPT3_OWN"."EXTERNALCAPABILITY" 0 KB 0 rows . . imported "GPT3_OWN"."NOTE" 0 KB 0 rows . . imported "GPT3_OWN"."ENTERPRISEVERSION" 10.89 KB 4 rows . . imported "GPT3_OWN"."CONTRACT" 21.21 KB 89 rows . . imported "GPT3_OWN"."CHANGEREASONDATA" 9.359 KB 2 rows . . imported "GPT3_OWN"."SHIFTDEMAND" 0 KB 0 rows . . imported "GPT3_OWN"."ROLE" 9.437 KB 4 rows . . imported "GPT3_OWN"."EMPLOYEEDATEVERSION" 270.4 MB 3991606 rows . . imported "GPT3_OWN"."CUSTOMDAILYCHECK" 23.71 MB 189973 rows . . imported "GPT3_OWN"."CHANGEREASON" 9.742 KB 2 rows . . imported "GPT3_OWN"."CAPABILITYTONOTE" 0 KB 0 rows . . imported "GPT3_OWN"."DAILYCHECK" 521.9 MB 5797623 rows . . imported "GPT3_OWN"."EXTADMINUNIT" 33.73 KB 232 rows . . imported "GPT3_OWN"."UNITVERSION" 102.0 KB 770 rows . . imported "GPT3_OWN"."ADMINUNITDATA" 30.44 KB 232 rows . . imported "GPT3_OWN"."EMP2EXTVERSION" 1.494 MB 11781 rows . . imported "GPT3_OWN"."EMPLOYEELIMIT" 0 KB 0 rows . . imported "GPT3_OWN"."SIGNUP" 0 KB 0 rows . . imported "GPT3_OWN"."SHIFTTOSHIFTGROUP" 42.29 KB 409 rows . . imported "GPT3_OWN"."ROLEVERSION" 12.01 KB 13 rows . . imported "GPT3_OWN"."EXTERNALPOSITION" 91.88 KB 738 rows . . imported "GPT3_OWN"."SHIFTTONOTE" 0 KB 0 rows . . imported "GPT3_OWN"."LABOURLAWDATA" 0 KB 0 rows . . imported "GPT3_OWN"."SHIFTGROUP" 11.35 KB 14 rows . . imported "GPT3_OWN"."SHIFTVERSION" 71.97 KB 375 rows . . imported "GPT3_OWN"."EXTERNALEMPLOYEEVERSION" 1.794 MB 11781 rows . . imported "GPT3_OWN"."ADMINUNITVERSION" 389.3 KB 2351 rows . . imported "GPT3_OWN"."ENTERPRISEDATA" 8.992 KB 4 rows . . imported "GPT3_OWN"."EXTERNALEMPLOYEE" 1.150 MB 9507 rows . . imported "GPT3_OWN"."UNITDEMANDVERSION" 145.0 KB 943 rows . . imported "GPT3_OWN"."LABOURLAW" 9.671 KB 1 rows . . imported "GPT3_OWN"."SHIFTGROUPTONOTE" 0 KB 0 rows . . imported "GPT3_OWN"."PROPERTY" 9.390 KB 2 rows . . imported "GPT3_OWN"."EXPLANATION" 50.66 MB 393234 rows . . imported "GPT3_OWN"."UNITDEMAND" 113.4 KB 943 rows . . imported "GPT3_OWN"."LOGGEDEVENTS" 5.312 MB 27591 rows . . imported "GPT3_OWN"."LABOURLAWVERSION" 11.02 KB 1 rows . . imported "GPT3_OWN"."ASSIGNEDSTAFF" 0 KB 0 rows . . imported "GPT3_OWN"."ALLOWEDHOLIDAYS" 59.82 KB 384 rows . . imported "GPT3_OWN"."CONCEPTVERSION" 33.11 KB 159 rows . . imported "GPT3_OWN"."CONTRACTTYPEVERSION" 11.32 KB 4 rows . . imported "GPT3_OWN"."PERSON" 1.208 MB 7182 rows . . imported "GPT3_OWN"."EXTERNALLABOURLAWVERSION" 11.46 KB 1 rows . . imported "GPT3_OWN"."WRKCLNNTR" 18.06 KB 99 rows . . imported "GPT3_OWN"."DAILYDEMAND" 143.0 MB 1870308 rows . . imported "GPT3_OWN"."EMPLOYEE" 598.2 KB 7182 rows . . imported "GPT3_OWN"."LABOURLAWDATAVERSION" 0 KB 0 rows . . imported "GPT3_OWN"."EMPLOYEEMONTH" 9.284 MB 134856 rows . . imported "GPT3_OWN"."CONCEPTINSHIFT" 215.1 KB 2636 rows . . imported "GPT3_OWN"."LABOURLAWTONOTE" 0 KB 0 rows . . imported "GPT3_OWN"."JOURNEYTYPEVERSION" 10.76 KB 3 rows . . imported "GPT3_OWN"."EXTERNALCAPABILITYVERSION" 0 KB 0 rows . . imported "GPT3_OWN"."CAPABILITYDEGREE" 10.16 KB 2 rows . . imported "GPT3_OWN"."CONCEPTTONOTE" 0 KB 0 rows . . imported "GPT3_OWN"."ADMINUNITDATAVERSION" 359.1 KB 2351 rows . . imported "GPT3_OWN"."SHIFTPATTERNSETINUNIT" 45.59 KB 452 rows . . imported "GPT3_OWN"."LOCATION" 24.16 KB 180 rows . . imported "GPT3_OWN"."USERSTABLE" 10.71 KB 3 rows . . imported "GPT3_OWN"."EXTERNALPOSITIONVERSION" 335.4 KB 2187 rows . . imported "GPT3_OWN"."ENTERPRISE" 9.445 KB 4 rows . . imported "GPT3_OWN"."ROLEUNITPARAM" 0 KB 0 rows . . imported "GPT3_OWN"."CONCEPT" 46.37 KB 330 rows . . imported "GPT3_OWN"."CONCEPTINSHIFTREQUEST" 0 KB 0 rows . . imported "GPT3_OWN"."WRKCLNNTRVERSION" 22.76 KB 99 rows . . imported "GPT3_OWN"."ENTERPRISETONOTE" 0 KB 0 rows . . imported "GPT3_OWN"."EXTCHGRSN" 0 KB 0 rows . . imported "GPT3_OWN"."EXTERNALLABOURLAW" 10.11 KB 1 rows . . imported "GPT3_OWN"."ENTERPRISEDATAVERSION" 10.45 KB 4 rows . . imported "GPT3_OWN"."CHANGEREASONDATAVERSION" 11.07 KB 4 rows . . imported "GPT3_OWN"."UNITTONOTE" 0 KB 0 rows . . imported "GPT3_OWN"."CONTRACTTYPE" 9.867 KB 4 rows . . imported "GPT3_OWN"."CONTRACTMAP" 19.85 KB 64 rows . . imported "GPT3_OWN"."CHANGEREASONVERSION" 11.56 KB 5 rows . . imported "GPT3_OWN"."USERSTABLE2ENTERPRISE" 0 KB 0 rows . . imported "GPT3_OWN"."EXTERNALENTERPRISE" 9.757 KB 3 rows . . imported "GPT3_OWN"."DIAGNOSTICSD" 0 KB 0 rows . . imported "GPT3_OWN"."PERMISSION" 18.02 KB 84 rows . . imported "GPT3_OWN"."DIAGNOSTICSA" 0 KB 0 rows . . imported "GPT3_OWN"."CAPABILITYDEGREEVERSION" 11.55 KB 2 rows . . imported "GPT3_OWN"."SHIFT" 57.14 KB 361 rows . . imported "GPT3_OWN"."EXTCHGRSNVERSION" 0 KB 0 rows . . imported "GPT3_OWN"."USERINROLEVERSION" 10.61 KB 2 rows . . imported "GPT3_OWN"."EXTERNALEMPLOYEEDATAVERSION" 2.638 MB 11781 rows . . imported "GPT3_OWN"."USERINROLE" 9.156 KB 1 rows . . imported "GPT3_OWN"."EXTERNALENTERPRISEVERSION" 11.17 KB 3 rows . . imported "GPT3_OWN"."ADMINUNIT" 35.92 KB 232 rows . . imported "GPT3_OWN"."SHIFTTOLABOURLAW" 34.89 KB 360 rows . . imported "GPT3_OWN"."ASSIGNATION" 2.381 MB 14394 rows . . imported "GPT3_OWN"."JOURNEYTYPE" 9.343 KB 3 rows . . imported "GPT3_OWN"."CONTRACTPIECEVERSION" 624.7 KB 6231 rows . . imported "GPT3_OWN"."COUNTERCONFIGURATION" 14.55 KB 5 rows . . imported "GPT3_OWN"."EMPLOYEEVERSION" 1023. KB 8888 rows . . imported "GPT3_OWN"."PERMISSIONVERSION" 41.89 KB 252 rows . . imported "GPT3_OWN"."ALLOWEDHOLIDAYSVERSION" 73.49 KB 384 rows . . imported "GPT3_OWN"."SHIFTTYPEDAYSHIFT" 14.32 MB 194574 rows . . imported "GPT3_OWN"."SHIFTASSIGNMENT" 0 KB 0 rows . . imported "GPT3_OWN"."POSITIONDATA" 130.8 KB 1251 rows . . imported "GPT3_OWN"."USERSTABLE2UNIT" 0 KB 0 rows . . imported "GPT3_OWN"."USERSTABLEVERSION" 12.36 KB 5 rows . . imported "GPT3_OWN"."SHIFTREQUEST" 9.75 KB 3 rows . . imported "GPT3_OWN"."ADMINUNIT2NOTE" 0 KB 0 rows . . imported "GPT3_OWN"."ASSIGNATIONVERSION" 2.837 MB 14394 rows . . imported "GPT3_OWN"."UNITTOENTERPRISE" 9.265 KB 3 rows . . imported "GPT3_OWN"."POSITIONDATAVERSION" 305.9 KB 2187 rows . . imported "GPT3_OWN"."CONTRACTVERSION" 25.39 KB 89 rows . . imported "GPT3_OWN"."CONCEPTINSHIFTVERSION" 301.2 KB 2636 rows Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Job "ALOPEZDIAZ"."SYS_IMPORT_SCHEMA_01" successfully completed at Wed Jun 15 11:20:35 2022 elapsed 0 00:01:14