Nested table type of varchar2(32767).

Syntax

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

Private Endpoint IP Addresses created in the customer's subnet. GoldenGate service will use these ingress IP addresses to send all specific requests initiated from the service. These are typically used for accessing customer resources.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_golden_gate_ingress_ip_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_ingress_ip_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_ingress_ip_details_t) NOT PERSISTABLE;

Represents the metadata description of a connection used by deployments in the same compartment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_connection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  connection_type varchar2(32767),
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  vault_id varchar2(32767),
  key_id varchar2(32767),
  ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
  nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
  subnet_id varchar2(32767),
  routing_method varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Represents the metadata of a Amazon Kinesis Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_amazon_kinesis_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  access_key_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_amazon_kinesis_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_amazon_kinesis_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    access_key_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_amazon_kinesis_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_connection_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  connection_type varchar2(32767),
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  vault_id varchar2(32767),
  key_id varchar2(32767),
  ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
  nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
  subnet_id varchar2(32767),
  routing_method varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Summary of the Amazon Kinesis Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_amazon_kinesis_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  access_key_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_amazon_kinesis_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_amazon_kinesis_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    access_key_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_amazon_kinesis_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Represents the metadata of a Amazon Redshift Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_amazon_redshift_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  connection_url varchar2(32767),
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_amazon_redshift_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_amazon_redshift_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    connection_url varchar2,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_amazon_redshift_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Amazon Redshift Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_amazon_redshift_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  connection_url varchar2(32767),
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_amazon_redshift_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_amazon_redshift_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    connection_url varchar2,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_amazon_redshift_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Represents the metadata of a Amazon S3 Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_amazon_s3_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  access_key_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_amazon_s3_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_amazon_s3_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    access_key_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_amazon_s3_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Amazon S3 Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_amazon_s3_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  access_key_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_amazon_s3_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_amazon_s3_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    access_key_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_amazon_s3_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Represents the metadata of a Azure Data Lake Storage Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_azure_data_lake_storage_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  authentication_type varchar2(32767),
  account_name varchar2(32767),
  azure_tenant_id varchar2(32767),
  client_id varchar2(32767),
  endpoint varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_azure_data_lake_storage_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_azure_data_lake_storage_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    authentication_type varchar2,
    account_name varchar2,
    azure_tenant_id varchar2,
    client_id varchar2,
    endpoint varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_azure_data_lake_storage_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Azure Data Lake Storage Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_azure_data_lake_storage_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  authentication_type varchar2(32767),
  account_name varchar2(32767),
  azure_tenant_id varchar2(32767),
  client_id varchar2(32767),
  endpoint varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_azure_data_lake_storage_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_azure_data_lake_storage_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    authentication_type varchar2,
    account_name varchar2,
    azure_tenant_id varchar2,
    client_id varchar2,
    endpoint varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_azure_data_lake_storage_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Represents the metadata of a Azure Synapse Analytics Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_azure_synapse_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  connection_string varchar2(32767),
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_azure_synapse_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_azure_synapse_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    connection_string varchar2,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_azure_synapse_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Azure Synapse Analytics Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_azure_synapse_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  connection_string varchar2(32767),
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_azure_synapse_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_azure_synapse_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    connection_string varchar2,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_azure_synapse_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

The information about the Cancel for a DeploymentBackup.

Syntax

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

Fields

The information about canceling.

Syntax

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

Fields

The information about snooze canceling.

Syntax

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

Fields

Certificate data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_certificate_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  deployment_id varchar2(32767),
  certificate_content varchar2(32767),
  issuer varchar2(32767),
  is_self_signed number,
  md5_hash varchar2(32767),
  public_key varchar2(32767),
  public_key_algorithm varchar2(32767),
  public_key_size number,
  serial varchar2(32767),
  subject varchar2(32767),
  time_valid_from timestamp with time zone,
  time_valid_to timestamp with time zone,
  version varchar2(32767),
  sha1_hash varchar2(32767),
  authority_key_id varchar2(32767),
  is_ca number,
  subject_key_id varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_certificate_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_certificate_t (
    key varchar2,
    deployment_id varchar2,
    certificate_content varchar2,
    issuer varchar2,
    is_self_signed number,
    md5_hash varchar2,
    public_key varchar2,
    public_key_algorithm varchar2,
    public_key_size number,
    serial varchar2,
    subject varchar2,
    time_valid_from timestamp with time zone,
    time_valid_to timestamp with time zone,
    version varchar2,
    sha1_hash varchar2,
    authority_key_id varchar2,
    is_ca number,
    subject_key_id varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the Certificates.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_certificate_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  lifecycle_state varchar2(32767),
  subject varchar2(32767),
  is_self_signed number,
  time_valid_to timestamp with time zone,
  time_created timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_certificate_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_certificate_summary_t (
    key varchar2,
    lifecycle_state varchar2,
    subject varchar2,
    is_self_signed number,
    time_valid_to timestamp with time zone,
    time_created timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_golden_gate_certificate_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_certificate_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_certificate_summary_t) NOT PERSISTABLE;

A list of Certificates.

Syntax

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

Fields

The new compartment for a Connection.

Syntax

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

Fields

The new compartment for a DatabaseRegistration.

Syntax

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

Fields

The new compartment for a DeploymentBackup.

Syntax

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

Fields

The new compartment for a Deployment.

Syntax

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

Fields

Details for collecting deployment diagnostic

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_collect_deployment_diagnostic_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  namespace_name varchar2(32767),
  bucket_name varchar2(32767),
  diagnostic_name_prefix varchar2(32767),
  time_diagnostic_start timestamp with time zone,
  time_diagnostic_end timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_collect_deployment_diagnostic_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_collect_deployment_diagnostic_details_t (
    namespace_name varchar2,
    bucket_name varchar2,
    diagnostic_name_prefix varchar2,
    time_diagnostic_start timestamp with time zone,
    time_diagnostic_end timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Represents the metadata description of a connection assignment. Before you can use a connection as a GoldenGate source or target, you must assign it to a deployment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_connection_assignment_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  connection_id varchar2(32767),
  deployment_id varchar2(32767),
  alias_name varchar2(32767),
  compartment_id varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_connection_assignment_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_connection_assignment_t (
    id varchar2,
    connection_id varchar2,
    deployment_id varchar2,
    alias_name varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the Connection Assignment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_connection_assignment_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  connection_id varchar2(32767),
  deployment_id varchar2(32767),
  alias_name varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_connection_assignment_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_connection_assignment_summary_t (
    id varchar2,
    compartment_id varchar2,
    connection_id varchar2,
    deployment_id varchar2,
    alias_name varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_golden_gate_connection_assignment_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_connection_assignment_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_connection_assignment_summary_t) NOT PERSISTABLE;

List of connection summary objects.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_golden_gate_connection_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_connection_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_connection_summary_t) NOT PERSISTABLE;

List of connection summary objects.

Syntax

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

Fields

The information about the copy for a Deployment Backup.

Syntax

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

Fields

The information about a new Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_connection_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  connection_type varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  vault_id varchar2(32767),
  key_id varchar2(32767),
  nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
  subnet_id varchar2(32767),
  routing_method varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The information about a new Amazon Kinesis Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_amazon_kinesis_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  access_key_id varchar2(32767),
  secret_access_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_amazon_kinesis_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_amazon_kinesis_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    access_key_id varchar2,
    secret_access_key varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_amazon_kinesis_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Amazon Redshift Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_amazon_redshift_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  connection_url varchar2(32767),
  username varchar2(32767),
  password varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_amazon_redshift_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_amazon_redshift_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    connection_url varchar2,
    username varchar2,
    password varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_amazon_redshift_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Amazon S3 Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_amazon_s3_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  access_key_id varchar2(32767),
  secret_access_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_amazon_s3_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_amazon_s3_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    access_key_id varchar2,
    secret_access_key varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_amazon_s3_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Azure Data Lake Storage Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_azure_data_lake_storage_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  authentication_type varchar2(32767),
  account_name varchar2(32767),
  account_key varchar2(32767),
  sas_token varchar2(32767),
  azure_tenant_id varchar2(32767),
  client_id varchar2(32767),
  client_secret varchar2(32767),
  endpoint varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_azure_data_lake_storage_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_azure_data_lake_storage_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    authentication_type varchar2,
    account_name varchar2,
    account_key varchar2,
    sas_token varchar2,
    azure_tenant_id varchar2,
    client_id varchar2,
    client_secret varchar2,
    endpoint varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_azure_data_lake_storage_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Azure Synapse Analytics Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_azure_synapse_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  connection_string varchar2(32767),
  username varchar2(32767),
  password varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_azure_synapse_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_azure_synapse_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    connection_string varchar2,
    username varchar2,
    password varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_azure_synapse_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Certificates.

Syntax

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

Fields

The information about a new Connection Assignment.

Syntax

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

Fields

The information about a new DatabaseRegistration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_database_registration_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  fqdn varchar2(32767),
  ip_address varchar2(32767),
  subnet_id varchar2(32767),
  database_id varchar2(32767),
  username varchar2(32767),
  password varchar2(32767),
  connection_string varchar2(32767),
  session_mode varchar2(32767),
  wallet varchar2(32767),
  alias_name varchar2(32767),
  vault_id varchar2(32767),
  key_id varchar2(32767),
  secret_compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_database_registration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_database_registration_details_t (
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    fqdn varchar2,
    ip_address varchar2,
    subnet_id varchar2,
    database_id varchar2,
    username varchar2,
    password varchar2,
    connection_string varchar2,
    session_mode varchar2,
    wallet varchar2,
    alias_name varchar2,
    vault_id varchar2,
    key_id varchar2,
    secret_compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about a new DeploymentBackup.

Syntax

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

Fields

Deployment Data for creating an OggDeployment

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_ogg_deployment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  deployment_name varchar2(32767),
  credential_store varchar2(32767),
  identity_domain_id varchar2(32767),
  password_secret_id varchar2(32767),
  admin_username varchar2(32767),
  admin_password varchar2(32767),
  certificate varchar2(32767),
  key varchar2(32767),
  ogg_version varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_ogg_deployment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_ogg_deployment_details_t (
    deployment_name varchar2,
    credential_store varchar2,
    identity_domain_id varchar2,
    password_secret_id varchar2,
    admin_username varchar2,
    admin_password varchar2,
    certificate varchar2,
    key varchar2,
    ogg_version varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Defines the maintenance window for create operation, when automatic actions can be performed.

Syntax

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

Fields

Defines the maintenance configuration for create operation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_maintenance_configuration_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_interim_release_auto_upgrade_enabled number,
  interim_release_upgrade_period_in_days number,
  bundle_release_upgrade_period_in_days number,
  major_release_upgrade_period_in_days number,
  security_patch_upgrade_period_in_days number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_maintenance_configuration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_maintenance_configuration_details_t (
    is_interim_release_auto_upgrade_enabled number,
    interim_release_upgrade_period_in_days number,
    bundle_release_upgrade_period_in_days number,
    major_release_upgrade_period_in_days number,
    security_patch_upgrade_period_in_days number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about a new Deployment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_deployment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  license_model varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  deployment_backup_id varchar2(32767),
  subnet_id varchar2(32767),
  load_balancer_subnet_id varchar2(32767),
  fqdn varchar2(32767),
  nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
  is_public number,
  cpu_core_count number,
  is_auto_scaling_enabled number,
  deployment_type varchar2(32767),
  ogg_data dbms_cloud_oci_golden_gate_create_ogg_deployment_details_t,
  maintenance_window dbms_cloud_oci_golden_gate_create_maintenance_window_details_t,
  maintenance_configuration dbms_cloud_oci_golden_gate_create_maintenance_configuration_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_deployment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_deployment_details_t (
    display_name varchar2,
    license_model varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    deployment_backup_id varchar2,
    subnet_id varchar2,
    load_balancer_subnet_id varchar2,
    fqdn varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    is_public number,
    cpu_core_count number,
    is_auto_scaling_enabled number,
    deployment_type varchar2,
    ogg_data dbms_cloud_oci_golden_gate_create_ogg_deployment_details_t,
    maintenance_window dbms_cloud_oci_golden_gate_create_maintenance_window_details_t,
    maintenance_configuration dbms_cloud_oci_golden_gate_create_maintenance_configuration_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about a new Elasticsearch Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_elasticsearch_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  servers varchar2(32767),
  security_protocol varchar2(32767),
  authentication_type varchar2(32767),
  username varchar2(32767),
  password varchar2(32767),
  fingerprint varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_elasticsearch_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_elasticsearch_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    servers varchar2,
    security_protocol varchar2,
    authentication_type varchar2,
    username varchar2,
    password varchar2,
    fingerprint varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_elasticsearch_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Generic Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_generic_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  host varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_generic_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_generic_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    host varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_generic_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new GoldenGate Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_golden_gate_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  deployment_id varchar2(32767),
  host varchar2(32767),
  port number,
  username varchar2(32767),
  password varchar2(32767),
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_golden_gate_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_golden_gate_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    deployment_id varchar2,
    host varchar2,
    port number,
    username varchar2,
    password varchar2,
    private_ip varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_golden_gate_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Google BigQuery Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_google_big_query_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  service_account_key_file varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_google_big_query_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_google_big_query_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    service_account_key_file varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_google_big_query_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Google Cloud Storage Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_google_cloud_storage_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  service_account_key_file varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_google_cloud_storage_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_google_cloud_storage_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    service_account_key_file varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_google_cloud_storage_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Hadoop Distributed File System Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_hdfs_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  core_site_xml varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_hdfs_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_hdfs_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    core_site_xml varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_hdfs_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Java Message Service Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_java_message_service_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  should_use_jndi number,
  jndi_connection_factory varchar2(32767),
  jndi_provider_url varchar2(32767),
  jndi_initial_context_factory varchar2(32767),
  jndi_security_principal varchar2(32767),
  jndi_security_credentials varchar2(32767),
  connection_url varchar2(32767),
  connection_factory varchar2(32767),
  username varchar2(32767),
  password varchar2(32767),
  security_protocol varchar2(32767),
  authentication_type varchar2(32767),
  trust_store varchar2(32767),
  trust_store_password varchar2(32767),
  key_store varchar2(32767),
  key_store_password varchar2(32767),
  ssl_key_password varchar2(32767),
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_java_message_service_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_java_message_service_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    should_use_jndi number,
    jndi_connection_factory varchar2,
    jndi_provider_url varchar2,
    jndi_initial_context_factory varchar2,
    jndi_security_principal varchar2,
    jndi_security_credentials varchar2,
    connection_url varchar2,
    connection_factory varchar2,
    username varchar2,
    password varchar2,
    security_protocol varchar2,
    authentication_type varchar2,
    trust_store varchar2,
    trust_store_password varchar2,
    key_store varchar2,
    key_store_password varchar2,
    ssl_key_password varchar2,
    private_ip varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_java_message_service_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

Represents a Kafka bootstrap server with host name, optional port defaults to 9092, and an optional private ip.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_golden_gate_kafka_bootstrap_server_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_kafka_bootstrap_server_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_kafka_bootstrap_server_t) NOT PERSISTABLE;

The information about a new Kafka Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_kafka_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  stream_pool_id varchar2(32767),
  bootstrap_servers dbms_cloud_oci_golden_gate_kafka_bootstrap_server_tbl,
  security_protocol varchar2(32767),
  username varchar2(32767),
  password varchar2(32767),
  trust_store varchar2(32767),
  trust_store_password varchar2(32767),
  key_store varchar2(32767),
  key_store_password varchar2(32767),
  ssl_key_password varchar2(32767),
  consumer_properties varchar2(32767),
  producer_properties varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_kafka_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_kafka_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    stream_pool_id varchar2,
    bootstrap_servers dbms_cloud_oci_golden_gate_kafka_bootstrap_server_tbl,
    security_protocol varchar2,
    username varchar2,
    password varchar2,
    trust_store varchar2,
    trust_store_password varchar2,
    key_store varchar2,
    key_store_password varchar2,
    ssl_key_password varchar2,
    consumer_properties varchar2,
    producer_properties varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_kafka_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Kafka (e.g. Confluent) Schema Registry Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_kafka_schema_registry_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  url varchar2(32767),
  authentication_type varchar2(32767),
  username varchar2(32767),
  password varchar2(32767),
  trust_store varchar2(32767),
  trust_store_password varchar2(32767),
  key_store varchar2(32767),
  key_store_password varchar2(32767),
  ssl_key_password varchar2(32767),
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_kafka_schema_registry_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_kafka_schema_registry_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    url varchar2,
    authentication_type varchar2,
    username varchar2,
    password varchar2,
    trust_store varchar2,
    trust_store_password varchar2,
    key_store varchar2,
    key_store_password varchar2,
    ssl_key_password varchar2,
    private_ip varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_kafka_schema_registry_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

A name-value pair representing an attribute entry usable in a list of attributes.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_golden_gate_name_value_pair_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_name_value_pair_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_name_value_pair_t) NOT PERSISTABLE;

The information about a new Microsoft SQL Server Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_microsoft_sqlserver_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  database_name varchar2(32767),
  host varchar2(32767),
  port number,
  username varchar2(32767),
  password varchar2(32767),
  additional_attributes dbms_cloud_oci_golden_gate_name_value_pair_tbl,
  security_protocol varchar2(32767),
  ssl_ca varchar2(32767),
  should_validate_server_certificate number,
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_microsoft_sqlserver_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_microsoft_sqlserver_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    database_name varchar2,
    host varchar2,
    port number,
    username varchar2,
    password varchar2,
    additional_attributes dbms_cloud_oci_golden_gate_name_value_pair_tbl,
    security_protocol varchar2,
    ssl_ca varchar2,
    should_validate_server_certificate number,
    private_ip varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_microsoft_sqlserver_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new MongoDB Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_mongo_db_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  connection_string varchar2(32767),
  username varchar2(32767),
  password varchar2(32767),
  database_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_mongo_db_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_mongo_db_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    connection_string varchar2,
    username varchar2,
    password varchar2,
    database_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_mongo_db_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new MySQL Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_mysql_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  username varchar2(32767),
  password varchar2(32767),
  host varchar2(32767),
  port number,
  database_name varchar2(32767),
  security_protocol varchar2(32767),
  ssl_mode varchar2(32767),
  ssl_ca varchar2(32767),
  ssl_crl varchar2(32767),
  ssl_cert varchar2(32767),
  ssl_key varchar2(32767),
  private_ip varchar2(32767),
  additional_attributes dbms_cloud_oci_golden_gate_name_value_pair_tbl,
  db_system_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_mysql_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_mysql_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    username varchar2,
    password varchar2,
    host varchar2,
    port number,
    database_name varchar2,
    security_protocol varchar2,
    ssl_mode varchar2,
    ssl_ca varchar2,
    ssl_crl varchar2,
    ssl_cert varchar2,
    ssl_key varchar2,
    private_ip varchar2,
    additional_attributes dbms_cloud_oci_golden_gate_name_value_pair_tbl,
    db_system_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_mysql_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new OCI Object Storage Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_oci_object_storage_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  tenancy_id varchar2(32767),
  l_region varchar2(32767),
  user_id varchar2(32767),
  private_key_file varchar2(32767),
  private_key_passphrase varchar2(32767),
  public_key_fingerprint varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_oci_object_storage_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_oci_object_storage_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    tenancy_id varchar2,
    l_region varchar2,
    user_id varchar2,
    private_key_file varchar2,
    private_key_passphrase varchar2,
    public_key_fingerprint varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_oci_object_storage_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Oracle Database Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_oracle_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  username varchar2(32767),
  password varchar2(32767),
  connection_string varchar2(32767),
  wallet varchar2(32767),
  session_mode varchar2(32767),
  private_ip varchar2(32767),
  database_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_oracle_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_oracle_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    username varchar2,
    password varchar2,
    connection_string varchar2,
    wallet varchar2,
    session_mode varchar2,
    private_ip varchar2,
    database_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_oracle_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Oracle NoSQL Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_oracle_nosql_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  tenancy_id varchar2(32767),
  l_region varchar2(32767),
  user_id varchar2(32767),
  private_key_file varchar2(32767),
  private_key_passphrase varchar2(32767),
  public_key_fingerprint varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_oracle_nosql_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_oracle_nosql_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    tenancy_id varchar2,
    l_region varchar2,
    user_id varchar2,
    private_key_file varchar2,
    private_key_passphrase varchar2,
    public_key_fingerprint varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_oracle_nosql_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new PostgreSQL Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_postgresql_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  database_name varchar2(32767),
  host varchar2(32767),
  port number,
  username varchar2(32767),
  password varchar2(32767),
  additional_attributes dbms_cloud_oci_golden_gate_name_value_pair_tbl,
  security_protocol varchar2(32767),
  ssl_mode varchar2(32767),
  ssl_ca varchar2(32767),
  ssl_crl varchar2(32767),
  ssl_cert varchar2(32767),
  ssl_key varchar2(32767),
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_postgresql_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_postgresql_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    database_name varchar2,
    host varchar2,
    port number,
    username varchar2,
    password varchar2,
    additional_attributes dbms_cloud_oci_golden_gate_name_value_pair_tbl,
    security_protocol varchar2,
    ssl_mode varchar2,
    ssl_ca varchar2,
    ssl_crl varchar2,
    ssl_cert varchar2,
    ssl_key varchar2,
    private_ip varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_postgresql_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Redis Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_redis_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  servers varchar2(32767),
  security_protocol varchar2(32767),
  authentication_type varchar2(32767),
  username varchar2(32767),
  password varchar2(32767),
  trust_store varchar2(32767),
  trust_store_password varchar2(32767),
  key_store varchar2(32767),
  key_store_password varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_redis_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_redis_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    servers varchar2,
    security_protocol varchar2,
    authentication_type varchar2,
    username varchar2,
    password varchar2,
    trust_store varchar2,
    trust_store_password varchar2,
    key_store varchar2,
    key_store_password varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_redis_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

The information about a new Snowflake Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_create_snowflake_connection_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_create_connection_details_t (
  technology_type varchar2(32767),
  connection_url varchar2(32767),
  authentication_type varchar2(32767),
  username varchar2(32767),
  password varchar2(32767),
  private_key_file varchar2(32767),
  private_key_passphrase varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_snowflake_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_create_snowflake_connection_details_t (
    connection_type varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    vault_id varchar2,
    key_id varchar2,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    connection_url varchar2,
    authentication_type varchar2,
    username varchar2,
    password varchar2,
    private_key_file varchar2,
    private_key_passphrase varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_create_snowflake_connection_details_t is a subtype of the dbms_cloud_oci_golden_gate_create_connection_details_t type.

Fields

Represents the metadata description of a database used by deployments in the same compartment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_database_registration_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_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,
  fqdn varchar2(32767),
  ip_address varchar2(32767),
  subnet_id varchar2(32767),
  database_id varchar2(32767),
  rce_private_ip varchar2(32767),
  system_tags json_element_t,
  username varchar2(32767),
  connection_string varchar2(32767),
  session_mode varchar2(32767),
  alias_name varchar2(32767),
  vault_id varchar2(32767),
  key_id varchar2(32767),
  secret_compartment_id varchar2(32767),
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_database_registration_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_database_registration_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_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,
    fqdn varchar2,
    ip_address varchar2,
    subnet_id varchar2,
    database_id varchar2,
    rce_private_ip varchar2,
    system_tags json_element_t,
    username varchar2,
    connection_string varchar2,
    session_mode varchar2,
    alias_name varchar2,
    vault_id varchar2,
    key_id varchar2,
    secret_compartment_id varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the DatabaseRegistration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_database_registration_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_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,
  fqdn varchar2(32767),
  subnet_id varchar2(32767),
  system_tags json_element_t,
  database_id varchar2(32767),
  username varchar2(32767),
  connection_string varchar2(32767),
  session_mode varchar2(32767),
  alias_name varchar2(32767),
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_database_registration_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_database_registration_summary_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_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,
    fqdn varchar2,
    subnet_id varchar2,
    system_tags json_element_t,
    database_id varchar2,
    username varchar2,
    connection_string varchar2,
    session_mode varchar2,
    alias_name varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_golden_gate_database_registration_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_database_registration_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_database_registration_summary_t) NOT PERSISTABLE;

A list of DatabaseRegistrations.

Syntax

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

Fields

Definition of the additional attributes for default deployment backup cancel.

Syntax

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

dbms_cloud_oci_golden_gate_default_cancel_deployment_backup_details_t is a subtype of the dbms_cloud_oci_golden_gate_cancel_deployment_backup_details_t type.

Definition of the additional attributes for default deployment upgrade cancel.

Syntax

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

dbms_cloud_oci_golden_gate_default_cancel_deployment_upgrade_details_t is a subtype of the dbms_cloud_oci_golden_gate_cancel_deployment_upgrade_details_t type.

Definition of the additional attributes for default deployment upgrade cancel snooze.

Syntax

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

dbms_cloud_oci_golden_gate_default_cancel_snooze_deployment_upgrade_details_t is a subtype of the dbms_cloud_oci_golden_gate_cancel_snooze_deployment_upgrade_details_t type.

The information to check if a wallet is present in the Deployment.

Syntax

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

Fields

Definition of the additional attributes for default check of a wallet in deployment .

Syntax

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

dbms_cloud_oci_golden_gate_default_deployment_wallet_exists_details_t is a subtype of the dbms_cloud_oci_golden_gate_deployment_wallet_exists_details_t type.

The information about the Restore for a Deployment.

Syntax

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

Fields

Definition of the additional attributes for default deployment restore.

Syntax

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

dbms_cloud_oci_golden_gate_default_restore_deployment_details_t is a subtype of the dbms_cloud_oci_golden_gate_restore_deployment_details_t type.

The information about the rollback of an upgrade.

Syntax

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

Fields

Definition of the additional attributes for default upgrade rollback.

Syntax

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

dbms_cloud_oci_golden_gate_default_rollback_deployment_upgrade_details_t is a subtype of the dbms_cloud_oci_golden_gate_rollback_deployment_upgrade_details_t type.

The information about the snooze for a deployment.

Syntax

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

Fields

Definition of the additional attributes for default deployment upgrade snooze.

Syntax

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

dbms_cloud_oci_golden_gate_default_snooze_deployment_upgrade_details_t is a subtype of the dbms_cloud_oci_golden_gate_snooze_deployment_upgrade_details_t type.

The information about the Start for a Deployment.

Syntax

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

Fields

Definition of the additional attributes for default deployment start.

Syntax

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

dbms_cloud_oci_golden_gate_default_start_deployment_details_t is a subtype of the dbms_cloud_oci_golden_gate_start_deployment_details_t type.

The information about the Stop for a Deployment.

Syntax

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

Fields

Definition of the additional attributes for default deployment stop.

Syntax

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

dbms_cloud_oci_golden_gate_default_stop_deployment_details_t is a subtype of the dbms_cloud_oci_golden_gate_stop_deployment_details_t type.

The information about testing the assigned connection.

Syntax

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

Fields

Definition of the additional attributes for default test of assigned connection.

Syntax

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

dbms_cloud_oci_golden_gate_default_test_connection_assignment_details_t is a subtype of the dbms_cloud_oci_golden_gate_test_connection_assignment_details_t type.

The information about the upgrade for a deployment.

Syntax

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

Fields

Definition of the additional attributes for default deployment upgrade.

Syntax

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

dbms_cloud_oci_golden_gate_default_upgrade_deployment_upgrade_details_t is a subtype of the dbms_cloud_oci_golden_gate_upgrade_deployment_upgrade_details_t type.

Deployment Data for an OggDeployment

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_ogg_deployment_t FORCE AUTHID CURRENT_USER IS OBJECT (
  deployment_name varchar2(32767),
  admin_username varchar2(32767),
  ogg_version varchar2(32767),
  certificate varchar2(32767),
  credential_store varchar2(32767),
  identity_domain_id varchar2(32767),
  password_secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_ogg_deployment_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_ogg_deployment_t (
    deployment_name varchar2,
    admin_username varchar2,
    ogg_version varchar2,
    certificate varchar2,
    credential_store varchar2,
    identity_domain_id varchar2,
    password_secret_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Information regarding the deployment diagnostic collection

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_diagnostic_data_t FORCE AUTHID CURRENT_USER IS OBJECT (
  namespace_name varchar2(32767),
  bucket_name varchar2(32767),
  object_name varchar2(32767),
  diagnostic_state varchar2(32767),
  time_diagnostic_start timestamp with time zone,
  time_diagnostic_end timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_diagnostic_data_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_diagnostic_data_t (
    namespace_name varchar2,
    bucket_name varchar2,
    object_name varchar2,
    diagnostic_state varchar2,
    time_diagnostic_start timestamp with time zone,
    time_diagnostic_end timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Defines the maintenance window, when automatic actions can be performed.

Syntax

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

Fields

Attributes for configuring automatic deployment maintenance.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_maintenance_configuration_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_interim_release_auto_upgrade_enabled number,
  interim_release_upgrade_period_in_days number,
  bundle_release_upgrade_period_in_days number,
  major_release_upgrade_period_in_days number,
  security_patch_upgrade_period_in_days number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_maintenance_configuration_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_maintenance_configuration_t (
    is_interim_release_auto_upgrade_enabled number,
    interim_release_upgrade_period_in_days number,
    bundle_release_upgrade_period_in_days number,
    major_release_upgrade_period_in_days number,
    security_patch_upgrade_period_in_days number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A container for your OCI GoldenGate resources, such as the OCI GoldenGate deployment console.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  deployment_backup_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_sub_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  is_healthy number,
  subnet_id varchar2(32767),
  load_balancer_subnet_id varchar2(32767),
  load_balancer_id varchar2(32767),
  fqdn varchar2(32767),
  license_model varchar2(32767),
  cpu_core_count number,
  is_auto_scaling_enabled number,
  nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
  is_public number,
  public_ip_address varchar2(32767),
  private_ip_address varchar2(32767),
  deployment_url varchar2(32767),
  system_tags json_element_t,
  is_latest_version number,
  time_upgrade_required timestamp with time zone,
  storage_utilization_in_bytes number,
  is_storage_utilization_limit_exceeded number,
  deployment_type varchar2(32767),
  ogg_data dbms_cloud_oci_golden_gate_ogg_deployment_t,
  deployment_diagnostic_data dbms_cloud_oci_golden_gate_deployment_diagnostic_data_t,
  maintenance_window dbms_cloud_oci_golden_gate_maintenance_window_t,
  time_of_next_maintenance timestamp with time zone,
  next_maintenance_action_type varchar2(32767),
  next_maintenance_description varchar2(32767),
  maintenance_configuration dbms_cloud_oci_golden_gate_maintenance_configuration_t,
  time_ogg_version_supported_until timestamp with time zone,
  ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    deployment_backup_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_sub_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    is_healthy number,
    subnet_id varchar2,
    load_balancer_subnet_id varchar2,
    load_balancer_id varchar2,
    fqdn varchar2,
    license_model varchar2,
    cpu_core_count number,
    is_auto_scaling_enabled number,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    is_public number,
    public_ip_address varchar2,
    private_ip_address varchar2,
    deployment_url varchar2,
    system_tags json_element_t,
    is_latest_version number,
    time_upgrade_required timestamp with time zone,
    storage_utilization_in_bytes number,
    is_storage_utilization_limit_exceeded number,
    deployment_type varchar2,
    ogg_data dbms_cloud_oci_golden_gate_ogg_deployment_t,
    deployment_diagnostic_data dbms_cloud_oci_golden_gate_deployment_diagnostic_data_t,
    maintenance_window dbms_cloud_oci_golden_gate_maintenance_window_t,
    time_of_next_maintenance timestamp with time zone,
    next_maintenance_action_type varchar2,
    next_maintenance_description varchar2,
    maintenance_configuration dbms_cloud_oci_golden_gate_maintenance_configuration_t,
    time_ogg_version_supported_until timestamp with time zone,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A backup of the current state of the GoldenGate deployment. Can be used to restore a deployment, or create a new deployment with that state as the starting deployment state.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_backup_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  deployment_id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  is_automatic number,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  time_of_backup timestamp with time zone,
  time_backup_finished timestamp with time zone,
  size_in_bytes number,
  backup_type varchar2(32767),
  ogg_version varchar2(32767),
  namespace_name varchar2(32767),
  bucket_name varchar2(32767),
  object_name 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,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_backup_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_backup_t (
    id varchar2,
    deployment_id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    is_automatic number,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_of_backup timestamp with time zone,
    time_backup_finished timestamp with time zone,
    size_in_bytes number,
    backup_type varchar2,
    ogg_version varchar2,
    namespace_name varchar2,
    bucket_name varchar2,
    object_name 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
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The summary of the Backup.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_backup_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  deployment_id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  is_automatic number,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  time_of_backup timestamp with time zone,
  time_backup_finished timestamp with time zone,
  size_in_bytes number,
  backup_type varchar2(32767),
  ogg_version varchar2(32767),
  namespace_name varchar2(32767),
  bucket_name varchar2(32767),
  object_name 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,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_backup_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_backup_summary_t (
    id varchar2,
    deployment_id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    is_automatic number,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_of_backup timestamp with time zone,
    time_backup_finished timestamp with time zone,
    size_in_bytes number,
    backup_type varchar2,
    ogg_version varchar2,
    namespace_name varchar2,
    bucket_name varchar2,
    object_name 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
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_golden_gate_deployment_backup_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_backup_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_deployment_backup_summary_t) NOT PERSISTABLE;

A list of DeploymentBackups.

Syntax

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

Fields

Summary of the Deployment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_sub_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  subnet_id varchar2(32767),
  load_balancer_subnet_id varchar2(32767),
  load_balancer_id varchar2(32767),
  license_model varchar2(32767),
  fqdn varchar2(32767),
  cpu_core_count number,
  is_auto_scaling_enabled number,
  is_public number,
  public_ip_address varchar2(32767),
  private_ip_address varchar2(32767),
  deployment_url varchar2(32767),
  system_tags json_element_t,
  is_latest_version number,
  time_upgrade_required timestamp with time zone,
  deployment_type varchar2(32767),
  storage_utilization_in_bytes number,
  is_storage_utilization_limit_exceeded number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_summary_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_sub_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    subnet_id varchar2,
    load_balancer_subnet_id varchar2,
    load_balancer_id varchar2,
    license_model varchar2,
    fqdn varchar2,
    cpu_core_count number,
    is_auto_scaling_enabled number,
    is_public number,
    public_ip_address varchar2,
    private_ip_address varchar2,
    deployment_url varchar2,
    system_tags json_element_t,
    is_latest_version number,
    time_upgrade_required timestamp with time zone,
    deployment_type varchar2,
    storage_utilization_in_bytes number,
    is_storage_utilization_limit_exceeded number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_golden_gate_deployment_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_deployment_summary_t) NOT PERSISTABLE;

A list of Deployments.

Syntax

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

Fields

Deployment message Summary.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_golden_gate_message_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_message_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_message_summary_t) NOT PERSISTABLE;

A list of DeploymentMessages.

Syntax

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

Fields

The meta-data specific on particular deployment type represented by deploymentType field.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_type_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  category varchar2(32767),
  display_name varchar2(32767),
  deployment_type varchar2(32767),
  connection_types dbms_cloud_oci_golden_gate_varchar2_tbl,
  source_technologies dbms_cloud_oci_golden_gate_varchar2_tbl,
  target_technologies dbms_cloud_oci_golden_gate_varchar2_tbl,
  ogg_version varchar2(32767),
  supported_technologies_url varchar2(32767),
  default_username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_type_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_type_summary_t (
    category varchar2,
    display_name varchar2,
    deployment_type varchar2,
    connection_types dbms_cloud_oci_golden_gate_varchar2_tbl,
    source_technologies dbms_cloud_oci_golden_gate_varchar2_tbl,
    target_technologies dbms_cloud_oci_golden_gate_varchar2_tbl,
    ogg_version varchar2,
    supported_technologies_url varchar2,
    default_username varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_golden_gate_deployment_type_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_type_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_deployment_type_summary_t) NOT PERSISTABLE;

The list of DeploymentTypeDescriptor objects.

Syntax

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

Fields

A container for your OCI GoldenGate Upgrade information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_upgrade_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  deployment_id varchar2(32767),
  deployment_upgrade_type varchar2(32767),
  time_started timestamp with time zone,
  time_finished timestamp with time zone,
  ogg_version varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_sub_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  previous_ogg_version varchar2(32767),
  time_schedule timestamp with time zone,
  is_snoozed number,
  time_snoozed_until timestamp with time zone,
  time_released timestamp with time zone,
  release_type varchar2(32767),
  is_security_fix number,
  is_rollback_allowed number,
  time_ogg_version_supported_until timestamp with time zone,
  is_cancel_allowed number,
  is_reschedule_allowed number,
  time_schedule_max timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_upgrade_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_upgrade_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    deployment_id varchar2,
    deployment_upgrade_type varchar2,
    time_started timestamp with time zone,
    time_finished timestamp with time zone,
    ogg_version varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_sub_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    previous_ogg_version varchar2,
    time_schedule timestamp with time zone,
    is_snoozed number,
    time_snoozed_until timestamp with time zone,
    time_released timestamp with time zone,
    release_type varchar2,
    is_security_fix number,
    is_rollback_allowed number,
    time_ogg_version_supported_until timestamp with time zone,
    is_cancel_allowed number,
    is_reschedule_allowed number,
    time_schedule_max timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the Deployment Upgrade.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_upgrade_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  deployment_id varchar2(32767),
  deployment_upgrade_type varchar2(32767),
  time_started timestamp with time zone,
  time_finished timestamp with time zone,
  ogg_version varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_sub_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  previous_ogg_version varchar2(32767),
  time_schedule timestamp with time zone,
  is_snoozed number,
  time_snoozed_until timestamp with time zone,
  time_released timestamp with time zone,
  release_type varchar2(32767),
  is_security_fix number,
  is_rollback_allowed number,
  time_ogg_version_supported_until timestamp with time zone,
  is_cancel_allowed number,
  is_reschedule_allowed number,
  time_schedule_max timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_upgrade_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_upgrade_summary_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    deployment_id varchar2,
    deployment_upgrade_type varchar2,
    time_started timestamp with time zone,
    time_finished timestamp with time zone,
    ogg_version varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_sub_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    previous_ogg_version varchar2,
    time_schedule timestamp with time zone,
    is_snoozed number,
    time_snoozed_until timestamp with time zone,
    time_released timestamp with time zone,
    release_type varchar2,
    is_security_fix number,
    is_rollback_allowed number,
    time_ogg_version_supported_until timestamp with time zone,
    is_cancel_allowed number,
    is_reschedule_allowed number,
    time_schedule_max timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_golden_gate_deployment_upgrade_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_upgrade_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_deployment_upgrade_summary_t) NOT PERSISTABLE;

A list of Deployment Upgrades.

Syntax

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

Fields

The summary data of a specific deployment version.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_version_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  ogg_version varchar2(32767),
  deployment_type varchar2(32767),
  time_released timestamp with time zone,
  release_type varchar2(32767),
  is_security_fix number,
  time_supported_until timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_version_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_version_summary_t (
    ogg_version varchar2,
    deployment_type varchar2,
    time_released timestamp with time zone,
    release_type varchar2,
    is_security_fix number,
    time_supported_until timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_golden_gate_deployment_version_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_version_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_deployment_version_summary_t) NOT PERSISTABLE;

The list of DeploymentVersionSummary objects.

Syntax

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

Fields

Indicates whether the wallet exists in the deployment container

Syntax

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

Fields

Summary of the deployment wallets operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_wallets_operation_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  wallet_operation_id varchar2(32767),
  wallet_secret_id varchar2(32767),
  deployment_wallet_operation_type varchar2(32767),
  deployment_wallet_operation_status varchar2(32767),
  time_started timestamp with time zone,
  time_completed timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_wallets_operation_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_deployment_wallets_operation_summary_t (
    wallet_operation_id varchar2,
    wallet_secret_id varchar2,
    deployment_wallet_operation_type varchar2,
    deployment_wallet_operation_status varchar2,
    time_started timestamp with time zone,
    time_completed timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_golden_gate_deployment_wallets_operation_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_deployment_wallets_operation_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_golden_gate_deployment_wallets_operation_summary_t) NOT PERSISTABLE;

A list of deployment wallets operations.

Syntax

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

Fields

Represents the metadata of a Elasticsearch Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_elasticsearch_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  servers varchar2(32767),
  security_protocol varchar2(32767),
  authentication_type varchar2(32767),
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_elasticsearch_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_elasticsearch_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    servers varchar2,
    security_protocol varchar2,
    authentication_type varchar2,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_elasticsearch_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Elasticsearch Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_elasticsearch_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  servers varchar2(32767),
  security_protocol varchar2(32767),
  authentication_type varchar2(32767),
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_elasticsearch_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_elasticsearch_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    servers varchar2,
    security_protocol varchar2,
    authentication_type varchar2,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_elasticsearch_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Error information.

Syntax

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

Fields

Metadata required to export wallet from deployment

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_export_deployment_wallet_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  vault_id varchar2(32767),
  master_encryption_key_id varchar2(32767),
  secret_name varchar2(32767),
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_export_deployment_wallet_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_export_deployment_wallet_details_t (
    vault_id varchar2,
    master_encryption_key_id varchar2,
    secret_name varchar2,
    description varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Represents the metadata of a Generic Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_generic_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  host varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_generic_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_generic_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    host varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_generic_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Generic Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_generic_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  host varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_generic_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_generic_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    host varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_generic_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Represents the metadata of a GoldenGate Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_golden_gate_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  deployment_id varchar2(32767),
  host varchar2(32767),
  port number,
  username varchar2(32767),
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_golden_gate_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_golden_gate_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    deployment_id varchar2,
    host varchar2,
    port number,
    username varchar2,
    private_ip varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_golden_gate_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the GoldenGate Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_golden_gate_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  deployment_id varchar2(32767),
  host varchar2(32767),
  port number,
  username varchar2(32767),
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_golden_gate_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_golden_gate_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    deployment_id varchar2,
    host varchar2,
    port number,
    username varchar2,
    private_ip varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_golden_gate_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Represents the metadata of a Google BigQuery Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_google_big_query_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_google_big_query_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_google_big_query_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_google_big_query_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Google BigQuery Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_google_big_query_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_google_big_query_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_google_big_query_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_google_big_query_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Represents the metadata of a Google Cloud Storage Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_google_cloud_storage_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_google_cloud_storage_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_google_cloud_storage_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_google_cloud_storage_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Google Cloud Storage Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_google_cloud_storage_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_google_cloud_storage_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_google_cloud_storage_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_google_cloud_storage_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Represents the metadata of a Hadoop Distributed File System Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_hdfs_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_hdfs_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_hdfs_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_hdfs_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Hadoop Distributed File System Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_hdfs_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_hdfs_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_hdfs_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_hdfs_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Metadata required to import wallet to deployment

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_import_deployment_wallet_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  vault_id varchar2(32767),
  new_wallet_secret_id varchar2(32767),
  wallet_backup_secret_name varchar2(32767),
  master_encryption_key_id varchar2(32767),
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_import_deployment_wallet_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_import_deployment_wallet_details_t (
    vault_id varchar2,
    new_wallet_secret_id varchar2,
    wallet_backup_secret_name varchar2,
    master_encryption_key_id varchar2,
    description varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Represents the metadata of a Java Message Service Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_java_message_service_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  should_use_jndi number,
  jndi_connection_factory varchar2(32767),
  jndi_provider_url varchar2(32767),
  jndi_initial_context_factory varchar2(32767),
  jndi_security_principal varchar2(32767),
  connection_url varchar2(32767),
  connection_factory varchar2(32767),
  security_protocol varchar2(32767),
  authentication_type varchar2(32767),
  username varchar2(32767),
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_java_message_service_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_java_message_service_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    should_use_jndi number,
    jndi_connection_factory varchar2,
    jndi_provider_url varchar2,
    jndi_initial_context_factory varchar2,
    jndi_security_principal varchar2,
    connection_url varchar2,
    connection_factory varchar2,
    security_protocol varchar2,
    authentication_type varchar2,
    username varchar2,
    private_ip varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_java_message_service_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Java Message Service Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_java_message_service_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  should_use_jndi number,
  jndi_connection_factory varchar2(32767),
  jndi_provider_url varchar2(32767),
  jndi_initial_context_factory varchar2(32767),
  jndi_security_principal varchar2(32767),
  connection_url varchar2(32767),
  connection_factory varchar2(32767),
  security_protocol varchar2(32767),
  authentication_type varchar2(32767),
  username varchar2(32767),
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_java_message_service_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_java_message_service_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    should_use_jndi number,
    jndi_connection_factory varchar2,
    jndi_provider_url varchar2,
    jndi_initial_context_factory varchar2,
    jndi_security_principal varchar2,
    connection_url varchar2,
    connection_factory varchar2,
    security_protocol varchar2,
    authentication_type varchar2,
    username varchar2,
    private_ip varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_java_message_service_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Represents the metadata of a Kafka Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_kafka_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  stream_pool_id varchar2(32767),
  bootstrap_servers dbms_cloud_oci_golden_gate_kafka_bootstrap_server_tbl,
  security_protocol varchar2(32767),
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_kafka_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_kafka_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    stream_pool_id varchar2,
    bootstrap_servers dbms_cloud_oci_golden_gate_kafka_bootstrap_server_tbl,
    security_protocol varchar2,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_kafka_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Kafka Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_kafka_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  stream_pool_id varchar2(32767),
  bootstrap_servers dbms_cloud_oci_golden_gate_kafka_bootstrap_server_tbl,
  security_protocol varchar2(32767),
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_kafka_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_kafka_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    stream_pool_id varchar2,
    bootstrap_servers dbms_cloud_oci_golden_gate_kafka_bootstrap_server_tbl,
    security_protocol varchar2,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_kafka_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Represents the metadata of a Kafka (e.g. Confluent) Schema Registry Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_kafka_schema_registry_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  url varchar2(32767),
  authentication_type varchar2(32767),
  username varchar2(32767),
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_kafka_schema_registry_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_kafka_schema_registry_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    url varchar2,
    authentication_type varchar2,
    username varchar2,
    private_ip varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_kafka_schema_registry_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Kafka (e.g. Confluent) Schema Registry Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_kafka_schema_registry_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  url varchar2(32767),
  authentication_type varchar2(32767),
  username varchar2(32767),
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_kafka_schema_registry_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_kafka_schema_registry_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    url varchar2,
    authentication_type varchar2,
    username varchar2,
    private_ip varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_kafka_schema_registry_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Represents the metadata of a Microsoft SQL Server Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_microsoft_sqlserver_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  username varchar2(32767),
  host varchar2(32767),
  port number,
  database_name varchar2(32767),
  additional_attributes dbms_cloud_oci_golden_gate_name_value_pair_tbl,
  security_protocol varchar2(32767),
  ssl_ca varchar2(32767),
  should_validate_server_certificate number,
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_microsoft_sqlserver_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_microsoft_sqlserver_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    username varchar2,
    host varchar2,
    port number,
    database_name varchar2,
    additional_attributes dbms_cloud_oci_golden_gate_name_value_pair_tbl,
    security_protocol varchar2,
    ssl_ca varchar2,
    should_validate_server_certificate number,
    private_ip varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_microsoft_sqlserver_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the Microsoft SQL Server Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_microsoft_sqlserver_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  database_name varchar2(32767),
  host varchar2(32767),
  port number,
  username varchar2(32767),
  additional_attributes dbms_cloud_oci_golden_gate_name_value_pair_tbl,
  security_protocol varchar2(32767),
  ssl_ca varchar2(32767),
  should_validate_server_certificate number,
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_microsoft_sqlserver_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_microsoft_sqlserver_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    database_name varchar2,
    host varchar2,
    port number,
    username varchar2,
    additional_attributes dbms_cloud_oci_golden_gate_name_value_pair_tbl,
    security_protocol varchar2,
    ssl_ca varchar2,
    should_validate_server_certificate number,
    private_ip varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_microsoft_sqlserver_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields

Represents the metadata of a MongoDB Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_mongo_db_connection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_t (
  technology_type varchar2(32767),
  connection_string varchar2(32767),
  username varchar2(32767),
  database_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_mongo_db_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_mongo_db_connection_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    connection_string varchar2,
    username varchar2,
    database_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_mongo_db_connection_t is a subtype of the dbms_cloud_oci_golden_gate_connection_t type.

Fields

Summary of the MongoDB Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_golden_gate_mongo_db_connection_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_golden_gate_connection_summary_t (
  technology_type varchar2(32767),
  connection_string varchar2(32767),
  username varchar2(32767),
  database_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_mongo_db_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_golden_gate_mongo_db_connection_summary_t (
    connection_type varchar2,
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vault_id varchar2,
    key_id varchar2,
    ingress_ips dbms_cloud_oci_golden_gate_ingress_ip_details_tbl,
    nsg_ids dbms_cloud_oci_golden_gate_varchar2_tbl,
    subnet_id varchar2,
    routing_method varchar2,
    technology_type varchar2,
    connection_string varchar2,
    username varchar2,
    database_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_golden_gate_mongo_db_connection_summary_t is a subtype of the dbms_cloud_oci_golden_gate_connection_summary_t type.

Fields