[*** script: ords_prereq_env.sql] INFO: Checking prerequisites for Oracle REST Data Services PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. INFO: Prerequisites verified. [*** script: ords_verify_tablespace.sql] Completed verifying the tablespaces SYSAUX and TEMP for SYS Completed verifying the tablespaces SYSAUX and TEMP for SYS PL/SQL procedure successfully completed. [*** script: ords_alter_session_script.sql] PL/SQL procedure successfully completed. [*** script: ords_create_schema.sql] INFO: Creating schema for Oracle REST Data Services PL/SQL procedure successfully completed. INFO: Created schema ORDS_METADATA [*** script: ords_create_rest_users.sql] PL/SQL procedure successfully completed. [*** script: ords_validate.sql] Procedure VALIDATE_ORDS compiled [*** script: ords_grant_privs.sql] INFO: Grant object and system privileges to ORDS owner Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. INFO: Completed granting object and system privileges [*** script: ords_alter_session_metadata.sql] Session altered. [*** script: ords_database_objects.sql] Table OAUTH_APPROVAL_PRIVS created. INDEX OAUTH_APP_PRIVS_UNIQUE1 created. Index OAUTH_APP_PRIVS_IDX1 created. Index OAUTH_APP_PRIVS_IDX2 created. Table OAUTH_APPROVAL_PRIVS altered. Table OAUTH_APPROVALS created. Table OAUTH_APPROVALS altered. Comment created. Comment created. Comment created. INDEX OAUTH_APPROVALS_UNIQUE1 created. Index OAUTH_APPROVALS_IDX1 created. Index OAUTH_APPROVALS_IDX2 created. Index OAUTH_APPROVALS_IDX3 created. Table OAUTH_APPROVALS altered. Table OAUTH_CLIENT_PRIVILEGES created. INDEX OAUTH_CLIENT_PRIVS_UNIQ1 created. Index OAUTH_CLIENT_PRIVS_IDX1 created. Index OAUTH_CLIENT_PRIVS_IDX2 created. Table OAUTH_CLIENT_PRIVILEGES altered. Table OAUTH_CLIENT_ROLES created. Table OAUTH_CLIENT_ROLES altered. Table OAUTH_CLIENTS created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX OAUTH_CLIENTS_UNIQUE1 created. INDEX OAUTH_CLIENTS_UNIQUE2 created. Index OAUTH_CLIENTS_IDX1 created. Table OAUTH_CLIENTS altered. Table OAUTH_CLIENTS altered. Table OAUTH_CLIENTS altered. Table OAUTH_PENDING_APPROVALS created. Comment created. Comment created. Index OAUTH_PEND_APPRV_IDX1 created. Index OAUTH_PEND_APPRV_IDX2 created. Index OAUTH_PEND_APPRV_IDX3 created. Table OAUTH_PENDING_APPROVALS altered. Table OAUTH_PENDING_APPROVALS altered. Table OAUTH_SESSIONS created. Comment created. INDEX OAUTH_USER_SESS_IDX1 created. Index OAUTH_USER_SESS_IDX4 created. Table OAUTH_SESSIONS altered. Table ORDS_HANDLERS created. Table ORDS_HANDLERS altered. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX ORDS_HANDLERS_UNIQUE1 created. Index ORDS_HANDLERS_IDX2 created. Index ORDS_HANDLERS_IDX3 created. Table ORDS_HANDLERS altered. Table ORDS_MODULES created. Table ORDS_MODULES altered. Comment created. Comment created. Comment created. Comment created. INDEX ORDS_MODULES_UNIQUE1 created. Table ORDS_MODULES altered. Table ORDS_MODULES altered. Table ORDS_MODULES altered. Table ORDS_OBJECTS created. Table ORDS_OBJECTS altered. Table ORDS_OBJECTS altered. Table ORDS_OBJECTS altered. Table ORDS_OBJECTS altered. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX ORDS_OBJECTS_PK created. INDEX ORDS_OBJECTS_ALIAS_UN created. Table ORDS_OBJECTS altered. Table ORDS_PARAMETERS created. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX ORDS_PARAMS_UNIQUE1 created. INDEX ORDS_PARAMS_UNIQUE2 created. Index ORDS_PARAMS_IDX1 created. Index ORDS_PARAMS_IDX2 created. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Table ORDS_SCHEMA_VERSION created. Comment created. Table ORDS_SCHEMAS created. Table ORDS_SCHEMAS altered. Table ORDS_SCHEMAS altered. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX ORDS_SCHEMAS_PARSING created. Table ORDS_SCHEMAS altered. Table ORDS_TEMPLATES created. Table ORDS_TEMPLATES altered. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX ORDS_TEMPLATES_UNIQUE1 created. Index ORDS_TEMPLATES_IDX1 created. Index ORDS_TEMPLATES_IDX2 created. Table ORDS_TEMPLATES altered. Table ORDS_TEMPLATES altered. Table ORDS_TEMPLATES altered. Table ORDS_TEMPLATES altered. Table ORDS_URL_MAPPINGS created. Table ORDS_URL_MAPPINGS altered. Table ORDS_URL_MAPPINGS altered. Table ORDS_URL_MAPPINGS altered. Table ORDS_WORKSPACE_SCHEMAS created. Table ORDS_WORKSPACE_SCHEMAS altered. Table ORDS_WORKSPACE_SCHEMAS altered. Table SEC_AUTHENTICATORS created. Table SEC_AUTHENTICATORS altered. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX SEC_AUTHS_UNQ_NAME created. INDEX SEC_AUTHS_UNQ_PROVIDER created. Table SEC_AUTHENTICATORS altered. Table SEC_KEYS created. Table SEC_KEYS altered. Table SEC_ORIGINS_ALLOWED_MODULES created. Table SEC_ORIGINS_ALLOWED_MODULES altered. Table SEC_ORIGINS_ALLOWED_MODULES altered. Table SEC_PRIVILEGE_AUTHS created. INDEX PRIVILEGE_AUTHS_UNIQUE1 created. Table SEC_PRIVILEGE_AUTHS altered. Table SEC_PRIVILEGE_MAPPINGS created. Table SEC_PRIVILEGE_MAPPINGS altered. Table SEC_PRIVILEGE_MAPPINGS altered. Table SEC_PRIVILEGE_MODULES created. Table SEC_PRIVILEGE_MODULES altered. Table SEC_PRIVILEGE_MODULES altered. Table SEC_PRIVILEGE_ROLES created. INDEX PRIVILEGE_ROLES_UNIQUE1 created. Table SEC_PRIVILEGE_ROLES altered. Table SEC_PRIVILEGES created. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX PRIVILEGES_UNQ_NAME created. Table SEC_PRIVILEGES altered. Table SEC_ROLE_MAPPINGS created. INDEX ROLE_MAPPINGS_UNQ_PATTERN created. Table SEC_ROLE_MAPPINGS altered. Table SEC_ROLES created. INDEX ROLES_UNQ_NAME created. Table SEC_ROLES altered. Table SEC_SESSIONS created. Table SEC_SESSIONS altered. Table SEC_SESSIONS altered. Table SEC_SESSIONS altered. Table SEC_AUTHENTICATORS altered. Table OAUTH_APPROVAL_PRIVS altered. Table OAUTH_APPROVAL_PRIVS altered. Table OAUTH_APPROVAL_PRIVS altered. Table OAUTH_APPROVALS altered. Table OAUTH_APPROVALS altered. Table OAUTH_CLIENT_PRIVILEGES altered. Table OAUTH_CLIENT_PRIVILEGES altered. Table OAUTH_CLIENT_PRIVILEGES altered. Table OAUTH_CLIENT_ROLES altered. Table OAUTH_CLIENT_ROLES altered. Table OAUTH_CLIENT_ROLES altered. Table OAUTH_CLIENTS altered. Table OAUTH_PENDING_APPROVALS altered. Table OAUTH_PENDING_APPROVALS altered. Table OAUTH_SESSIONS altered. Table OAUTH_SESSIONS altered. Table OAUTH_SESSIONS altered. Table ORDS_HANDLERS altered. Table ORDS_HANDLERS altered. Table ORDS_MODULES altered. Table ORDS_OBJECTS altered. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Table ORDS_SCHEMAS altered. Table ORDS_TEMPLATES altered. Table ORDS_TEMPLATES altered. Table ORDS_WORKSPACE_SCHEMAS altered. Table SEC_PRIVILEGE_AUTHS altered. Table SEC_PRIVILEGE_AUTHS altered. Table SEC_PRIVILEGE_AUTHS altered. Table SEC_PRIVILEGE_ROLES altered. Table SEC_PRIVILEGE_ROLES altered. Table SEC_PRIVILEGE_ROLES altered. Table SEC_PRIVILEGES altered. Table SEC_ROLE_MAPPINGS altered. Table SEC_ROLE_MAPPINGS altered. Table SEC_ROLES altered. Table SEC_KEYS altered. Table SEC_ORIGINS_ALLOWED_MODULES altered. Table SEC_PRIVILEGE_MAPPINGS altered. Table SEC_PRIVILEGE_MAPPINGS altered. Table SEC_PRIVILEGE_MODULES altered. Table SEC_PRIVILEGE_MODULES altered. Table SEC_PRIVILEGE_MODULES altered. Table SEC_SESSIONS altered. View ORDS_CLIENT_ROLES created. View ORDS_MODULE_SERVICES created. View ORDS_PRIVILEGE_MAPPINGS created. View ORDS_REPVERSION created. View ORDS_VERSION created. View POOL_CONFIG created. View USER_ORDS_APPROVALS created. View USER_ORDS_CLIENTS created. View USER_ORDS_CLIENT_PRIVILEGES created. View USER_ORDS_CLIENT_ROLES created. View USER_ORDS_ENABLED_OBJECTS created. View USER_ORDS_HANDLERS created. View USER_ORDS_MODULES created. View USER_ORDS_OBJECTS created. View USER_ORDS_OBJ_MEMBERS created. View USER_ORDS_PARAMETERS created. View USER_ORDS_PENDING_APPROVALS created. View USER_ORDS_PRIVILEGES created. View USER_ORDS_PRIVILEGE_MAPPINGS created. View USER_ORDS_PRIVILEGE_MODULES created. View USER_ORDS_ROLES created. View USER_ORDS_PRIVILEGE_ROLES created. View USER_ORDS_SCHEMAS created. View USER_ORDS_SERVICES created. View USER_ORDS_TEMPLATES created. [*** script: ords_triggers.sql] Sequence ORDS_ID_SEQ created. Trigger OAUTH_APPROVALS_TRG compiled Trigger OAUTH_APPROVAL_PRIVS_TRG compiled Trigger OAUTH_CLIENTS_TRG compiled Trigger OAUTH_CLIENT_PRIVILEGES_TRG compiled Trigger OAUTH_PENDING_APPROVALS_TRG compiled Trigger OAUTH_SESSIONS_TRG compiled Trigger ORDS_HANDLERS_TRG compiled Trigger ORDS_MODULES_TRG compiled Trigger ORDS_PARAMETERS_TRG compiled Trigger ORDS_SCHEMAS_TRG compiled Trigger ORDS_OBJECTS_TRG compiled Trigger ORDS_TEMPLATES_TRG compiled Trigger ORDS_URL_MAPPINGS_TRG compiled Trigger SEC_AUTHENTICATORS_TRG compiled Trigger SEC_ROLES_TRG compiled Trigger SEC_PRIVILEGES_TRG compiled Trigger SEC_ROLE_MAPPINGS_TRG compiled Trigger SEC_PRIVILEGE_AUTHS_TRG compiled Trigger SEC_PRIVILEGE_ROLES_TRG compiled Trigger SEC_PRIVILEGE_MODULES_TRG compiled Trigger SEC_SESSIONS_TRG compiled Trigger SEC_KEYS_TRG compiled Trigger ORDS_WORKSPACE_SCHEMAS_TRG compiled Trigger SEC_ORIG_ALLOWED_MOD_TRG compiled Trigger SEC_PRIV_MAPS_TRG compiled Trigger OAUTH_CLIENT_ROLES_TRG compiled [*** script: ords_types.sql] Type T_ORDS_VCHAR_TAB compiled Type T_ORDS_NUM_TAB compiled Type T_ORDS_ATTR_SUPPORT_OBJ compiled Type T_ORDS_ATTR_SUPPORT_TAB compiled PL/SQL procedure successfully completed. Type T_ORDS_METADATA_TYPE compiled Type T_ORDS_METADATA_TYPE_LIST compiled Type T_ORDS_MODULE_PRIVILEGE compiled Type Body T_ORDS_MODULE_PRIVILEGE compiled Type T_ORDS_MODULE_ORIGINS_ALLOWED compiled Type Body T_ORDS_MODULE_ORIGINS_ALLOWED compiled Type T_ORDS_PARAMETER compiled Type Body T_ORDS_PARAMETER compiled Type T_ORDS_PARAMETER_LIST compiled Type T_ORDS_HANDLER compiled Type Body T_ORDS_HANDLER compiled Type T_ORDS_HANDLER_LIST compiled Type T_ORDS_TEMPLATE compiled Type Body T_ORDS_TEMPLATE compiled Type T_ORDS_TEMPLATE_LIST compiled Type T_ORDS_MODULE compiled Type Body T_ORDS_MODULE compiled Type T_ORDS_MODULE_LIST compiled [*** script: ords_version.sql] Session altered. INFO: Schema version : 18.1.1.95.1251 PL/SQL procedure successfully completed. [*** script: ords_schema_mapping.sql] INFO: Configuring ORDS_PUBLIC_USER to map APEX Workspaces and ORDS schemas Session altered. Configuring APEX and ORDS schemas for url mapping APEX 18.1.0.00.45 is installed and APEX_LISTENER schema exists APEX_LISTENER.POOL_CONFIG synonym exists PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. Grant succeeded. INFO: Completed configuring ORDS_PUBLIC_USER to map APEX Workspaces and ORDS Schemas Session altered. [*** script: ords.pls] Package ORDS compiled [*** script: ords_internal.pls] Package ORDS_INTERNAL compiled [*** script: ords_security.pls] Package ORDS_SECURITY compiled [*** script: ords_services_internal.pls] Package ORDS_SERVICES_INTERNAL compiled [*** script: ords_services.pls] Package ORDS_SERVICES compiled [*** script: ords_oper.pls] Package ORDS_OPER compiled [*** script: oauth_internal.pls] Package OAUTH_INTERNAL compiled [*** script: oauth.pls] Package OAUTH compiled [*** script: ords_export.pls] Package ORDS_EXPORT compiled [*** script: ords_internal.plb] Package Body ORDS_INTERNAL compiled [*** script: ords_security.plb] Package Body ORDS_SECURITY compiled [*** script: ords_services_internal.plb] Package Body ORDS_SERVICES_INTERNAL compiled [*** script: ords_services.plb] Package Body ORDS_SERVICES compiled [*** script: ords.plb] Package Body ORDS compiled [*** script: ords_oper.plb] Package Body ORDS_OPER compiled [*** script: oauth_internal.plb] Package Body OAUTH_INTERNAL compiled [*** script: oauth.plb] Package Body OAUTH compiled [*** script: ords_export.plb] Package Body ORDS_EXPORT compiled [*** script: ords_jobs.sql] PL/SQL procedure successfully completed. [*** script: ords_pub_synonyms_grants.sql] Session altered. PL/SQL procedure successfully completed. Grant succeeded. Grant succeeded. Grant succeeded. SYNONYM USER_ORDS_REPOVERSIONS created. [*** script: ords_seed.sql] Session altered. 0 rows deleted. 0 rows deleted. 0 rows deleted. 0 rows deleted. 0 rows deleted. 1 row inserted. 1 row inserted. 1 row inserted. 1 row inserted. 1 row inserted. 1 row inserted. 1 row inserted. 1 row inserted. 1 row inserted. 1 row inserted. 1 row inserted. Commit complete. [*** script: ords_rem_temp_privs.sql] Session altered. INFO: Removing temporal privileges from ORDS owner Revoke succeeded. INFO: Completed removing temporal privileges [*** script: ords_verify_install.sql] Session altered. INFO: 21:47:54 Validating objects for Oracle REST Data Services. VALIDATION: 21:47:54 Starting validation for schema: ORDS_METADATA VALIDATION: 21:47:54 Validating objects VALIDATION: 21:47:55 Validating ORDS Public Synonyms VALIDATION: 21:47:55 Total objects: 235, invalid objects: 0 VALIDATION: 21:47:55 72 INDEX VALIDATION: 21:47:55 1 JOB VALIDATION: 21:47:55 9 PACKAGE VALIDATION: 21:47:55 9 PACKAGE BODY VALIDATION: 21:47:55 41 PUBLIC SYNONYM VALIDATION: 21:47:55 1 SEQUENCE VALIDATION: 21:47:55 27 TABLE VALIDATION: 21:47:55 26 TRIGGER VALIDATION: 21:47:55 16 TYPE VALIDATION: 21:47:55 6 TYPE BODY VALIDATION: 21:47:55 27 VIEW VALIDATION: 21:47:55 Validation completed. INFO: 21:47:55 Completed validation for Oracle REST Data Services. PL/SQL procedure successfully completed. Commit complete. [*** script: ords_alter_session_script.sql] PL/SQL procedure successfully completed.