Nested table type of varchar2(32767).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_varchar2_tbl FORCE IS TABLE OF (varchar2(32767)) NOT PERSISTABLE;

Migration tablespace settings.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_target_type_tablespace_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  target_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_target_type_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_target_type_tablespace_details_t (
    target_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Migration tablespace settings valid for ADB-D target type using auto create feature

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_adb_dedicated_auto_create_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_target_type_tablespace_details_t (
  is_auto_create number,
  is_big_file number,
  extend_size_in_m_bs number,
  block_size_in_k_bs varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_adb_dedicated_auto_create_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_adb_dedicated_auto_create_tablespace_details_t (
    target_type varchar2,
    is_auto_create number,
    is_big_file number,
    extend_size_in_m_bs number,
    block_size_in_k_bs varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_adb_dedicated_auto_create_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_target_type_tablespace_details_t type.

Fields

Migration tablespace settings valid for ADB-D target type using remap feature

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_adb_dedicated_remap_target_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_target_type_tablespace_details_t (
  remap_target varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_adb_dedicated_remap_target_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_adb_dedicated_remap_target_tablespace_details_t (
    target_type varchar2,
    remap_target varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_adb_dedicated_remap_target_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_target_type_tablespace_details_t type.

Fields

Migration tablespace settings valid for ADB-D target type using remap feature

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_adb_serverles_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_target_type_tablespace_details_t (
  remap_target varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_adb_serverles_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_adb_serverles_tablespace_details_t (
    target_type varchar2,
    remap_target varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_adb_serverles_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_target_type_tablespace_details_t type.

Fields

Database Administrator Credentials details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_admin_credentials_t FORCE AUTHID CURRENT_USER IS OBJECT (
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_admin_credentials_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_admin_credentials_t (
    username varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to access Pre-Migration Advisor report in the specified Object Storage bucket, if any.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_advisor_report_bucket_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  bucket_name varchar2(32767),
  namespace varchar2(32767),
  object_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_advisor_report_bucket_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_advisor_report_bucket_details_t (
    bucket_name varchar2,
    namespace varchar2,
    object_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to access Pre-Migration Advisor report.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_advisor_report_location_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  object_storage_details dbms_cloud_oci_database_migration_advisor_report_bucket_details_t,
  location_in_source varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_advisor_report_location_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_advisor_report_location_details_t (
    object_storage_details dbms_cloud_oci_database_migration_advisor_report_bucket_details_t,
    location_in_source varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Pre-Migration advisor report details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_advisor_report_t FORCE AUTHID CURRENT_USER IS OBJECT (
  report_location_details dbms_cloud_oci_database_migration_advisor_report_location_details_t,
  result varchar2(32767),
  number_of_fatal number,
  number_of_fatal_blockers number,
  number_of_warnings number,
  number_of_informational_results number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_advisor_report_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_advisor_report_t (
    report_location_details dbms_cloud_oci_database_migration_advisor_report_location_details_t,
    result varchar2,
    number_of_fatal number,
    number_of_fatal_blockers number,
    number_of_warnings number,
    number_of_informational_results number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional Pre-Migration advisor settings.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_advisor_settings_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_skip_advisor number,
  is_ignore_errors number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_advisor_settings_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_advisor_settings_t (
    is_skip_advisor number,
    is_ignore_errors number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

ODMS Agent Details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_agent_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  stream_id varchar2(32767),
  public_key varchar2(32767),
  version varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_agent_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_agent_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    stream_id varchar2,
    public_key varchar2,
    version varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

ODMS Agent Details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_agent_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  stream_id varchar2(32767),
  version varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_agent_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_agent_summary_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    stream_id varchar2,
    version varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_agent_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_agent_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_agent_summary_t) NOT PERSISTABLE;

Results of an Agent search. Contains AgentSummary items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_agent_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_migration_agent_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_agent_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_agent_collection_t (
    items dbms_cloud_oci_database_migration_agent_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Available ODMS Agent Images.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_agent_image_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  version varchar2(32767),
  download_url varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_agent_image_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_agent_image_summary_t (
    version varchar2,
    download_url varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_agent_image_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_agent_image_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_agent_image_summary_t) NOT PERSISTABLE;

Results of an ODMS Agent Image search. Contains AgentImageSummary items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_agent_image_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_migration_agent_image_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_agent_image_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_agent_image_collection_t (
    items dbms_cloud_oci_database_migration_agent_image_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional additional properties for dump transfer in source or target host. Default kind is CURL

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t (
    l_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

AWS S3 bucket details used for source Connection resources with RDS_ORACLE type. Only supported for source Connection resources with RDS_ORACLE type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_aws_s3_data_transfer_medium_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t (
  name varchar2(32767),
  l_region varchar2(32767),
  access_key_id varchar2(32767),
  secret_access_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_aws_s3_data_transfer_medium_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_aws_s3_data_transfer_medium_details_t (
    l_type varchar2,
    name varchar2,
    l_region varchar2,
    access_key_id varchar2,
    secret_access_key varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_aws_s3_data_transfer_medium_details_t is a subtype of the dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t type.

Fields

AWS S3 bucket details used for source Connection resources with RDS_ORACLE type. Only supported for source Connection resources with RDS_ORACLE type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_aws_s3_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  l_region varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_aws_s3_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_aws_s3_details_t (
    name varchar2,
    l_region varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Change Agent compartment details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_change_agent_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_change_agent_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_change_agent_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Change Database Connection compartment details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_change_connection_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_change_connection_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_change_connection_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Change Migration compartment details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_change_migration_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_change_migration_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_change_migration_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Database objects to include or exclude from migration

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_database_object_t FORCE AUTHID CURRENT_USER IS OBJECT (
  owner varchar2(32767),
  object_name varchar2(32767),
  l_type varchar2(32767),
  is_omit_excluded_table_from_replication number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_database_object_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_database_object_t (
    owner varchar2,
    object_name varchar2,
    l_type varchar2,
    is_omit_excluded_table_from_replication number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

OCI Vault details to store migration and connection credentials secrets

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_vault_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  vault_id varchar2(32767),
  key_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_vault_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_vault_details_t (
    compartment_id varchar2,
    vault_id varchar2,
    key_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_database_object_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_database_object_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_database_object_t) NOT PERSISTABLE;

Details that will override an existing Migration configuration that will be cloned.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_clone_migration_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  agent_id varchar2(32767),
  source_database_connection_id varchar2(32767),
  source_container_database_connection_id varchar2(32767),
  target_database_connection_id varchar2(32767),
  exclude_objects dbms_cloud_oci_database_migration_database_object_tbl,
  include_objects dbms_cloud_oci_database_migration_database_object_tbl,
  vault_details dbms_cloud_oci_database_migration_create_vault_details_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_clone_migration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_clone_migration_details_t (
    display_name varchar2,
    compartment_id varchar2,
    agent_id varchar2,
    source_database_connection_id varchar2,
    source_container_database_connection_id varchar2,
    target_database_connection_id varchar2,
    exclude_objects dbms_cloud_oci_database_migration_database_object_tbl,
    include_objects dbms_cloud_oci_database_migration_database_object_tbl,
    vault_details dbms_cloud_oci_database_migration_create_vault_details_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Connect Descriptor details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_connect_descriptor_t FORCE AUTHID CURRENT_USER IS OBJECT (
  host varchar2(32767),
  port number,
  database_service_name varchar2(32767),
  connect_string varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_connect_descriptor_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_connect_descriptor_t (
    host varchar2,
    port number,
    database_service_name varchar2,
    connect_string varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of the SSH key that will be used.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_ssh_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  host varchar2(32767),
  l_user varchar2(32767),
  sudo_location varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_ssh_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_ssh_details_t (
    host varchar2,
    l_user varchar2,
    sudo_location varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

OCI Private Endpoint configuration details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_private_endpoint_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  vcn_id varchar2(32767),
  subnet_id varchar2(32767),
  id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_private_endpoint_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_private_endpoint_details_t (
    compartment_id varchar2,
    vcn_id varchar2,
    subnet_id varchar2,
    id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

OCI Vault details to store migration and connection credentials secrets

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_vault_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  vault_id varchar2(32767),
  key_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_vault_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_vault_details_t (
    compartment_id varchar2,
    vault_id varchar2,
    key_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Database Connection resource used for migrations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_connection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  database_type varchar2(32767),
  manual_database_sub_type varchar2(32767),
  is_dedicated number,
  display_name varchar2(32767),
  database_id varchar2(32767),
  connect_descriptor dbms_cloud_oci_database_migration_connect_descriptor_t,
  credentials_secret_id varchar2(32767),
  certificate_tdn varchar2(32767),
  ssh_details dbms_cloud_oci_database_migration_ssh_details_t,
  admin_credentials dbms_cloud_oci_database_migration_admin_credentials_t,
  replication_credentials dbms_cloud_oci_database_migration_admin_credentials_t,
  private_endpoint dbms_cloud_oci_database_migration_private_endpoint_details_t,
  vault_details dbms_cloud_oci_database_migration_vault_details_t,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  nsg_ids dbms_cloud_oci_database_migration_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_connection_t (
    id varchar2,
    compartment_id varchar2,
    database_type varchar2,
    manual_database_sub_type varchar2,
    is_dedicated number,
    display_name varchar2,
    database_id varchar2,
    connect_descriptor dbms_cloud_oci_database_migration_connect_descriptor_t,
    credentials_secret_id varchar2,
    certificate_tdn varchar2,
    ssh_details dbms_cloud_oci_database_migration_ssh_details_t,
    admin_credentials dbms_cloud_oci_database_migration_admin_credentials_t,
    replication_credentials dbms_cloud_oci_database_migration_admin_credentials_t,
    private_endpoint dbms_cloud_oci_database_migration_private_endpoint_details_t,
    vault_details dbms_cloud_oci_database_migration_vault_details_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    nsg_ids dbms_cloud_oci_database_migration_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Database Connection Summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_connection_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  database_type varchar2(32767),
  manual_database_sub_type varchar2(32767),
  is_dedicated number,
  display_name varchar2(32767),
  database_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  nsg_ids dbms_cloud_oci_database_migration_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_connection_summary_t (
    id varchar2,
    compartment_id varchar2,
    database_type varchar2,
    manual_database_sub_type varchar2,
    is_dedicated number,
    display_name varchar2,
    database_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    nsg_ids dbms_cloud_oci_database_migration_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_connection_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_connection_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_connection_summary_t) NOT PERSISTABLE;

Results of a Database Connection search. Contains DatabaseConnectionSummary items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_connection_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_migration_connection_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_connection_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_connection_collection_t (
    items dbms_cloud_oci_database_migration_connection_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Migration tablespace settings.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  target_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t (
    target_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Migration tablespace settings valid for ADB-D target type using auto create feature.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_adb_dedicated_auto_create_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t (
  is_auto_create number,
  is_big_file number,
  extend_size_in_m_bs number,
  block_size_in_k_bs varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_adb_dedicated_auto_create_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_adb_dedicated_auto_create_tablespace_details_t (
    target_type varchar2,
    is_auto_create number,
    is_big_file number,
    extend_size_in_m_bs number,
    block_size_in_k_bs varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_create_adb_dedicated_auto_create_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t type.

Fields

Migration tablespace settings valid for ADB-D target type using remap feature.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_adb_dedicated_remap_target_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t (
  remap_target varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_adb_dedicated_remap_target_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_adb_dedicated_remap_target_tablespace_details_t (
    target_type varchar2,
    remap_target varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_create_adb_dedicated_remap_target_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t type.

Fields

Migration tablespace settings valid for ADB-S target type using remap feature.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_adb_serverles_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_adb_serverles_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_adb_serverles_tablespace_details_t (
    target_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_create_adb_serverles_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t type.

Database Administrator Credentials details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_admin_credentials_t FORCE AUTHID CURRENT_USER IS OBJECT (
  username varchar2(32767),
  password varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_admin_credentials_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_admin_credentials_t (
    username varchar2,
    password varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional Pre-Migration advisor settings.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_advisor_settings_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_skip_advisor number,
  is_ignore_errors number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_advisor_settings_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_advisor_settings_t (
    is_skip_advisor number,
    is_ignore_errors number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

AWS S3 bucket details used for source Connection resources with RDS_ORACLE type. Only supported for source Connection resources with RDS_ORACLE type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_aws_s3_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  l_region varchar2(32767),
  access_key_id varchar2(32767),
  secret_access_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_aws_s3_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_aws_s3_details_t (
    name varchar2,
    l_region varchar2,
    access_key_id varchar2,
    secret_access_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Connect Descriptor details. Required for Manual and UserManagerOci connection types. If a Private Endpoint was specified for the Connection, the host should contain a valid IP address.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_connect_descriptor_t FORCE AUTHID CURRENT_USER IS OBJECT (
  host varchar2(32767),
  port number,
  database_service_name varchar2(32767),
  connect_string varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_connect_descriptor_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_connect_descriptor_t (
    host varchar2,
    port number,
    database_service_name varchar2,
    connect_string varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of the SSH key that will be used. Required for source database Manual and UserManagerOci connection types. Not required for source container database connections.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_ssh_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  host varchar2(32767),
  sshkey varchar2(32767),
  l_user varchar2(32767),
  sudo_location varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_ssh_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_ssh_details_t (
    host varchar2,
    sshkey varchar2,
    l_user varchar2,
    sudo_location varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

OCI Private Endpoint configuration details. Not required for source container database connections, it will default to the specified Source Database Connection Private Endpoint.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_private_endpoint_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  vcn_id varchar2(32767),
  subnet_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_private_endpoint_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_private_endpoint_t (
    compartment_id varchar2,
    vcn_id varchar2,
    subnet_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to create a Database Connection resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_connection_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  database_type varchar2(32767),
  manual_database_sub_type varchar2(32767),
  database_id varchar2(32767),
  connect_descriptor dbms_cloud_oci_database_migration_create_connect_descriptor_t,
  certificate_tdn varchar2(32767),
  tls_wallet varchar2(32767),
  tls_keystore varchar2(32767),
  ssh_details dbms_cloud_oci_database_migration_create_ssh_details_t,
  admin_credentials dbms_cloud_oci_database_migration_create_admin_credentials_t,
  replication_credentials dbms_cloud_oci_database_migration_create_admin_credentials_t,
  private_endpoint dbms_cloud_oci_database_migration_create_private_endpoint_t,
  vault_details dbms_cloud_oci_database_migration_create_vault_details_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  nsg_ids dbms_cloud_oci_database_migration_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_connection_details_t (
    compartment_id varchar2,
    display_name varchar2,
    database_type varchar2,
    manual_database_sub_type varchar2,
    database_id varchar2,
    connect_descriptor dbms_cloud_oci_database_migration_create_connect_descriptor_t,
    certificate_tdn varchar2,
    tls_wallet varchar2,
    tls_keystore varchar2,
    ssh_details dbms_cloud_oci_database_migration_create_ssh_details_t,
    admin_credentials dbms_cloud_oci_database_migration_create_admin_credentials_t,
    replication_credentials dbms_cloud_oci_database_migration_create_admin_credentials_t,
    private_endpoint dbms_cloud_oci_database_migration_create_private_endpoint_t,
    vault_details dbms_cloud_oci_database_migration_create_vault_details_t,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    nsg_ids dbms_cloud_oci_database_migration_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional additional properties for dump transfer in source or target host. Default kind is CURL

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_host_dump_transfer_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  wallet_location varchar2(32767),
  kind varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_host_dump_transfer_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_host_dump_transfer_details_t (
    wallet_location varchar2,
    kind varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Optional properties for Curl-based dump transfer in source or target host.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_curl_transfer_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_create_host_dump_transfer_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_curl_transfer_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_curl_transfer_details_t (
    wallet_location varchar2,
    kind varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_create_curl_transfer_details_t is a subtype of the dbms_cloud_oci_database_migration_create_host_dump_transfer_details_t type.

Optional parameters for Data Pump Export and Import.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_data_pump_parameters_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_cluster number,
  estimate varchar2(32767),
  table_exists_action varchar2(32767),
  exclude_parameters dbms_cloud_oci_database_migration_varchar2_tbl,
  import_parallelism_degree number,
  export_parallelism_degree number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_data_pump_parameters_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_data_pump_parameters_t (
    is_cluster number,
    estimate varchar2,
    table_exists_action varchar2,
    exclude_parameters dbms_cloud_oci_database_migration_varchar2_tbl,
    import_parallelism_degree number,
    export_parallelism_degree number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Defines remapping to be applied to objects as they are processed. Refer to METADATA_REMAP Procedure

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_metadata_remap_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  old_value varchar2(32767),
  new_value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_metadata_remap_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_metadata_remap_t (
    l_type varchar2,
    old_value varchar2,
    new_value varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_directory_object_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  path varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_directory_object_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_directory_object_t (
    name varchar2,
    path varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_metadata_remap_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_metadata_remap_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_metadata_remap_t) NOT PERSISTABLE;

Optional settings for Data Pump Export and Import jobs

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_data_pump_settings_t FORCE AUTHID CURRENT_USER IS OBJECT (
  job_mode varchar2(32767),
  data_pump_parameters dbms_cloud_oci_database_migration_create_data_pump_parameters_t,
  metadata_remaps dbms_cloud_oci_database_migration_metadata_remap_tbl,
  tablespace_details dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t,
  export_directory_object dbms_cloud_oci_database_migration_create_directory_object_t,
  import_directory_object dbms_cloud_oci_database_migration_create_directory_object_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_data_pump_settings_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_data_pump_settings_t (
    job_mode varchar2,
    data_pump_parameters dbms_cloud_oci_database_migration_create_data_pump_parameters_t,
    metadata_remaps dbms_cloud_oci_database_migration_metadata_remap_tbl,
    tablespace_details dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t,
    export_directory_object dbms_cloud_oci_database_migration_create_directory_object_t,
    import_directory_object dbms_cloud_oci_database_migration_create_directory_object_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

In lieu of a network database link, OCI Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_object_store_bucket_t FORCE AUTHID CURRENT_USER IS OBJECT (
  namespace_name varchar2(32767),
  bucket_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_object_store_bucket_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_object_store_bucket_t (
    namespace_name varchar2,
    bucket_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional details for creating a network database link from OCI database to on-premise database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_database_link_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  wallet_bucket dbms_cloud_oci_database_migration_create_object_store_bucket_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_database_link_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_database_link_details_t (
    name varchar2,
    wallet_bucket dbms_cloud_oci_database_migration_create_object_store_bucket_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Data Transfer Medium details for the Migration. If not specified, it will default to Database Link. Only one type of data transfer medium can be specified, except for the case of Amazon RDS Oracle as source, where Object Storage Details along with AwsS3Details are required.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_data_transfer_medium_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  database_link_details dbms_cloud_oci_database_migration_create_database_link_details_t,
  object_storage_details dbms_cloud_oci_database_migration_create_object_store_bucket_t,
  aws_s3_details dbms_cloud_oci_database_migration_create_aws_s3_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_data_transfer_medium_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_data_transfer_medium_details_t (
    database_link_details dbms_cloud_oci_database_migration_create_database_link_details_t,
    object_storage_details dbms_cloud_oci_database_migration_create_object_store_bucket_t,
    aws_s3_details dbms_cloud_oci_database_migration_create_aws_s3_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional additional properties for dump transfer.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_dump_transfer_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  source dbms_cloud_oci_database_migration_create_host_dump_transfer_details_t,
  target dbms_cloud_oci_database_migration_create_host_dump_transfer_details_t,
  shared_storage_mount_target_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_dump_transfer_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_dump_transfer_details_t (
    source dbms_cloud_oci_database_migration_create_host_dump_transfer_details_t,
    target dbms_cloud_oci_database_migration_create_host_dump_transfer_details_t,
    shared_storage_mount_target_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Parameters for GoldenGate Extract processes.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_extract_t FORCE AUTHID CURRENT_USER IS OBJECT (
  performance_profile varchar2(32767),
  long_trans_duration number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_extract_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_extract_t (
    performance_profile varchar2,
    long_trans_duration number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about Oracle GoldenGate Microservices. Required for online logical migration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_golden_gate_hub_t FORCE AUTHID CURRENT_USER IS OBJECT (
  rest_admin_credentials dbms_cloud_oci_database_migration_create_admin_credentials_t,
  source_db_admin_credentials dbms_cloud_oci_database_migration_create_admin_credentials_t,
  source_container_db_admin_credentials dbms_cloud_oci_database_migration_create_admin_credentials_t,
  target_db_admin_credentials dbms_cloud_oci_database_migration_create_admin_credentials_t,
  url varchar2(32767),
  source_microservices_deployment_name varchar2(32767),
  target_microservices_deployment_name varchar2(32767),
  compute_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_golden_gate_hub_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_golden_gate_hub_t (
    rest_admin_credentials dbms_cloud_oci_database_migration_create_admin_credentials_t,
    source_db_admin_credentials dbms_cloud_oci_database_migration_create_admin_credentials_t,
    source_container_db_admin_credentials dbms_cloud_oci_database_migration_create_admin_credentials_t,
    target_db_admin_credentials dbms_cloud_oci_database_migration_create_admin_credentials_t,
    url varchar2,
    source_microservices_deployment_name varchar2,
    target_microservices_deployment_name varchar2,
    compute_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Parameters for GoldenGate Replicat processes.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_replicat_t FORCE AUTHID CURRENT_USER IS OBJECT (
  performance_profile varchar2(32767),
  map_parallelism number,
  min_apply_parallelism number,
  max_apply_parallelism number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_replicat_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_replicat_t (
    performance_profile varchar2,
    map_parallelism number,
    min_apply_parallelism number,
    max_apply_parallelism number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional settings for GoldenGate Microservices processes

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_golden_gate_settings_t FORCE AUTHID CURRENT_USER IS OBJECT (
  extract dbms_cloud_oci_database_migration_create_extract_t,
  replicat dbms_cloud_oci_database_migration_create_replicat_t,
  acceptable_lag number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_golden_gate_settings_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_golden_gate_settings_t (
    extract dbms_cloud_oci_database_migration_create_extract_t,
    replicat dbms_cloud_oci_database_migration_create_replicat_t,
    acceptable_lag number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about Oracle GoldenGate Microservices. Required for online logical migration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_golden_gate_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  hub dbms_cloud_oci_database_migration_create_golden_gate_hub_t,
  settings dbms_cloud_oci_database_migration_create_golden_gate_settings_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_golden_gate_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_golden_gate_details_t (
    hub dbms_cloud_oci_database_migration_create_golden_gate_hub_t,
    settings dbms_cloud_oci_database_migration_create_golden_gate_settings_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Database Credentials details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_database_credentials_t FORCE AUTHID CURRENT_USER IS OBJECT (
  username varchar2(32767),
  password varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_database_credentials_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_database_credentials_t (
    username varchar2,
    password varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about Oracle GoldenGate GGS Deployment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_golden_gate_service_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  source_db_credentials dbms_cloud_oci_database_migration_database_credentials_t,
  source_container_db_credentials dbms_cloud_oci_database_migration_database_credentials_t,
  target_db_credentials dbms_cloud_oci_database_migration_database_credentials_t,
  settings dbms_cloud_oci_database_migration_create_golden_gate_settings_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_golden_gate_service_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_golden_gate_service_details_t (
    source_db_credentials dbms_cloud_oci_database_migration_database_credentials_t,
    source_container_db_credentials dbms_cloud_oci_database_migration_database_credentials_t,
    target_db_credentials dbms_cloud_oci_database_migration_database_credentials_t,
    settings dbms_cloud_oci_database_migration_create_golden_gate_settings_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Create Migration resource parameters.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_migration_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  agent_id varchar2(32767),
  source_database_connection_id varchar2(32767),
  source_container_database_connection_id varchar2(32767),
  target_database_connection_id varchar2(32767),
  data_transfer_medium_details_v2 dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t,
  data_transfer_medium_details dbms_cloud_oci_database_migration_create_data_transfer_medium_details_t,
  dump_transfer_details dbms_cloud_oci_database_migration_create_dump_transfer_details_t,
  datapump_settings dbms_cloud_oci_database_migration_create_data_pump_settings_t,
  advisor_settings dbms_cloud_oci_database_migration_create_advisor_settings_t,
  exclude_objects dbms_cloud_oci_database_migration_database_object_tbl,
  include_objects dbms_cloud_oci_database_migration_database_object_tbl,
  csv_text varchar2(32767),
  golden_gate_details dbms_cloud_oci_database_migration_create_golden_gate_details_t,
  golden_gate_service_details dbms_cloud_oci_database_migration_create_golden_gate_service_details_t,
  vault_details dbms_cloud_oci_database_migration_create_vault_details_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_migration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_migration_details_t (
    l_type varchar2,
    display_name varchar2,
    compartment_id varchar2,
    agent_id varchar2,
    source_database_connection_id varchar2,
    source_container_database_connection_id varchar2,
    target_database_connection_id varchar2,
    data_transfer_medium_details_v2 dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t,
    data_transfer_medium_details dbms_cloud_oci_database_migration_create_data_transfer_medium_details_t,
    dump_transfer_details dbms_cloud_oci_database_migration_create_dump_transfer_details_t,
    datapump_settings dbms_cloud_oci_database_migration_create_data_pump_settings_t,
    advisor_settings dbms_cloud_oci_database_migration_create_advisor_settings_t,
    exclude_objects dbms_cloud_oci_database_migration_database_object_tbl,
    include_objects dbms_cloud_oci_database_migration_database_object_tbl,
    csv_text varchar2,
    golden_gate_details dbms_cloud_oci_database_migration_create_golden_gate_details_t,
    golden_gate_service_details dbms_cloud_oci_database_migration_create_golden_gate_service_details_t,
    vault_details dbms_cloud_oci_database_migration_create_vault_details_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Migration tablespace settings valid for NON-ADB target type using auto create feature.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_non_adb_auto_create_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t (
  is_auto_create number,
  is_big_file number,
  extend_size_in_m_bs number,
  block_size_in_k_bs varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_non_adb_auto_create_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_non_adb_auto_create_tablespace_details_t (
    target_type varchar2,
    is_auto_create number,
    is_big_file number,
    extend_size_in_m_bs number,
    block_size_in_k_bs varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_create_non_adb_auto_create_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t type.

Fields

Migration tablespace settings valid for NON-ADB target type using remap feature.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_non_adb_remap_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t (
  remap_target varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_non_adb_remap_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_non_adb_remap_tablespace_details_t (
    target_type varchar2,
    remap_target varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_create_non_adb_remap_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_create_target_type_tablespace_details_t type.

Fields

Optional dump transfer details for OCI-CLI-based dump transfer in source or target host.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_create_oci_cli_dump_transfer_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_create_host_dump_transfer_details_t (
  oci_home varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_oci_cli_dump_transfer_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_create_oci_cli_dump_transfer_details_t (
    wallet_location varchar2,
    kind varchar2,
    oci_home varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_create_oci_cli_dump_transfer_details_t is a subtype of the dbms_cloud_oci_database_migration_create_host_dump_transfer_details_t type.

Fields

Optional additional properties for dump transfer in source or target host. Default kind is CURL

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_host_dump_transfer_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  wallet_location varchar2(32767),
  kind varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_host_dump_transfer_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_host_dump_transfer_details_t (
    wallet_location varchar2,
    kind varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Optional properties for Curl-based dump transfer in source or target host.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_curl_transfer_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_host_dump_transfer_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_curl_transfer_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_curl_transfer_details_t (
    wallet_location varchar2,
    kind varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_curl_transfer_details_t is a subtype of the dbms_cloud_oci_database_migration_host_dump_transfer_details_t type.

Optional parameters for Data Pump Export and Import.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_data_pump_parameters_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_cluster number,
  estimate varchar2(32767),
  table_exists_action varchar2(32767),
  exclude_parameters dbms_cloud_oci_database_migration_varchar2_tbl,
  import_parallelism_degree number,
  export_parallelism_degree number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_data_pump_parameters_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_data_pump_parameters_t (
    is_cluster number,
    estimate varchar2,
    table_exists_action varchar2,
    exclude_parameters dbms_cloud_oci_database_migration_varchar2_tbl,
    import_parallelism_degree number,
    export_parallelism_degree number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Directory object details, used to define either import or export directory objects in Data Pump Settings.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_directory_object_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  path varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_directory_object_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_directory_object_t (
    name varchar2,
    path varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional settings for Data Pump Export and Import jobs

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_data_pump_settings_t FORCE AUTHID CURRENT_USER IS OBJECT (
  job_mode varchar2(32767),
  data_pump_parameters dbms_cloud_oci_database_migration_data_pump_parameters_t,
  metadata_remaps dbms_cloud_oci_database_migration_metadata_remap_tbl,
  tablespace_details dbms_cloud_oci_database_migration_target_type_tablespace_details_t,
  export_directory_object dbms_cloud_oci_database_migration_directory_object_t,
  import_directory_object dbms_cloud_oci_database_migration_directory_object_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_data_pump_settings_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_data_pump_settings_t (
    job_mode varchar2,
    data_pump_parameters dbms_cloud_oci_database_migration_data_pump_parameters_t,
    metadata_remaps dbms_cloud_oci_database_migration_metadata_remap_tbl,
    tablespace_details dbms_cloud_oci_database_migration_target_type_tablespace_details_t,
    export_directory_object dbms_cloud_oci_database_migration_directory_object_t,
    import_directory_object dbms_cloud_oci_database_migration_directory_object_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

In lieu of a network database link, OCI Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_object_store_bucket_t FORCE AUTHID CURRENT_USER IS OBJECT (
  namespace_name varchar2(32767),
  bucket_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_object_store_bucket_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_object_store_bucket_t (
    namespace_name varchar2,
    bucket_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional details for creating a network database link from OCI database to on-premise database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_database_link_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  wallet_bucket dbms_cloud_oci_database_migration_object_store_bucket_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_database_link_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_database_link_details_t (
    name varchar2,
    wallet_bucket dbms_cloud_oci_database_migration_object_store_bucket_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Data Transfer Medium details for the Migration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_data_transfer_medium_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  database_link_details dbms_cloud_oci_database_migration_database_link_details_t,
  object_storage_details dbms_cloud_oci_database_migration_object_store_bucket_t,
  aws_s3_details dbms_cloud_oci_database_migration_aws_s3_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_data_transfer_medium_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_data_transfer_medium_details_t (
    database_link_details dbms_cloud_oci_database_migration_database_link_details_t,
    object_storage_details dbms_cloud_oci_database_migration_object_store_bucket_t,
    aws_s3_details dbms_cloud_oci_database_migration_aws_s3_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional details for creating a network database link from OCI database to on-premise database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_db_link_data_transfer_medium_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t (
  object_storage_bucket dbms_cloud_oci_database_migration_object_store_bucket_t,
  name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_db_link_data_transfer_medium_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_db_link_data_transfer_medium_details_t (
    l_type varchar2,
    object_storage_bucket dbms_cloud_oci_database_migration_object_store_bucket_t,
    name varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_db_link_data_transfer_medium_details_t is a subtype of the dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t type.

Fields

Error Information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_result_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  issue varchar2(32767),
  action varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_result_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_result_error_t (
    code varchar2,
    message varchar2,
    issue varchar2,
    action varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Result from Database Connection Diagnostic action.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_diagnostics_result_t FORCE AUTHID CURRENT_USER IS OBJECT (
  result_type varchar2(32767),
  error dbms_cloud_oci_database_migration_result_error_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_diagnostics_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_diagnostics_result_t (
    result_type varchar2,
    error dbms_cloud_oci_database_migration_result_error_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional additional properties for dump transfer.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_dump_transfer_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  source dbms_cloud_oci_database_migration_host_dump_transfer_details_t,
  target dbms_cloud_oci_database_migration_host_dump_transfer_details_t,
  shared_storage_mount_target_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_dump_transfer_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_dump_transfer_details_t (
    source dbms_cloud_oci_database_migration_host_dump_transfer_details_t,
    target dbms_cloud_oci_database_migration_host_dump_transfer_details_t,
    shared_storage_mount_target_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Error Information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_error_t (
    code varchar2,
    message varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Excluded object summary line.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_excluded_object_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  owner varchar2(32767),
  object varchar2(32767),
  l_type varchar2(32767),
  reason_category varchar2(32767),
  source_rule varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_excluded_object_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_excluded_object_summary_t (
    owner varchar2,
    object varchar2,
    l_type varchar2,
    reason_category varchar2,
    source_rule varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_excluded_object_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_excluded_object_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_excluded_object_summary_t) NOT PERSISTABLE;

Results of a Job's Exclude objects output listing. Contains ExcludedObjectSummary items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_excluded_object_summary_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_migration_excluded_object_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_excluded_object_summary_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_excluded_object_summary_collection_t (
    items dbms_cloud_oci_database_migration_excluded_object_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Parameters for Extract processes.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_extract_t FORCE AUTHID CURRENT_USER IS OBJECT (
  performance_profile varchar2(32767),
  long_trans_duration number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_extract_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_extract_t (
    performance_profile varchar2,
    long_trans_duration number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about Oracle GoldenGate GGS Deployment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_ggs_deployment_t FORCE AUTHID CURRENT_USER IS OBJECT (
  deployment_id varchar2(32767),
  ggs_admin_credentials_secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_ggs_deployment_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_ggs_deployment_t (
    deployment_id varchar2,
    ggs_admin_credentials_secret_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about Oracle GoldenGate Microservices.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_golden_gate_hub_t FORCE AUTHID CURRENT_USER IS OBJECT (
  rest_admin_credentials dbms_cloud_oci_database_migration_admin_credentials_t,
  source_db_admin_credentials dbms_cloud_oci_database_migration_admin_credentials_t,
  source_container_db_admin_credentials dbms_cloud_oci_database_migration_admin_credentials_t,
  target_db_admin_credentials dbms_cloud_oci_database_migration_admin_credentials_t,
  url varchar2(32767),
  source_microservices_deployment_name varchar2(32767),
  target_microservices_deployment_name varchar2(32767),
  compute_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_golden_gate_hub_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_golden_gate_hub_t (
    rest_admin_credentials dbms_cloud_oci_database_migration_admin_credentials_t,
    source_db_admin_credentials dbms_cloud_oci_database_migration_admin_credentials_t,
    source_container_db_admin_credentials dbms_cloud_oci_database_migration_admin_credentials_t,
    target_db_admin_credentials dbms_cloud_oci_database_migration_admin_credentials_t,
    url varchar2,
    source_microservices_deployment_name varchar2,
    target_microservices_deployment_name varchar2,
    compute_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Parameters for Replicat processes.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_replicat_t FORCE AUTHID CURRENT_USER IS OBJECT (
  performance_profile varchar2(32767),
  map_parallelism number,
  min_apply_parallelism number,
  max_apply_parallelism number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_replicat_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_replicat_t (
    performance_profile varchar2,
    map_parallelism number,
    min_apply_parallelism number,
    max_apply_parallelism number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional settings for Oracle GoldenGate processes

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_golden_gate_settings_t FORCE AUTHID CURRENT_USER IS OBJECT (
  extract dbms_cloud_oci_database_migration_extract_t,
  replicat dbms_cloud_oci_database_migration_replicat_t,
  acceptable_lag number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_golden_gate_settings_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_golden_gate_settings_t (
    extract dbms_cloud_oci_database_migration_extract_t,
    replicat dbms_cloud_oci_database_migration_replicat_t,
    acceptable_lag number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about Oracle GoldenGate Microservices.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_golden_gate_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  hub dbms_cloud_oci_database_migration_golden_gate_hub_t,
  settings dbms_cloud_oci_database_migration_golden_gate_settings_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_golden_gate_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_golden_gate_details_t (
    hub dbms_cloud_oci_database_migration_golden_gate_hub_t,
    settings dbms_cloud_oci_database_migration_golden_gate_settings_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about Oracle GoldenGate GGS Deployment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_golden_gate_service_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  ggs_deployment dbms_cloud_oci_database_migration_ggs_deployment_t,
  settings dbms_cloud_oci_database_migration_golden_gate_settings_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_golden_gate_service_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_golden_gate_service_details_t (
    ggs_deployment dbms_cloud_oci_database_migration_ggs_deployment_t,
    settings dbms_cloud_oci_database_migration_golden_gate_settings_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Job phase extract message.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_phase_extract_entry_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  message varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_phase_extract_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_phase_extract_entry_t (
    l_type varchar2,
    message varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to access log file in the specified Object Storage bucket, if any.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_log_location_bucket_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  bucket_name varchar2(32767),
  namespace varchar2(32767),
  object_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_log_location_bucket_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_log_location_bucket_details_t (
    bucket_name varchar2,
    namespace varchar2,
    object_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_phase_extract_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_phase_extract_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_phase_extract_entry_t) NOT PERSISTABLE;

Job phase status details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_phase_status_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  status varchar2(32767),
  duration_in_ms number,
  is_advisor_report_available number,
  issue varchar2(32767),
  action varchar2(32767),
  extract dbms_cloud_oci_database_migration_phase_extract_entry_tbl,
  log_location dbms_cloud_oci_database_migration_log_location_bucket_details_t,
  progress number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_phase_status_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_phase_status_t (
    name varchar2,
    status varchar2,
    duration_in_ms number,
    is_advisor_report_available number,
    issue varchar2,
    action varchar2,
    extract dbms_cloud_oci_database_migration_phase_extract_entry_tbl,
    log_location dbms_cloud_oci_database_migration_log_location_bucket_details_t,
    progress number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_phase_status_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_phase_status_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_phase_status_t) NOT PERSISTABLE;

Progress details of a Migration Job.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_job_progress_resource_t FORCE AUTHID CURRENT_USER IS OBJECT (
  current_status varchar2(32767),
  current_phase varchar2(32767),
  phases dbms_cloud_oci_database_migration_phase_status_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_job_progress_resource_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_job_progress_resource_t (
    current_status varchar2,
    current_phase varchar2,
    phases dbms_cloud_oci_database_migration_phase_status_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Database objects to exclude from migration

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_unsupported_database_object_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  owner varchar2(32767),
  object_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_unsupported_database_object_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_unsupported_database_object_t (
    l_type varchar2,
    owner varchar2,
    object_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_unsupported_database_object_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_unsupported_database_object_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_unsupported_database_object_t) NOT PERSISTABLE;

Results of a Database Connection search. Contains DatabaseConnectionSummary items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_job_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  migration_id varchar2(32767),
  l_type varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  progress dbms_cloud_oci_database_migration_migration_job_progress_resource_t,
  unsupported_objects dbms_cloud_oci_database_migration_unsupported_database_object_tbl,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_job_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_job_t (
    id varchar2,
    display_name varchar2,
    migration_id varchar2,
    l_type varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    progress dbms_cloud_oci_database_migration_migration_job_progress_resource_t,
    unsupported_objects dbms_cloud_oci_database_migration_unsupported_database_object_tbl,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the progress of a Migration Job.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_job_progress_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  current_phase varchar2(32767),
  current_status varchar2(32767),
  job_progress number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_job_progress_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_job_progress_summary_t (
    current_phase varchar2,
    current_status varchar2,
    job_progress number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Job description

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_job_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  migration_id varchar2(32767),
  l_type varchar2(32767),
  progress dbms_cloud_oci_database_migration_migration_job_progress_summary_t,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_job_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_job_summary_t (
    id varchar2,
    display_name varchar2,
    migration_id varchar2,
    l_type varchar2,
    progress dbms_cloud_oci_database_migration_migration_job_progress_summary_t,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_job_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_job_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_job_summary_t) NOT PERSISTABLE;

Results of a Job search. Contains JobSummary items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_job_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_migration_job_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_job_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_job_collection_t (
    items dbms_cloud_oci_database_migration_job_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Job output summary line.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_job_output_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  message varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_job_output_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_job_output_summary_t (
    message varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_job_output_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_job_output_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_job_output_summary_t) NOT PERSISTABLE;

Results of a Job output listing. Contains JobOutputSummary items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_job_output_summary_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_migration_job_output_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_job_output_summary_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_job_output_summary_collection_t (
    items dbms_cloud_oci_database_migration_job_output_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Migration resource

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  l_type varchar2(32767),
  wait_after varchar2(32767),
  agent_id varchar2(32767),
  credentials_secret_id varchar2(32767),
  source_database_connection_id varchar2(32767),
  source_container_database_connection_id varchar2(32767),
  target_database_connection_id varchar2(32767),
  executing_job_id varchar2(32767),
  data_transfer_medium_details_v2 dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t,
  data_transfer_medium_details dbms_cloud_oci_database_migration_data_transfer_medium_details_t,
  dump_transfer_details dbms_cloud_oci_database_migration_dump_transfer_details_t,
  datapump_settings dbms_cloud_oci_database_migration_data_pump_settings_t,
  advisor_settings dbms_cloud_oci_database_migration_advisor_settings_t,
  exclude_objects dbms_cloud_oci_database_migration_database_object_tbl,
  include_objects dbms_cloud_oci_database_migration_database_object_tbl,
  golden_gate_service_details dbms_cloud_oci_database_migration_golden_gate_service_details_t,
  golden_gate_details dbms_cloud_oci_database_migration_golden_gate_details_t,
  vault_details dbms_cloud_oci_database_migration_vault_details_t,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  time_last_migration timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    l_type varchar2,
    wait_after varchar2,
    agent_id varchar2,
    credentials_secret_id varchar2,
    source_database_connection_id varchar2,
    source_container_database_connection_id varchar2,
    target_database_connection_id varchar2,
    executing_job_id varchar2,
    data_transfer_medium_details_v2 dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t,
    data_transfer_medium_details dbms_cloud_oci_database_migration_data_transfer_medium_details_t,
    dump_transfer_details dbms_cloud_oci_database_migration_dump_transfer_details_t,
    datapump_settings dbms_cloud_oci_database_migration_data_pump_settings_t,
    advisor_settings dbms_cloud_oci_database_migration_advisor_settings_t,
    exclude_objects dbms_cloud_oci_database_migration_database_object_tbl,
    include_objects dbms_cloud_oci_database_migration_database_object_tbl,
    golden_gate_service_details dbms_cloud_oci_database_migration_golden_gate_service_details_t,
    golden_gate_details dbms_cloud_oci_database_migration_golden_gate_details_t,
    vault_details dbms_cloud_oci_database_migration_vault_details_t,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    time_last_migration timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Migration resource

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  l_type varchar2(32767),
  source_database_connection_id varchar2(32767),
  source_container_database_connection_id varchar2(32767),
  target_database_connection_id varchar2(32767),
  executing_job_id varchar2(32767),
  agent_id varchar2(32767),
  vault_details dbms_cloud_oci_database_migration_vault_details_t,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  time_last_migration timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_summary_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    l_type varchar2,
    source_database_connection_id varchar2,
    source_container_database_connection_id varchar2,
    target_database_connection_id varchar2,
    executing_job_id varchar2,
    agent_id varchar2,
    vault_details dbms_cloud_oci_database_migration_vault_details_t,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    time_last_migration timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_migration_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_migration_summary_t) NOT PERSISTABLE;

Results of a Migration search. Contains MigrationSummary items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_migration_migration_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_collection_t (
    items dbms_cloud_oci_database_migration_migration_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Database objects to include or exclude from migration

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_object_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  owner varchar2(32767),
  object_name varchar2(32767),
  l_type varchar2(32767),
  object_status varchar2(32767),
  is_omit_excluded_table_from_replication number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_object_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_object_summary_t (
    owner varchar2,
    object_name varchar2,
    l_type varchar2,
    object_status varchar2,
    is_omit_excluded_table_from_replication number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_migration_object_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_object_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_migration_object_summary_t) NOT PERSISTABLE;

Database objects to migrate.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_object_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_migration_migration_object_summary_tbl,
  csv_text varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_object_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_object_collection_t (
    items dbms_cloud_oci_database_migration_migration_object_summary_tbl,
    csv_text varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Migration Object Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_object_type_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_object_type_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_object_type_summary_t (
    name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_migration_object_type_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_object_type_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_migration_object_type_summary_t) NOT PERSISTABLE;

Results of a Migration Object Type listing. Contains MigrationObjectTypeSummary items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_object_type_summary_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_migration_migration_object_type_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_object_type_summary_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_object_type_summary_collection_t (
    items dbms_cloud_oci_database_migration_migration_object_type_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Migration Phase Summary of details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_phase_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  recommended_action varchar2(32767),
  supported_actions dbms_cloud_oci_database_migration_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_phase_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_phase_summary_t (
    name varchar2,
    recommended_action varchar2,
    supported_actions dbms_cloud_oci_database_migration_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_migration_phase_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_phase_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_migration_phase_summary_t) NOT PERSISTABLE;

Results of a Migration Phase search. Contains a collection of valid ODMS Job Phases.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_migration_phase_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_migration_migration_phase_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_phase_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_migration_phase_collection_t (
    items dbms_cloud_oci_database_migration_migration_phase_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

OCI Object Storage bucket will be used to store Data Pump dump files for the migration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_nfs_data_transfer_medium_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_nfs_data_transfer_medium_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_nfs_data_transfer_medium_details_t (
    l_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_nfs_data_transfer_medium_details_t is a subtype of the dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t type.

Migration tablespace settings valid for NON-ADB target type using auto create feature.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_non_adb_auto_create_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_target_type_tablespace_details_t (
  is_auto_create number,
  is_big_file number,
  extend_size_in_m_bs number,
  block_size_in_k_bs varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_non_adb_auto_create_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_non_adb_auto_create_tablespace_details_t (
    target_type varchar2,
    is_auto_create number,
    is_big_file number,
    extend_size_in_m_bs number,
    block_size_in_k_bs varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_non_adb_auto_create_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_target_type_tablespace_details_t type.

Fields

Migration tablespace settings valid for NON-ADB target type using remap feature

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_non_adb_remap_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_target_type_tablespace_details_t (
  remap_target varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_non_adb_remap_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_non_adb_remap_tablespace_details_t (
    target_type varchar2,
    remap_target varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_non_adb_remap_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_target_type_tablespace_details_t type.

Fields

OCI Object Storage bucket will be used to store Data Pump dump files for the migration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_object_storage_data_transfer_medium_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t (
  object_storage_bucket dbms_cloud_oci_database_migration_object_store_bucket_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_object_storage_data_transfer_medium_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_object_storage_data_transfer_medium_details_t (
    l_type varchar2,
    object_storage_bucket dbms_cloud_oci_database_migration_object_store_bucket_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_object_storage_data_transfer_medium_details_t is a subtype of the dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t type.

Fields

Optional dump transfer details for OCI-CLI-based dump transfer in source or target host.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_oci_cli_dump_transfer_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_host_dump_transfer_details_t (
  oci_home varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_oci_cli_dump_transfer_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_oci_cli_dump_transfer_details_t (
    wallet_location varchar2,
    kind varchar2,
    oci_home varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_oci_cli_dump_transfer_details_t is a subtype of the dbms_cloud_oci_database_migration_host_dump_transfer_details_t type.

Fields

Parameters to specify to resume a Migration Job.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_resume_job_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  wait_after varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_resume_job_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_resume_job_details_t (
    wait_after varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Parameters to specify to a Migration job operation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_start_migration_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  wait_after varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_start_migration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_start_migration_details_t (
    wait_after varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Migration tablespace settings.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  target_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t (
    target_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Migration tablespace settings valid for ADB-D target type using auto create feature.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_adb_dedicated_auto_create_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t (
  is_auto_create number,
  is_big_file number,
  extend_size_in_m_bs number,
  block_size_in_k_bs varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_adb_dedicated_auto_create_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_adb_dedicated_auto_create_tablespace_details_t (
    target_type varchar2,
    is_auto_create number,
    is_big_file number,
    extend_size_in_m_bs number,
    block_size_in_k_bs varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_update_adb_dedicated_auto_create_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t type.

Fields

Migration tablespace settings valid for ADB-D target type using remap target.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_adb_dedicated_remap_target_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t (
  remap_target varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_adb_dedicated_remap_target_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_adb_dedicated_remap_target_tablespace_details_t (
    target_type varchar2,
    remap_target varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_update_adb_dedicated_remap_target_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t type.

Fields

Migration tablespace settings valid for ADB-S target type using remap feature.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_adb_serverles_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_adb_serverles_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_adb_serverles_tablespace_details_t (
    target_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_update_adb_serverles_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t type.

Database Administrator Credentials details. An empty object would result in the removal of the stored details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_admin_credentials_t FORCE AUTHID CURRENT_USER IS OBJECT (
  username varchar2(32767),
  password varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_admin_credentials_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_admin_credentials_t (
    username varchar2,
    password varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional Pre-Migration advisor settings.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_advisor_settings_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_skip_advisor number,
  is_ignore_errors number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_advisor_settings_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_advisor_settings_t (
    is_skip_advisor number,
    is_ignore_errors number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

ODMS Agent Details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_agent_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  stream_id varchar2(32767),
  public_key varchar2(32767),
  version varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_agent_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_agent_details_t (
    display_name varchar2,
    stream_id varchar2,
    public_key varchar2,
    version varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

AWS S3 bucket details used for source Connection resources with RDS_ORACLE type. Only supported for source Connection resources with RDS_ORACLE type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_aws_s3_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  l_region varchar2(32767),
  access_key_id varchar2(32767),
  secret_access_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_aws_s3_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_aws_s3_details_t (
    name varchar2,
    l_region varchar2,
    access_key_id varchar2,
    secret_access_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Connect Descriptor details. If a Private Endpoint was specified in the Connection, the host entry should be a valid IP address.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_connect_descriptor_t FORCE AUTHID CURRENT_USER IS OBJECT (
  host varchar2(32767),
  port number,
  database_service_name varchar2(32767),
  connect_string varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_connect_descriptor_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_connect_descriptor_t (
    host varchar2,
    port number,
    database_service_name varchar2,
    connect_string varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of the SSH key that will be used.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_ssh_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  host varchar2(32767),
  sshkey varchar2(32767),
  l_user varchar2(32767),
  sudo_location varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_ssh_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_ssh_details_t (
    host varchar2,
    sshkey varchar2,
    l_user varchar2,
    sudo_location varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

OCI Private Endpoint configuration details. An empty object would result in the removal of the stored details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_private_endpoint_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  vcn_id varchar2(32767),
  subnet_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_private_endpoint_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_private_endpoint_t (
    compartment_id varchar2,
    vcn_id varchar2,
    subnet_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

OCI Vault details to store migration and connection credentials secrets. An empty object would result in the removal of the stored details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_vault_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  vault_id varchar2(32767),
  key_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_vault_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_vault_details_t (
    compartment_id varchar2,
    vault_id varchar2,
    key_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to update in a Database Connection resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_connection_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  database_id varchar2(32767),
  connect_descriptor dbms_cloud_oci_database_migration_update_connect_descriptor_t,
  certificate_tdn varchar2(32767),
  tls_wallet varchar2(32767),
  tls_keystore varchar2(32767),
  ssh_details dbms_cloud_oci_database_migration_update_ssh_details_t,
  admin_credentials dbms_cloud_oci_database_migration_update_admin_credentials_t,
  replication_credentials dbms_cloud_oci_database_migration_update_admin_credentials_t,
  private_endpoint dbms_cloud_oci_database_migration_update_private_endpoint_t,
  vault_details dbms_cloud_oci_database_migration_update_vault_details_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  nsg_ids dbms_cloud_oci_database_migration_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_connection_details_t (
    display_name varchar2,
    database_id varchar2,
    connect_descriptor dbms_cloud_oci_database_migration_update_connect_descriptor_t,
    certificate_tdn varchar2,
    tls_wallet varchar2,
    tls_keystore varchar2,
    ssh_details dbms_cloud_oci_database_migration_update_ssh_details_t,
    admin_credentials dbms_cloud_oci_database_migration_update_admin_credentials_t,
    replication_credentials dbms_cloud_oci_database_migration_update_admin_credentials_t,
    private_endpoint dbms_cloud_oci_database_migration_update_private_endpoint_t,
    vault_details dbms_cloud_oci_database_migration_update_vault_details_t,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    nsg_ids dbms_cloud_oci_database_migration_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional additional properties for dump transfer in source or target host. Default kind is CURL

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_host_dump_transfer_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  wallet_location varchar2(32767),
  kind varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_host_dump_transfer_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_host_dump_transfer_details_t (
    wallet_location varchar2,
    kind varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Optional properties for Curl-based dump transfer in source or target host.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_curl_transfer_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_update_host_dump_transfer_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_curl_transfer_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_curl_transfer_details_t (
    wallet_location varchar2,
    kind varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_update_curl_transfer_details_t is a subtype of the dbms_cloud_oci_database_migration_update_host_dump_transfer_details_t type.

Optional parameters for Data Pump Export and Import. If an empty object is specified, the stored Data Pump Parameter details will be removed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_data_pump_parameters_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_cluster number,
  estimate varchar2(32767),
  table_exists_action varchar2(32767),
  exclude_parameters dbms_cloud_oci_database_migration_varchar2_tbl,
  import_parallelism_degree number,
  export_parallelism_degree number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_data_pump_parameters_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_data_pump_parameters_t (
    is_cluster number,
    estimate varchar2,
    table_exists_action varchar2,
    exclude_parameters dbms_cloud_oci_database_migration_varchar2_tbl,
    import_parallelism_degree number,
    export_parallelism_degree number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified. If an empty object is specified, the stored Directory Object details will be removed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_directory_object_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  path varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_directory_object_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_directory_object_t (
    name varchar2,
    path varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional settings for Data Pump Export and Import jobs

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_data_pump_settings_t FORCE AUTHID CURRENT_USER IS OBJECT (
  job_mode varchar2(32767),
  data_pump_parameters dbms_cloud_oci_database_migration_update_data_pump_parameters_t,
  metadata_remaps dbms_cloud_oci_database_migration_metadata_remap_tbl,
  tablespace_details dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t,
  export_directory_object dbms_cloud_oci_database_migration_update_directory_object_t,
  import_directory_object dbms_cloud_oci_database_migration_update_directory_object_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_data_pump_settings_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_data_pump_settings_t (
    job_mode varchar2,
    data_pump_parameters dbms_cloud_oci_database_migration_update_data_pump_parameters_t,
    metadata_remaps dbms_cloud_oci_database_migration_metadata_remap_tbl,
    tablespace_details dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t,
    export_directory_object dbms_cloud_oci_database_migration_update_directory_object_t,
    import_directory_object dbms_cloud_oci_database_migration_update_directory_object_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

OCI Object Storage bucket details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_object_store_bucket_t FORCE AUTHID CURRENT_USER IS OBJECT (
  namespace_name varchar2(32767),
  bucket_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_object_store_bucket_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_object_store_bucket_t (
    namespace_name varchar2,
    bucket_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional details for updating a network database link from OCI database to on-premise database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_database_link_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  wallet_bucket dbms_cloud_oci_database_migration_update_object_store_bucket_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_database_link_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_database_link_details_t (
    name varchar2,
    wallet_bucket dbms_cloud_oci_database_migration_update_object_store_bucket_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Data Transfer Medium details for the Migration. Only one type of data transfer medium can be specified, except for the case of Amazon RDS Oracle as source, where Object Storage Details along with AwsS3Details are required. If an empty object is specified, the stored Data Transfer Medium details will be removed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_data_transfer_medium_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  database_link_details dbms_cloud_oci_database_migration_update_database_link_details_t,
  object_storage_details dbms_cloud_oci_database_migration_update_object_store_bucket_t,
  aws_s3_details dbms_cloud_oci_database_migration_update_aws_s3_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_data_transfer_medium_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_data_transfer_medium_details_t (
    database_link_details dbms_cloud_oci_database_migration_update_database_link_details_t,
    object_storage_details dbms_cloud_oci_database_migration_update_object_store_bucket_t,
    aws_s3_details dbms_cloud_oci_database_migration_update_aws_s3_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional additional properties for dump transfer.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_dump_transfer_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  source dbms_cloud_oci_database_migration_update_host_dump_transfer_details_t,
  target dbms_cloud_oci_database_migration_update_host_dump_transfer_details_t,
  shared_storage_mount_target_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_dump_transfer_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_dump_transfer_details_t (
    source dbms_cloud_oci_database_migration_update_host_dump_transfer_details_t,
    target dbms_cloud_oci_database_migration_update_host_dump_transfer_details_t,
    shared_storage_mount_target_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Parameters for Extract processes. If an empty object is specified, the stored Extract details will be removed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_extract_t FORCE AUTHID CURRENT_USER IS OBJECT (
  performance_profile varchar2(32767),
  long_trans_duration number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_extract_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_extract_t (
    performance_profile varchar2,
    long_trans_duration number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about Oracle GoldenGate Microservices.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_golden_gate_hub_t FORCE AUTHID CURRENT_USER IS OBJECT (
  rest_admin_credentials dbms_cloud_oci_database_migration_update_admin_credentials_t,
  source_db_admin_credentials dbms_cloud_oci_database_migration_update_admin_credentials_t,
  source_container_db_admin_credentials dbms_cloud_oci_database_migration_update_admin_credentials_t,
  target_db_admin_credentials dbms_cloud_oci_database_migration_update_admin_credentials_t,
  url varchar2(32767),
  source_microservices_deployment_name varchar2(32767),
  target_microservices_deployment_name varchar2(32767),
  compute_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_golden_gate_hub_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_golden_gate_hub_t (
    rest_admin_credentials dbms_cloud_oci_database_migration_update_admin_credentials_t,
    source_db_admin_credentials dbms_cloud_oci_database_migration_update_admin_credentials_t,
    source_container_db_admin_credentials dbms_cloud_oci_database_migration_update_admin_credentials_t,
    target_db_admin_credentials dbms_cloud_oci_database_migration_update_admin_credentials_t,
    url varchar2,
    source_microservices_deployment_name varchar2,
    target_microservices_deployment_name varchar2,
    compute_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Parameters for Replicat processes. If an empty object is specified, the stored Replicat details will be removed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_replicat_t FORCE AUTHID CURRENT_USER IS OBJECT (
  performance_profile varchar2(32767),
  map_parallelism number,
  min_apply_parallelism number,
  max_apply_parallelism number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_replicat_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_replicat_t (
    performance_profile varchar2,
    map_parallelism number,
    min_apply_parallelism number,
    max_apply_parallelism number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional settings for Oracle GoldenGate processes If an empty object is specified, the stored GoldenGate Settings details will be removed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_golden_gate_settings_t FORCE AUTHID CURRENT_USER IS OBJECT (
  extract dbms_cloud_oci_database_migration_update_extract_t,
  replicat dbms_cloud_oci_database_migration_update_replicat_t,
  acceptable_lag number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_golden_gate_settings_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_golden_gate_settings_t (
    extract dbms_cloud_oci_database_migration_update_extract_t,
    replicat dbms_cloud_oci_database_migration_update_replicat_t,
    acceptable_lag number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about Oracle GoldenGate Microservices. If an empty object is specified, the stored Golden Gate details will be removed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_golden_gate_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  hub dbms_cloud_oci_database_migration_update_golden_gate_hub_t,
  settings dbms_cloud_oci_database_migration_update_golden_gate_settings_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_golden_gate_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_golden_gate_details_t (
    hub dbms_cloud_oci_database_migration_update_golden_gate_hub_t,
    settings dbms_cloud_oci_database_migration_update_golden_gate_settings_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about the Oracle GoldenGate Microservices. If an empty object is specified, the stored Golden Gate details will be removed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_golden_gate_service_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  source_db_credentials dbms_cloud_oci_database_migration_database_credentials_t,
  source_container_db_credentials dbms_cloud_oci_database_migration_database_credentials_t,
  target_db_credentials dbms_cloud_oci_database_migration_database_credentials_t,
  settings dbms_cloud_oci_database_migration_update_golden_gate_settings_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_golden_gate_service_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_golden_gate_service_details_t (
    source_db_credentials dbms_cloud_oci_database_migration_database_credentials_t,
    source_container_db_credentials dbms_cloud_oci_database_migration_database_credentials_t,
    target_db_credentials dbms_cloud_oci_database_migration_database_credentials_t,
    settings dbms_cloud_oci_database_migration_update_golden_gate_settings_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Update Job Details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_job_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_job_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_job_details_t (
    display_name varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Update Migration resource parameters.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_migration_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  display_name varchar2(32767),
  agent_id varchar2(32767),
  source_database_connection_id varchar2(32767),
  source_container_database_connection_id varchar2(32767),
  target_database_connection_id varchar2(32767),
  data_transfer_medium_details_v2 dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t,
  data_transfer_medium_details dbms_cloud_oci_database_migration_update_data_transfer_medium_details_t,
  dump_transfer_details dbms_cloud_oci_database_migration_update_dump_transfer_details_t,
  datapump_settings dbms_cloud_oci_database_migration_update_data_pump_settings_t,
  advisor_settings dbms_cloud_oci_database_migration_update_advisor_settings_t,
  exclude_objects dbms_cloud_oci_database_migration_database_object_tbl,
  include_objects dbms_cloud_oci_database_migration_database_object_tbl,
  golden_gate_service_details dbms_cloud_oci_database_migration_update_golden_gate_service_details_t,
  golden_gate_details dbms_cloud_oci_database_migration_update_golden_gate_details_t,
  vault_details dbms_cloud_oci_database_migration_update_vault_details_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_migration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_migration_details_t (
    l_type varchar2,
    display_name varchar2,
    agent_id varchar2,
    source_database_connection_id varchar2,
    source_container_database_connection_id varchar2,
    target_database_connection_id varchar2,
    data_transfer_medium_details_v2 dbms_cloud_oci_database_migration_data_transfer_medium_details_v2_t,
    data_transfer_medium_details dbms_cloud_oci_database_migration_update_data_transfer_medium_details_t,
    dump_transfer_details dbms_cloud_oci_database_migration_update_dump_transfer_details_t,
    datapump_settings dbms_cloud_oci_database_migration_update_data_pump_settings_t,
    advisor_settings dbms_cloud_oci_database_migration_update_advisor_settings_t,
    exclude_objects dbms_cloud_oci_database_migration_database_object_tbl,
    include_objects dbms_cloud_oci_database_migration_database_object_tbl,
    golden_gate_service_details dbms_cloud_oci_database_migration_update_golden_gate_service_details_t,
    golden_gate_details dbms_cloud_oci_database_migration_update_golden_gate_details_t,
    vault_details dbms_cloud_oci_database_migration_update_vault_details_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Migration tablespace settings valid for NON-ADB target type using auto create feature.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_non_adb_auto_create_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t (
  is_auto_create number,
  is_big_file number,
  extend_size_in_m_bs number,
  block_size_in_k_bs varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_non_adb_auto_create_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_non_adb_auto_create_tablespace_details_t (
    target_type varchar2,
    is_auto_create number,
    is_big_file number,
    extend_size_in_m_bs number,
    block_size_in_k_bs varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_update_non_adb_auto_create_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t type.

Fields

Migration tablespace settings valid for NON-ADB target type using remap feature.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_non_adb_remap_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t (
  remap_target varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_non_adb_remap_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_non_adb_remap_tablespace_details_t (
    target_type varchar2,
    remap_target varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_update_non_adb_remap_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t type.

Fields

Optional dump transfer details for OCI-CLI-based dump transfer in source or target host.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_oci_cli_dump_transfer_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_update_host_dump_transfer_details_t (
  oci_home varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_oci_cli_dump_transfer_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_oci_cli_dump_transfer_details_t (
    wallet_location varchar2,
    kind varchar2,
    oci_home varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_update_oci_cli_dump_transfer_details_t is a subtype of the dbms_cloud_oci_database_migration_update_host_dump_transfer_details_t type.

Fields

Migration tablespace settings valid for TARGET_DEFAULTS_AUTOCREATE target type. The service will compute the targetType that corresponds to the targetDatabaseConnectionId type, and set the corresponding default values. When target type is ADB_D or NON_ADB the default will be set to auto-create feature ADB_D_AUTOCREATE or NON_ADB_AUTOCREATE.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_target_defaults_auto_create_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_target_defaults_auto_create_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_target_defaults_auto_create_tablespace_details_t (
    target_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_update_target_defaults_auto_create_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t type.

Migration tablespace settings valid for TARGET_DEFAULTS_REMAP target type. The service will compute the targetType that corresponds to the targetDatabaseConnectionId type, and set the corresponding default values. When target type is ADB_S, ADB_D or NON_ADB the default will be set to remap feature ADB_S_REMAP, ADB_D_REMAP or NON_ADB_REMAP.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_update_target_defaults_remap_tablespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_target_defaults_remap_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_update_target_defaults_remap_tablespace_details_t (
    target_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_migration_update_target_defaults_remap_tablespace_details_t is a subtype of the dbms_cloud_oci_database_migration_update_target_type_tablespace_details_t type.

A resource that is created or operated on by an asynchronous operation that is tracked by a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_work_request_resource_t FORCE AUTHID CURRENT_USER IS OBJECT (
  action_type varchar2(32767),
  entity_type varchar2(32767),
  identifier varchar2(32767),
  entity_uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_resource_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_resource_t (
    action_type varchar2,
    entity_type varchar2,
    identifier varchar2,
    entity_uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_work_request_resource_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_work_request_resource_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_work_request_resource_t) NOT PERSISTABLE;

An asynchronous work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_work_request_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operation_type varchar2(32767),
  status varchar2(32767),
  id varchar2(32767),
  compartment_id varchar2(32767),
  resources dbms_cloud_oci_database_migration_work_request_resource_tbl,
  percent_complete number,
  time_accepted timestamp with time zone,
  time_started timestamp with time zone,
  time_finished timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_database_migration_work_request_resource_tbl,
    percent_complete number,
    time_accepted timestamp with time zone,
    time_started timestamp with time zone,
    time_finished timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A summary of the status of a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_work_request_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operation_type varchar2(32767),
  status varchar2(32767),
  id varchar2(32767),
  compartment_id varchar2(32767),
  percent_complete number,
  time_accepted timestamp with time zone,
  time_started timestamp with time zone,
  time_finished timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_summary_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    percent_complete number,
    time_accepted timestamp with time zone,
    time_started timestamp with time zone,
    time_finished timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_work_request_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_work_request_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_work_request_summary_t) NOT PERSISTABLE;

Results of a Work Request search. Contains WorkRequestSummary items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_work_request_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_migration_work_request_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_collection_t (
    items dbms_cloud_oci_database_migration_work_request_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

An error encountered while executing an operation that is tracked by a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_work_request_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  l_timestamp timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_error_t (
    code varchar2,
    message varchar2,
    l_timestamp timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_work_request_error_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_work_request_error_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_work_request_error_t) NOT PERSISTABLE;

Results of a Work Request search. Contains WorkRequestError items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_work_request_error_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_migration_work_request_error_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_error_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_error_collection_t (
    items dbms_cloud_oci_database_migration_work_request_error_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A log message from executing an operation that is tracked by a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_work_request_log_entry_t FORCE AUTHID CURRENT_USER IS OBJECT (
  message varchar2(32767),
  l_timestamp timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_log_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_log_entry_t (
    message varchar2,
    l_timestamp timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_migration_work_request_log_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_work_request_log_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_migration_work_request_log_entry_t) NOT PERSISTABLE;

Results of a Work Request search. Contains WorkRequestLogEntry items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_migration_work_request_log_entry_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_migration_work_request_log_entry_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_log_entry_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_migration_work_request_log_entry_collection_t (
    items dbms_cloud_oci_database_migration_work_request_log_entry_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields