[*** script: ords_alter_session_script.sql] 

PL/SQL procedure successfully completed.

[*** script: ords_alter_session_metadata.sql] 

Session altered.

[*** script: ords_migrate.pls] 

Package ORDS_MIGRATE compiled

[*** script: ords_migrate.plb] 

Package Body ORDS_MIGRATE compiled

[*** script: ords_migrate_pub_synonym.sql] 

Session altered.


Synonym ORDS_MIGRATE created.

[*** script: ords_migrate_grant_priv.sql] 

Session altered.

INFO: Verify if Application Express exists to setup the migration privileges for
ORDS.
INFO: Completed setting up the APEX REST migration privileges for ORDS.


PL/SQL procedure successfully completed.

[*** script: ords_verify_install.sql] 

Session altered.

INFO: 21:47:57 Validating objects for Oracle REST Data Services.
VALIDATION: 21:47:57 Starting validation for schema: ORDS_METADATA
VALIDATION: 21:47:57 Validating objects
VALIDATION: 21:47:57 Validating ORDS Public Synonyms
VALIDATION: 21:47:57 Total objects: 258, invalid objects: 0
VALIDATION: 21:47:57     72  INDEX
VALIDATION: 21:47:57      1  JOB
VALIDATION: 21:47:57     11  PACKAGE
VALIDATION: 21:47:57     11  PACKAGE BODY
VALIDATION: 21:47:57     43  PUBLIC SYNONYM
VALIDATION: 21:47:57      1  SEQUENCE
VALIDATION: 21:47:57     14  SYNONYM
VALIDATION: 21:47:57     27  TABLE
VALIDATION: 21:47:57     26  TRIGGER
VALIDATION: 21:47:57     19  TYPE
VALIDATION: 21:47:57      6  TYPE BODY
VALIDATION: 21:47:57     27  VIEW
VALIDATION: 21:47:57 Validation completed.
INFO: 21:47:57 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.

[*** 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.

[*** script: ords_alter_session_script.sql] 

PL/SQL procedure successfully completed.

[*** script: ords_alter_session_metadata.sql] 

Session altered.

[*** script: dm_grant_privs.sql] 
INFO: Grant object and system privileges to ORDS owner for datamodel team

Grant succeeded.


Grant succeeded.


Grant succeeded.

INFO: Completed granting object and system privileges for datamodel team
[*** script: dm_types.sql] 

Type DM_DDL_DESC compiled


Type DM_DDL_ROW compiled


Type DM_DDL_TAB compiled

[*** script: osddm_dbms_md_ddl.pls] 

Package OSDDM_DBMS_MD_DDL compiled

[*** script: osddm_dbms_md_ddl.plb] 

Package Body OSDDM_DBMS_MD_DDL compiled

[*** script: dm_grants_synonyms.sql] 

Session altered.


Grant succeeded.


Synonym OSDDM_DBMS_MD_DDL created.

[*** script: ords_verify_install.sql] 

Session altered.

INFO: 21:47:55 Validating objects for Oracle REST Data Services.
VALIDATION: 21:47:55 Starting validation for schema: ORDS_METADATA
VALIDATION: 21:47:55 Validating objects
VALIDATION: 21:47:56 Validating ORDS Public Synonyms
VALIDATION: 21:47:56 Total objects: 241, invalid objects: 0
VALIDATION: 21:47:56     72  INDEX
VALIDATION: 21:47:56      1  JOB
VALIDATION: 21:47:56     10  PACKAGE
VALIDATION: 21:47:56     10  PACKAGE BODY
VALIDATION: 21:47:56     42  PUBLIC SYNONYM
VALIDATION: 21:47:56      1  SEQUENCE
VALIDATION: 21:47:56     27  TABLE
VALIDATION: 21:47:56     26  TRIGGER
VALIDATION: 21:47:56     19  TYPE
VALIDATION: 21:47:56      6  TYPE BODY
VALIDATION: 21:47:56     27  VIEW
VALIDATION: 21:47:56 Validation completed.
INFO: 21:47:56 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.

[*** script: ords_alter_session_script.sql] 

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_repair_proxy_connect.sql] 
INFO: Checking ords enabled schemas and its proxy user

Session altered.


PL/SQL procedure successfully completed.

[*** script: ords_migrate_grant_priv.sql] 

Session altered.

INFO: Verify if Application Express exists to setup the migration privileges for
ORDS.
INFO: Completed setting up the APEX REST migration privileges for ORDS.


PL/SQL procedure successfully completed.

[*** script: ords_validate_objects.sql] 

Session altered.

INFO: 18:45:23 Validating objects for Oracle REST Data Services.
VALIDATION: 18:45:23 Starting validation for schema: ORDS_METADATA
VALIDATION: 18:45:23 Validating objects
VALIDATION: 18:45:24 Validating ORDS Public Synonyms
VALIDATION: 18:45:24 Total objects: 258, invalid objects: 0
VALIDATION: 18:45:24     72  INDEX
VALIDATION: 18:45:24      1  JOB
VALIDATION: 18:45:24     11  PACKAGE
VALIDATION: 18:45:24     11  PACKAGE BODY
VALIDATION: 18:45:24     43  PUBLIC SYNONYM
VALIDATION: 18:45:24      1  SEQUENCE
VALIDATION: 18:45:24     14  SYNONYM
VALIDATION: 18:45:24     27  TABLE
VALIDATION: 18:45:24     26  TRIGGER
VALIDATION: 18:45:24     19  TYPE
VALIDATION: 18:45:24      6  TYPE BODY
VALIDATION: 18:45:24     27  VIEW
VALIDATION: 18:45:24 Validation completed.
INFO: 18:45:24 Completed validating objects for Oracle REST Data Services.


PL/SQL procedure successfully completed.


Session altered.


Commit complete.

[*** script: ords_alter_session_script.sql] 

PL/SQL procedure successfully completed.