Nested table type of varchar2(32767).

Syntax

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

Syntax

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

Fields

A reference to an Object Storage object.

Syntax

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

Fields

Details needed by the glossary export request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_asynchronous_export_glossary_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  object_storage_target dbms_cloud_oci_datacatalog_object_storage_object_reference_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_asynchronous_export_glossary_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_asynchronous_export_glossary_details_t (
    object_storage_target dbms_cloud_oci_datacatalog_object_storage_object_reference_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about the job which performs an export.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_asynchronous_export_glossary_result_t FORCE AUTHID CURRENT_USER IS OBJECT (
  job_definition_name varchar2(32767),
  job_definition_key varchar2(32767),
  job_key varchar2(32767),
  job_execution_key varchar2(32767),
  source_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_asynchronous_export_glossary_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_asynchronous_export_glossary_result_t (
    job_definition_name varchar2,
    job_definition_key varchar2,
    job_key varchar2,
    job_execution_key varchar2,
    source_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for an export request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_asynchronous_export_request_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  object_storage_target dbms_cloud_oci_datacatalog_object_storage_object_reference_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_asynchronous_export_request_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_asynchronous_export_request_details_t (
    object_storage_target dbms_cloud_oci_datacatalog_object_storage_object_reference_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about the job which performs an export.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_asynchronous_export_result_t FORCE AUTHID CURRENT_USER IS OBJECT (
  job_definition_name varchar2(32767),
  job_definition_key varchar2(32767),
  job_key varchar2(32767),
  job_execution_key varchar2(32767),
  source_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_asynchronous_export_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_asynchronous_export_result_t (
    job_definition_name varchar2,
    job_definition_key varchar2,
    job_key varchar2,
    job_execution_key varchar2,
    source_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Information about the attaching the private endpoint resource to a catalog

Syntax

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

Fields

Details regarding a specific object and its relationship to the referencing object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_object_relationship_t FORCE AUTHID CURRENT_USER IS OBJECT (
  relationship_type varchar2(32767),
  key varchar2(32767),
  name varchar2(32767),
  type_name varchar2(32767),
  type_key varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  path varchar2(32767),
  parent_key varchar2(32767),
  parent_path varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_object_relationship_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_object_relationship_t (
    relationship_type varchar2,
    key varchar2,
    name varchar2,
    type_name varchar2,
    type_key varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    path varchar2,
    parent_key varchar2,
    parent_path varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of a single custom property

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_custom_property_get_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  value varchar2(32767),
  data_type varchar2(32767),
  namespace_name varchar2(32767),
  namespace_key varchar2(32767),
  is_multi_valued number,
  is_hidden number,
  is_editable number,
  is_shown_in_list number,
  is_event_enabled number,
  is_list_type number,
  allowed_values dbms_cloud_oci_datacatalog_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_custom_property_get_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_custom_property_get_usage_t (
    key varchar2,
    display_name varchar2,
    description varchar2,
    value varchar2,
    data_type varchar2,
    namespace_name varchar2,
    namespace_key varchar2,
    is_multi_valued number,
    is_hidden number,
    is_editable number,
    is_shown_in_list number,
    is_event_enabled number,
    is_list_type number,
    allowed_values dbms_cloud_oci_datacatalog_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_object_relationship_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_object_relationship_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_object_relationship_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_datacatalog_custom_property_get_usage_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_custom_property_get_usage_t) NOT PERSISTABLE;

Details of an entity attribute. An attribute of a data entity describing an item of data, with a name and data type. Synonymous with 'column' in a database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_attribute_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  business_name varchar2(32767),
  description varchar2(32767),
  entity_key varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  created_by_id varchar2(32767),
  updated_by_id varchar2(32767),
  external_data_type varchar2(32767),
  external_key varchar2(32767),
  is_incremental_data number,
  is_nullable number,
  type_key varchar2(32767),
  min_collection_count number,
  max_collection_count number,
  datatype_entity_key varchar2(32767),
  external_datatype_entity_key varchar2(32767),
  parent_attribute_key varchar2(32767),
  external_parent_attribute_key varchar2(32767),
  length number,
  position number,
  precision number,
  scale number,
  time_external timestamp with time zone,
  time_harvested timestamp with time zone,
  object_relationships dbms_cloud_oci_datacatalog_object_relationship_tbl,
  is_derived_attribute number,
  uri varchar2(32767),
  path varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
  properties json_element_t,
  associated_rule_types dbms_cloud_oci_datacatalog_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_attribute_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_attribute_t (
    key varchar2,
    display_name varchar2,
    business_name varchar2,
    description varchar2,
    entity_key varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    created_by_id varchar2,
    updated_by_id varchar2,
    external_data_type varchar2,
    external_key varchar2,
    is_incremental_data number,
    is_nullable number,
    type_key varchar2,
    min_collection_count number,
    max_collection_count number,
    datatype_entity_key varchar2,
    external_datatype_entity_key varchar2,
    parent_attribute_key varchar2,
    external_parent_attribute_key varchar2,
    length number,
    position number,
    precision number,
    scale number,
    time_external timestamp with time zone,
    time_harvested timestamp with time zone,
    object_relationships dbms_cloud_oci_datacatalog_object_relationship_tbl,
    is_derived_attribute number,
    uri varchar2,
    path varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
    properties json_element_t,
    associated_rule_types dbms_cloud_oci_datacatalog_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of an entity attribute.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_attribute_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  business_name varchar2(32767),
  description varchar2(32767),
  entity_key varchar2(32767),
  external_key varchar2(32767),
  length number,
  position number,
  precision number,
  scale number,
  is_nullable number,
  uri varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  time_created timestamp with time zone,
  external_data_type varchar2(32767),
  type_key varchar2(32767),
  min_collection_count number,
  max_collection_count number,
  datatype_entity_key varchar2(32767),
  external_datatype_entity_key varchar2(32767),
  parent_attribute_key varchar2(32767),
  external_parent_attribute_key varchar2(32767),
  path varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
  associated_rule_types dbms_cloud_oci_datacatalog_varchar2_tbl,
  is_derived_attribute number,
  time_updated timestamp with time zone,
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_attribute_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_attribute_summary_t (
    key varchar2,
    display_name varchar2,
    business_name varchar2,
    description varchar2,
    entity_key varchar2,
    external_key varchar2,
    length number,
    position number,
    precision number,
    scale number,
    is_nullable number,
    uri varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    external_data_type varchar2,
    type_key varchar2,
    min_collection_count number,
    max_collection_count number,
    datatype_entity_key varchar2,
    external_datatype_entity_key varchar2,
    parent_attribute_key varchar2,
    external_parent_attribute_key varchar2,
    path varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
    associated_rule_types dbms_cloud_oci_datacatalog_varchar2_tbl,
    is_derived_attribute number,
    time_updated timestamp with time zone,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_attribute_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_attribute_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_attribute_summary_t) NOT PERSISTABLE;

Results of an attributes listing. Attributes describe an item of data with name and datatype.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_attribute_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_count number,
  items dbms_cloud_oci_datacatalog_attribute_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_attribute_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_attribute_collection_t (
    l_count number,
    items dbms_cloud_oci_datacatalog_attribute_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Represents an association of an entity attribute to a term.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_attribute_tag_t FORCE AUTHID CURRENT_USER IS OBJECT (
  attribute_key varchar2(32767),
  key varchar2(32767),
  name varchar2(32767),
  term_key varchar2(32767),
  term_path varchar2(32767),
  term_description varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  created_by_id varchar2(32767),
  uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_attribute_tag_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_attribute_tag_t (
    attribute_key varchar2,
    key varchar2,
    name varchar2,
    term_key varchar2,
    term_path varchar2,
    term_description varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    created_by_id varchar2,
    uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of an entity attribute tag.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_attribute_tag_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  attribute_key varchar2(32767),
  key varchar2(32767),
  time_created timestamp with time zone,
  name varchar2(32767),
  uri varchar2(32767),
  term_key varchar2(32767),
  term_path varchar2(32767),
  term_description varchar2(32767),
  glossary_key varchar2(32767),
  lifecycle_state varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_attribute_tag_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_attribute_tag_summary_t (
    attribute_key varchar2,
    key varchar2,
    time_created timestamp with time zone,
    name varchar2,
    uri varchar2,
    term_key varchar2,
    term_path varchar2,
    term_description varchar2,
    glossary_key varchar2,
    lifecycle_state varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_attribute_tag_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_attribute_tag_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_attribute_tag_summary_t) NOT PERSISTABLE;

Results of an attribute tags listing. Attribnute tags allow association of business terms with attributes.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_attribute_tag_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_count number,
  items dbms_cloud_oci_datacatalog_attribute_tag_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_attribute_tag_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_attribute_tag_collection_t (
    l_count number,
    items dbms_cloud_oci_datacatalog_attribute_tag_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Permissions object sent as part of the response.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_base_permissions_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  user_permissions dbms_cloud_oci_datacatalog_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_base_permissions_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_base_permissions_summary_t (
    user_permissions dbms_cloud_oci_datacatalog_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Represents the association of an object to a term. Tags are immutable.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_base_tag_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  name varchar2(32767),
  term_key varchar2(32767),
  term_path varchar2(32767),
  term_description varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  created_by_id varchar2(32767),
  uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_base_tag_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_base_tag_t (
    key varchar2,
    name varchar2,
    term_key varchar2,
    term_path varchar2,
    term_description varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    created_by_id varchar2,
    uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Represents the association of an object to a term.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_base_tag_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  time_created timestamp with time zone,
  name varchar2(32767),
  uri varchar2(32767),
  term_key varchar2(32767),
  term_path varchar2(32767),
  term_description varchar2(32767),
  glossary_key varchar2(32767),
  lifecycle_state varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_base_tag_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_base_tag_summary_t (
    key varchar2,
    time_created timestamp with time zone,
    name varchar2,
    uri varchar2,
    term_key varchar2,
    term_path varchar2,
    term_description varchar2,
    glossary_key varchar2,
    lifecycle_state varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Resource locks are used to prevent certain APIs from being called for the resource. A full lock prevents both updating the resource and deleting the resource. A delete lock prevents deleting the resource.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_datacatalog_resource_lock_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_resource_lock_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_resource_lock_t) NOT PERSISTABLE;

A data catalog enables you to collect, organize, find, access, understand, enrich, and activate technical, business, and operational metadata.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_catalog_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  service_api_url varchar2(32767),
  service_console_url varchar2(32767),
  number_of_objects number,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  system_tags json_element_t,
  defined_tags json_element_t,
  attached_catalog_private_endpoints dbms_cloud_oci_datacatalog_varchar2_tbl,
  locks dbms_cloud_oci_datacatalog_resource_lock_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_catalog_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_catalog_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    service_api_url varchar2,
    service_console_url varchar2,
    number_of_objects number,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    system_tags json_element_t,
    defined_tags json_element_t,
    attached_catalog_private_endpoints dbms_cloud_oci_datacatalog_varchar2_tbl,
    locks dbms_cloud_oci_datacatalog_resource_lock_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

General permissions object.

Syntax

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

Fields

A private network reverse connection creates a connection from service to customer subnet over a private network.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_catalog_private_endpoint_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  subnet_id varchar2(32767),
  display_name varchar2(32767),
  dns_zones dbms_cloud_oci_datacatalog_varchar2_tbl,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  freeform_tags json_element_t,
  system_tags json_element_t,
  defined_tags json_element_t,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  attached_catalogs dbms_cloud_oci_datacatalog_varchar2_tbl,
  locks dbms_cloud_oci_datacatalog_resource_lock_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_catalog_private_endpoint_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_catalog_private_endpoint_t (
    id varchar2,
    compartment_id varchar2,
    subnet_id varchar2,
    display_name varchar2,
    dns_zones dbms_cloud_oci_datacatalog_varchar2_tbl,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    freeform_tags json_element_t,
    system_tags json_element_t,
    defined_tags json_element_t,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    attached_catalogs dbms_cloud_oci_datacatalog_varchar2_tbl,
    locks dbms_cloud_oci_datacatalog_resource_lock_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A private network reverse connection creates a connection from service to customer subnet over a private network.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_catalog_private_endpoint_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  subnet_id varchar2(32767),
  dns_zones dbms_cloud_oci_datacatalog_varchar2_tbl,
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  display_name varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  system_tags json_element_t,
  defined_tags json_element_t,
  lifecycle_state varchar2(32767),
  attached_catalogs dbms_cloud_oci_datacatalog_varchar2_tbl,
  locks dbms_cloud_oci_datacatalog_resource_lock_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_catalog_private_endpoint_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_catalog_private_endpoint_summary_t (
    id varchar2,
    subnet_id varchar2,
    dns_zones dbms_cloud_oci_datacatalog_varchar2_tbl,
    compartment_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    display_name varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    system_tags json_element_t,
    defined_tags json_element_t,
    lifecycle_state varchar2,
    attached_catalogs dbms_cloud_oci_datacatalog_varchar2_tbl,
    locks dbms_cloud_oci_datacatalog_resource_lock_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the data catalog.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_catalog_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  number_of_objects number,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  system_tags json_element_t,
  defined_tags json_element_t,
  attached_catalog_private_endpoints dbms_cloud_oci_datacatalog_varchar2_tbl,
  locks dbms_cloud_oci_datacatalog_resource_lock_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_catalog_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_catalog_summary_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    number_of_objects number,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    system_tags json_element_t,
    defined_tags json_element_t,
    attached_catalog_private_endpoints dbms_cloud_oci_datacatalog_varchar2_tbl,
    locks dbms_cloud_oci_datacatalog_resource_lock_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Information about the change compartment

Syntax

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

Fields

Information about the change compartment for the private endpoint resource

Syntax

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

Fields

Information about a change in metastore compartment.

Syntax

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

Fields

Detailed representation of a connection to a data asset, minus any sensitive properties.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_connection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  description varchar2(32767),
  display_name varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  created_by_id varchar2(32767),
  updated_by_id varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
  properties json_element_t,
  external_key varchar2(32767),
  time_status_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  is_default number,
  data_asset_key varchar2(32767),
  type_key varchar2(32767),
  uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_connection_t (
    key varchar2,
    description varchar2,
    display_name varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    created_by_id varchar2,
    updated_by_id varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
    properties json_element_t,
    external_key varchar2,
    time_status_updated timestamp with time zone,
    lifecycle_state varchar2,
    is_default number,
    data_asset_key varchar2,
    type_key varchar2,
    uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary representation of database aliases parsed from the file metadata.

Syntax

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

Fields

Summary representation of a connection to a data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_connection_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  description varchar2(32767),
  display_name varchar2(32767),
  data_asset_key varchar2(32767),
  type_key varchar2(32767),
  uri varchar2(32767),
  external_key varchar2(32767),
  lifecycle_state varchar2(32767),
  is_default number,
  time_created timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_connection_summary_t (
    key varchar2,
    description varchar2,
    display_name varchar2,
    data_asset_key varchar2,
    type_key varchar2,
    uri varchar2,
    external_key varchar2,
    lifecycle_state varchar2,
    is_default number,
    time_created timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_connection_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_connection_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_connection_summary_t) NOT PERSISTABLE;

Results of a connections listing. Each member of the result is a summary representation of a connection to a data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_connection_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_count number,
  items dbms_cloud_oci_datacatalog_connection_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_connection_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_connection_collection_t (
    l_count number,
    items dbms_cloud_oci_datacatalog_connection_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of a single custom property.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_datacatalog_custom_property_set_usage_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_custom_property_set_usage_t) NOT PERSISTABLE;

Properties used in attribute create operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_create_attribute_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  business_name varchar2(32767),
  description varchar2(32767),
  external_data_type varchar2(32767),
  is_incremental_data number,
  is_nullable number,
  length number,
  position number,
  precision number,
  scale number,
  time_external timestamp with time zone,
  min_collection_count number,
  max_collection_count number,
  external_datatype_entity_key varchar2(32767),
  external_parent_attribute_key varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl,
  type_key varchar2(32767),
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_attribute_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_attribute_details_t (
    display_name varchar2,
    business_name varchar2,
    description varchar2,
    external_data_type varchar2,
    is_incremental_data number,
    is_nullable number,
    length number,
    position number,
    precision number,
    scale number,
    time_external timestamp with time zone,
    min_collection_count number,
    max_collection_count number,
    external_datatype_entity_key varchar2,
    external_parent_attribute_key varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl,
    type_key varchar2,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about a new data catalog.

Syntax

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

Fields

Information about the new private endpoint resource

Syntax

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

Fields

Properties used in connection create operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_create_connection_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  description varchar2(32767),
  display_name varchar2(32767),
  type_key varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl,
  properties json_element_t,
  enc_properties json_element_t,
  is_default number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_connection_details_t (
    description varchar2,
    display_name varchar2,
    type_key varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl,
    properties json_element_t,
    enc_properties json_element_t,
    is_default number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Properties used in custom property create operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_create_custom_property_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  data_type varchar2(32767),
  is_sortable number,
  is_filterable number,
  is_multi_valued number,
  is_hidden number,
  is_editable number,
  is_shown_in_list number,
  is_hidden_in_search number,
  is_event_enabled number,
  allowed_values dbms_cloud_oci_datacatalog_varchar2_tbl,
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_custom_property_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_custom_property_details_t (
    display_name varchar2,
    description varchar2,
    data_type varchar2,
    is_sortable number,
    is_filterable number,
    is_multi_valued number,
    is_hidden number,
    is_editable number,
    is_shown_in_list number,
    is_hidden_in_search number,
    is_event_enabled number,
    allowed_values dbms_cloud_oci_datacatalog_varchar2_tbl,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Properties used in data asset create operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_create_data_asset_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  type_key varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl,
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_data_asset_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_data_asset_details_t (
    display_name varchar2,
    description varchar2,
    type_key varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Properties used in data entity create operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_create_entity_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  business_name varchar2(32767),
  type_key varchar2(32767),
  description varchar2(32767),
  time_external timestamp with time zone,
  is_logical number,
  is_partition number,
  folder_key varchar2(32767),
  pattern_key varchar2(32767),
  realized_expression varchar2(32767),
  harvest_status varchar2(32767),
  last_job_key varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl,
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_entity_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_entity_details_t (
    display_name varchar2,
    business_name varchar2,
    type_key varchar2,
    description varchar2,
    time_external timestamp with time zone,
    is_logical number,
    is_partition number,
    folder_key varchar2,
    pattern_key varchar2,
    realized_expression varchar2,
    harvest_status varchar2,
    last_job_key varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Properties used in folder create operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_create_folder_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  business_name varchar2(32767),
  description varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl,
  properties json_element_t,
  parent_folder_key varchar2(32767),
  time_external timestamp with time zone,
  last_job_key varchar2(32767),
  harvest_status varchar2(32767),
  type_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_folder_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_folder_details_t (
    display_name varchar2,
    business_name varchar2,
    description varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl,
    properties json_element_t,
    parent_folder_key varchar2,
    time_external timestamp with time zone,
    last_job_key varchar2,
    harvest_status varchar2,
    type_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Properties used in glossary create operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_create_glossary_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  workflow_status varchar2(32767),
  owner varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_glossary_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_glossary_details_t (
    display_name varchar2,
    description varchar2,
    workflow_status varchar2,
    owner varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Representation of a job definition Resource. Job definitions define the harvest scope and includes the list of objects to be harvested along with a schedule. The list of objects is usually specified through a combination of object type, regular expressions, or specific names of objects and a sample size for the data harvested.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_create_job_definition_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  job_type varchar2(32767),
  is_incremental number,
  data_asset_key varchar2(32767),
  glossary_key varchar2(32767),
  connection_key varchar2(32767),
  is_sample_data_extracted number,
  sample_data_size_in_m_bs number,
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_job_definition_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_job_definition_details_t (
    display_name varchar2,
    description varchar2,
    job_type varchar2,
    is_incremental number,
    data_asset_key varchar2,
    glossary_key varchar2,
    connection_key varchar2,
    is_sample_data_extracted number,
    sample_data_size_in_m_bs number,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Properties used to create a job.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_create_job_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  schedule_cron_expression varchar2(32767),
  time_schedule_begin timestamp with time zone,
  time_schedule_end timestamp with time zone,
  connection_key varchar2(32767),
  job_definition_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_job_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_job_details_t (
    display_name varchar2,
    description varchar2,
    schedule_cron_expression varchar2,
    time_schedule_begin timestamp with time zone,
    time_schedule_end timestamp with time zone,
    connection_key varchar2,
    job_definition_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Properties for creating a new job execution.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_create_job_execution_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  sub_type varchar2(32767),
  job_type varchar2(32767),
  parent_key varchar2(32767),
  time_started timestamp with time zone,
  time_ended timestamp with time zone,
  lifecycle_state varchar2(32767),
  error_code varchar2(32767),
  error_message varchar2(32767),
  schedule_instance_key varchar2(32767),
  process_key varchar2(32767),
  external_url varchar2(32767),
  event_key varchar2(32767),
  data_entity_key varchar2(32767),
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_job_execution_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_job_execution_details_t (
    sub_type varchar2,
    job_type varchar2,
    parent_key varchar2,
    time_started timestamp with time zone,
    time_ended timestamp with time zone,
    lifecycle_state varchar2,
    error_code varchar2,
    error_message varchar2,
    schedule_instance_key varchar2,
    process_key varchar2,
    external_url varchar2,
    event_key varchar2,
    data_entity_key varchar2,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Information about a new metastore.

Syntax

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

Fields

Properties used in custom property create operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_create_namespace_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  is_service_defined number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_namespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_namespace_details_t (
    display_name varchar2,
    description varchar2,
    is_service_defined number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Properties used in pattern create operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_create_pattern_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  expression varchar2(32767),
  file_path_prefix varchar2(32767),
  check_file_path_list dbms_cloud_oci_datacatalog_varchar2_tbl,
  is_enable_check_failure_limit number,
  check_failure_limit number,
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_pattern_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_pattern_details_t (
    display_name varchar2,
    description varchar2,
    expression varchar2,
    file_path_prefix varchar2,
    check_file_path_list dbms_cloud_oci_datacatalog_varchar2_tbl,
    is_enable_check_failure_limit number,
    check_failure_limit number,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Properties used in tag create operations.

Syntax

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

Fields

Properties used in term create operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_create_term_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  is_allowed_to_have_child_terms number,
  parent_term_key varchar2(32767),
  owner varchar2(32767),
  workflow_status varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_term_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_create_term_details_t (
    display_name varchar2,
    description varchar2,
    is_allowed_to_have_child_terms number,
    parent_term_key varchar2,
    owner varchar2,
    workflow_status varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_set_usage_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Properties used in term relationship create operations.

Syntax

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

Fields

Object which describes the indivial object stats for every custom property

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_custom_property_type_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  type_id varchar2(32767),
  type_name varchar2(32767),
  l_count number,
  is_event_enabled number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_custom_property_type_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_custom_property_type_usage_t (
    type_id varchar2,
    type_name varchar2,
    l_count number,
    is_event_enabled number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Describes an event configuration, for a given object type and property. Primarily, whether a property change will result in an event being emitted.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_event_config_t FORCE AUTHID CURRENT_USER IS OBJECT (
  type_id varchar2(32767),
  type_name varchar2(32767),
  property_id varchar2(32767),
  property_name varchar2(32767),
  event_config_status varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  created_by_id varchar2(32767),
  updated_by_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_event_config_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_event_config_t (
    type_id varchar2,
    type_name varchar2,
    property_id varchar2,
    property_name varchar2,
    event_config_status varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    created_by_id varchar2,
    updated_by_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_custom_property_type_usage_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_custom_property_type_usage_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_custom_property_type_usage_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_datacatalog_event_config_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_event_config_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_event_config_t) NOT PERSISTABLE;

Custom Property Definition

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_custom_property_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  data_type varchar2(32767),
  description varchar2(32767),
  namespace_name varchar2(32767),
  is_list_type number,
  is_sortable number,
  is_filterable number,
  is_multi_valued number,
  is_hidden number,
  is_editable number,
  is_shown_in_list number,
  is_service_defined number,
  is_hidden_in_search number,
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  created_by_id varchar2(32767),
  updated_by_id varchar2(32767),
  usage_count number,
  is_event_enabled number,
  scope dbms_cloud_oci_datacatalog_custom_property_type_usage_tbl,
  allowed_values dbms_cloud_oci_datacatalog_varchar2_tbl,
  events dbms_cloud_oci_datacatalog_event_config_tbl,
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_custom_property_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_custom_property_t (
    key varchar2,
    display_name varchar2,
    data_type varchar2,
    description varchar2,
    namespace_name varchar2,
    is_list_type number,
    is_sortable number,
    is_filterable number,
    is_multi_valued number,
    is_hidden number,
    is_editable number,
    is_shown_in_list number,
    is_service_defined number,
    is_hidden_in_search number,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    created_by_id varchar2,
    updated_by_id varchar2,
    usage_count number,
    is_event_enabled number,
    scope dbms_cloud_oci_datacatalog_custom_property_type_usage_tbl,
    allowed_values dbms_cloud_oci_datacatalog_varchar2_tbl,
    events dbms_cloud_oci_datacatalog_event_config_tbl,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a custom property

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_custom_property_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  data_type varchar2(32767),
  namespace_name varchar2(32767),
  is_sortable number,
  is_filterable number,
  is_multi_valued number,
  is_hidden number,
  is_editable number,
  is_shown_in_list number,
  is_service_defined number,
  is_hidden_in_search number,
  time_created timestamp with time zone,
  lifecycle_state varchar2(32767),
  usage_count number,
  scope dbms_cloud_oci_datacatalog_custom_property_type_usage_tbl,
  allowed_values dbms_cloud_oci_datacatalog_varchar2_tbl,
  time_updated timestamp with time zone,
  created_by_id varchar2(32767),
  updated_by_id varchar2(32767),
  is_event_enabled number,
  events dbms_cloud_oci_datacatalog_event_config_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_custom_property_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_custom_property_summary_t (
    key varchar2,
    display_name varchar2,
    description varchar2,
    data_type varchar2,
    namespace_name varchar2,
    is_sortable number,
    is_filterable number,
    is_multi_valued number,
    is_hidden number,
    is_editable number,
    is_shown_in_list number,
    is_service_defined number,
    is_hidden_in_search number,
    time_created timestamp with time zone,
    lifecycle_state varchar2,
    usage_count number,
    scope dbms_cloud_oci_datacatalog_custom_property_type_usage_tbl,
    allowed_values dbms_cloud_oci_datacatalog_varchar2_tbl,
    time_updated timestamp with time zone,
    created_by_id varchar2,
    updated_by_id varchar2,
    is_event_enabled number,
    events dbms_cloud_oci_datacatalog_event_config_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_custom_property_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_custom_property_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_custom_property_summary_t) NOT PERSISTABLE;

Results of a custom properties listing. A custom property is an user defined attribute tied to the first class object of data catalog

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_custom_property_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_count number,
  items dbms_cloud_oci_datacatalog_custom_property_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_custom_property_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_custom_property_collection_t (
    l_count number,
    items dbms_cloud_oci_datacatalog_custom_property_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a pattern. A pattern is a data selector or filter which can provide a singular, logical entity view aggregating multiple physical data artifacts for ease of use.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_pattern_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  catalog_id varchar2(32767),
  time_created timestamp with time zone,
  expression varchar2(32767),
  file_path_prefix varchar2(32767),
  lifecycle_state varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_pattern_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_pattern_summary_t (
    key varchar2,
    display_name varchar2,
    description varchar2,
    catalog_id varchar2,
    time_created timestamp with time zone,
    expression varchar2,
    file_path_prefix varchar2,
    lifecycle_state varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_pattern_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_pattern_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_pattern_summary_t) NOT PERSISTABLE;

Data asset representation. A physical store, or stream, of data known to the data catalog and containing one or many data entities, possibly in an organized structure of folders. A data asset is often synonymous with a 'System', such as a database, or may be a file container or a message stream.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_data_asset_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  catalog_id varchar2(32767),
  external_key varchar2(32767),
  type_key varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  time_harvested timestamp with time zone,
  created_by_id varchar2(32767),
  updated_by_id varchar2(32767),
  uri varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
  data_selector_patterns dbms_cloud_oci_datacatalog_pattern_summary_tbl,
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_data_asset_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_data_asset_t (
    key varchar2,
    display_name varchar2,
    description varchar2,
    catalog_id varchar2,
    external_key varchar2,
    type_key varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    time_harvested timestamp with time zone,
    created_by_id varchar2,
    updated_by_id varchar2,
    uri varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
    data_selector_patterns dbms_cloud_oci_datacatalog_pattern_summary_tbl,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a data asset. A physical store, or stream, of data known to the data catalog and containing one or many data entities, possibly in an organized structure of folders. A data asset is often synonymous with a 'System', such as a database, or may be a file container or a message stream.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_data_asset_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  catalog_id varchar2(32767),
  external_key varchar2(32767),
  uri varchar2(32767),
  time_created timestamp with time zone,
  type_key varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_data_asset_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_data_asset_summary_t (
    key varchar2,
    display_name varchar2,
    description varchar2,
    catalog_id varchar2,
    external_key varchar2,
    uri varchar2,
    time_created timestamp with time zone,
    type_key varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_data_asset_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_data_asset_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_data_asset_summary_t) NOT PERSISTABLE;

Results of a data assets listing. A data asset is often synonymous with a 'System', such as a database, or may be a file container or a message stream.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_data_asset_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_count number,
  items dbms_cloud_oci_datacatalog_data_asset_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_data_asset_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_data_asset_collection_t (
    l_count number,
    items dbms_cloud_oci_datacatalog_data_asset_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Scope of asset export, which consists of a container object (bucket, folder, schema, etc) within the asset, and types of child objects contained by that object to be included. objectKey - Key of the container object to be exported. For example, key of schema_1. exportTypeIds - Type key(s) of objects within the container object to be exported. For example, type key of table or view.

Syntax

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

Fields

Permissions object for data assets.

Syntax

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

Fields

Represents an association of a data asset to a term.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_data_asset_tag_t FORCE AUTHID CURRENT_USER IS OBJECT (
  data_asset_key varchar2(32767),
  key varchar2(32767),
  name varchar2(32767),
  term_key varchar2(32767),
  term_path varchar2(32767),
  term_description varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  created_by_id varchar2(32767),
  uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_data_asset_tag_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_data_asset_tag_t (
    data_asset_key varchar2,
    key varchar2,
    name varchar2,
    term_key varchar2,
    term_path varchar2,
    term_description varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    created_by_id varchar2,
    uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a data asset tag.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_data_asset_tag_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  data_asset_key varchar2(32767),
  key varchar2(32767),
  time_created timestamp with time zone,
  name varchar2(32767),
  uri varchar2(32767),
  term_key varchar2(32767),
  term_path varchar2(32767),
  term_description varchar2(32767),
  glossary_key varchar2(32767),
  lifecycle_state varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_data_asset_tag_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_data_asset_tag_summary_t (
    data_asset_key varchar2,
    key varchar2,
    time_created timestamp with time zone,
    name varchar2,
    uri varchar2,
    term_key varchar2,
    term_path varchar2,
    term_description varchar2,
    glossary_key varchar2,
    lifecycle_state varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_data_asset_tag_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_data_asset_tag_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_data_asset_tag_summary_t) NOT PERSISTABLE;

Results of a data asset tag listing. Data asset tags represent an association of a data asset to a term.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_data_asset_tag_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_count number,
  items dbms_cloud_oci_datacatalog_data_asset_tag_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_data_asset_tag_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_data_asset_tag_collection_t (
    l_count number,
    items dbms_cloud_oci_datacatalog_data_asset_tag_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

List of pattern Ids. Used in the addition and removal of patterns in data assets.

Syntax

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

Fields

Entities derived from the application of a pattern to a list of file paths.

Syntax

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

Fields

Information about the detaching the private endpoint resource from a catalog

Syntax

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

Fields

Data entity details. A representation of data with a set of attributes, normally representing a single business entity. Synonymous with 'table' or 'view' in a database, or a single logical file structure that one or many files may match.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_entity_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  business_name varchar2(32767),
  description varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  created_by_id varchar2(32767),
  updated_by_id varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  external_key varchar2(32767),
  pattern_key varchar2(32767),
  realized_expression varchar2(32767),
  time_external timestamp with time zone,
  time_harvested timestamp with time zone,
  object_relationships dbms_cloud_oci_datacatalog_object_relationship_tbl,
  time_status_updated timestamp with time zone,
  is_logical number,
  is_partition number,
  data_asset_key varchar2(32767),
  folder_key varchar2(32767),
  folder_name varchar2(32767),
  path varchar2(32767),
  harvest_status varchar2(32767),
  last_job_key varchar2(32767),
  type_key varchar2(32767),
  uri varchar2(32767),
  object_storage_url varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_t (
    key varchar2,
    display_name varchar2,
    business_name varchar2,
    description varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    created_by_id varchar2,
    updated_by_id varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    external_key varchar2,
    pattern_key varchar2,
    realized_expression varchar2,
    time_external timestamp with time zone,
    time_harvested timestamp with time zone,
    object_relationships dbms_cloud_oci_datacatalog_object_relationship_tbl,
    time_status_updated timestamp with time zone,
    is_logical number,
    is_partition number,
    data_asset_key varchar2,
    folder_key varchar2,
    folder_name varchar2,
    path varchar2,
    harvest_status varchar2,
    last_job_key varchar2,
    type_key varchar2,
    uri varchar2,
    object_storage_url varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of an data entity. A representation of data with a set of attributes, normally representing a single business entity. Synonymous with 'table' or 'view' in a database, or a single logical file structure that one or many files may match.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_entity_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  business_name varchar2(32767),
  description varchar2(32767),
  is_logical number,
  is_partition number,
  data_asset_key varchar2(32767),
  folder_key varchar2(32767),
  folder_name varchar2(32767),
  external_key varchar2(32767),
  pattern_key varchar2(32767),
  type_key varchar2(32767),
  realized_expression varchar2(32767),
  path varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  updated_by_id varchar2(32767),
  uri varchar2(32767),
  object_storage_url varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_summary_t (
    key varchar2,
    display_name varchar2,
    business_name varchar2,
    description varchar2,
    is_logical number,
    is_partition number,
    data_asset_key varchar2,
    folder_key varchar2,
    folder_name varchar2,
    external_key varchar2,
    pattern_key varchar2,
    type_key varchar2,
    realized_expression varchar2,
    path varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    updated_by_id varchar2,
    uri varchar2,
    object_storage_url varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_entity_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_entity_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_entity_summary_t) NOT PERSISTABLE;

Results of a data entities listing. Data entities are representation of a dataset with a set of attributes.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_entity_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_count number,
  items dbms_cloud_oci_datacatalog_entity_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_collection_t (
    l_count number,
    items dbms_cloud_oci_datacatalog_entity_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Object describing an individual element of object lineage.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_lineage_object_t FORCE AUTHID CURRENT_USER IS OBJECT (
  object_key varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  is_intra_lineage_available number,
  parent_key varchar2(32767),
  parent_path varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  type_name varchar2(32767),
  type_key varchar2(32767),
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_lineage_object_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_lineage_object_t (
    object_key varchar2,
    display_name varchar2,
    description varchar2,
    is_intra_lineage_available number,
    parent_key varchar2,
    parent_path varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    type_name varchar2,
    type_key varchar2,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Declares how two elements of object lineage are related.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_datacatalog_lineage_object_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_lineage_object_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_lineage_object_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_datacatalog_lineage_relationship_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_lineage_relationship_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_lineage_relationship_t) NOT PERSISTABLE;

Lineage for a data entity.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_entity_lineage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_level number,
  direction varchar2(32767),
  objects dbms_cloud_oci_datacatalog_lineage_object_tbl,
  relationships dbms_cloud_oci_datacatalog_lineage_relationship_tbl,
  annotations json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_lineage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_lineage_t (
    l_level number,
    direction varchar2,
    objects dbms_cloud_oci_datacatalog_lineage_object_tbl,
    relationships dbms_cloud_oci_datacatalog_lineage_relationship_tbl,
    annotations json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Represents an association of an entity to a term.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_entity_tag_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_key varchar2(32767),
  key varchar2(32767),
  name varchar2(32767),
  term_key varchar2(32767),
  term_path varchar2(32767),
  term_description varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  created_by_id varchar2(32767),
  uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_tag_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_tag_t (
    entity_key varchar2,
    key varchar2,
    name varchar2,
    term_key varchar2,
    term_path varchar2,
    term_description varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    created_by_id varchar2,
    uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of an entity tag.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_entity_tag_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_key varchar2(32767),
  key varchar2(32767),
  time_created timestamp with time zone,
  name varchar2(32767),
  uri varchar2(32767),
  term_key varchar2(32767),
  term_path varchar2(32767),
  term_description varchar2(32767),
  glossary_key varchar2(32767),
  lifecycle_state varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_tag_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_tag_summary_t (
    entity_key varchar2,
    key varchar2,
    time_created timestamp with time zone,
    name varchar2,
    uri varchar2,
    term_key varchar2,
    term_path varchar2,
    term_description varchar2,
    glossary_key varchar2,
    lifecycle_state varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_entity_tag_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_entity_tag_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_entity_tag_summary_t) NOT PERSISTABLE;

Results of an entity tags listing. Entity tags allow assciation of business terms with entities.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_entity_tag_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_count number,
  items dbms_cloud_oci_datacatalog_entity_tag_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_tag_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_entity_tag_collection_t (
    l_count number,
    items dbms_cloud_oci_datacatalog_entity_tag_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Error Information.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_datacatalog_data_asset_export_scope_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_data_asset_export_scope_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_data_asset_export_scope_t) NOT PERSISTABLE;

The details of what needs to be exported.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_export_data_asset_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  export_scope dbms_cloud_oci_datacatalog_data_asset_export_scope_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_export_data_asset_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_export_data_asset_details_t (
    export_scope dbms_cloud_oci_datacatalog_data_asset_export_scope_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Aggregation/facets on properties of data object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_faceted_search_aggregation_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  aggregation json_element_t,
  data_type varchar2(32767),
  property_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_faceted_search_aggregation_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_faceted_search_aggregation_t (
    l_type varchar2,
    aggregation json_element_t,
    data_type varchar2,
    property_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about custom property

Syntax

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

Fields

Object with date filter criteria

Syntax

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

Fields

Object with string filter criteria

Syntax

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

Fields

Nested table type of dbms_cloud_oci_datacatalog_faceted_search_date_filter_request_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_faceted_search_date_filter_request_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_faceted_search_date_filter_request_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_datacatalog_faceted_search_string_filter_request_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_faceted_search_string_filter_request_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_faceted_search_string_filter_request_t) NOT PERSISTABLE;

Object with details about filter criteria.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_faceted_search_filter_request_t FORCE AUTHID CURRENT_USER IS OBJECT (
  search_date_filters dbms_cloud_oci_datacatalog_faceted_search_date_filter_request_tbl,
  search_string_filters dbms_cloud_oci_datacatalog_faceted_search_string_filter_request_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_faceted_search_filter_request_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_faceted_search_filter_request_t (
    search_date_filters dbms_cloud_oci_datacatalog_faceted_search_date_filter_request_tbl,
    search_string_filters dbms_cloud_oci_datacatalog_faceted_search_string_filter_request_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Object with sort criteria details

Syntax

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

Fields

The information needed to obtain desired lineage.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_fetch_entity_lineage_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_level number,
  direction varchar2(32767),
  is_intra_lineage number,
  intra_lineage_object_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_fetch_entity_lineage_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_fetch_entity_lineage_details_t (
    l_level number,
    direction varchar2,
    is_intra_lineage number,
    intra_lineage_object_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A generic term used in the data catalog for an external organization concept used for a collection of data entities or processes within a data asset. This term is an internal term which models multiple external types of folder, such as file directories, database schemas, and so on. Some data assets, such as Object Store containers, may contain many levels of folders.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_folder_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  business_name varchar2(32767),
  description varchar2(32767),
  parent_folder_key varchar2(32767),
  type_key varchar2(32767),
  time_harvested timestamp with time zone,
  object_relationships dbms_cloud_oci_datacatalog_object_relationship_tbl,
  path varchar2(32767),
  data_asset_key varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
  properties json_element_t,
  external_key varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  created_by_id varchar2(32767),
  updated_by_id varchar2(32767),
  time_external timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  harvest_status varchar2(32767),
  last_job_key varchar2(32767),
  uri varchar2(32767),
  object_storage_url varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_folder_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_folder_t (
    key varchar2,
    display_name varchar2,
    business_name varchar2,
    description varchar2,
    parent_folder_key varchar2,
    type_key varchar2,
    time_harvested timestamp with time zone,
    object_relationships dbms_cloud_oci_datacatalog_object_relationship_tbl,
    path varchar2,
    data_asset_key varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
    properties json_element_t,
    external_key varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    created_by_id varchar2,
    updated_by_id varchar2,
    time_external timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    harvest_status varchar2,
    last_job_key varchar2,
    uri varchar2,
    object_storage_url varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a folder. A generic term used in the data catalog for an external organization concept used for a collection of data entities or processes within a data asset. This term is an internal term which models multiple external types of folder, such as file directories, database schemas, and so on. Some data assets, such as Object Store containers, may contain many levels of folders.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_folder_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  business_name varchar2(32767),
  description varchar2(32767),
  data_asset_key varchar2(32767),
  parent_folder_key varchar2(32767),
  type_key varchar2(32767),
  path varchar2(32767),
  external_key varchar2(32767),
  time_external timestamp with time zone,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  uri varchar2(32767),
  object_storage_url varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_folder_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_folder_summary_t (
    key varchar2,
    display_name varchar2,
    business_name varchar2,
    description varchar2,
    data_asset_key varchar2,
    parent_folder_key varchar2,
    type_key varchar2,
    path varchar2,
    external_key varchar2,
    time_external timestamp with time zone,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    uri varchar2,
    object_storage_url varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_folder_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_folder_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_folder_summary_t) NOT PERSISTABLE;

Results of a folders listing. Folders are external organization concept that groups data entities.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_folder_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_count number,
  items dbms_cloud_oci_datacatalog_folder_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_folder_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_folder_collection_t (
    l_count number,
    items dbms_cloud_oci_datacatalog_folder_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Represents an association of a folder to a term.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_folder_tag_t FORCE AUTHID CURRENT_USER IS OBJECT (
  folder_key varchar2(32767),
  key varchar2(32767),
  name varchar2(32767),
  term_key varchar2(32767),
  term_path varchar2(32767),
  term_description varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  created_by_id varchar2(32767),
  uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_folder_tag_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_folder_tag_t (
    folder_key varchar2,
    key varchar2,
    name varchar2,
    term_key varchar2,
    term_path varchar2,
    term_description varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    created_by_id varchar2,
    uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a folder tag.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_folder_tag_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  folder_key varchar2(32767),
  key varchar2(32767),
  time_created timestamp with time zone,
  name varchar2(32767),
  uri varchar2(32767),
  term_key varchar2(32767),
  term_path varchar2(32767),
  term_description varchar2(32767),
  glossary_key varchar2(32767),
  lifecycle_state varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_folder_tag_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_folder_tag_summary_t (
    folder_key varchar2,
    key varchar2,
    time_created timestamp with time zone,
    name varchar2,
    uri varchar2,
    term_key varchar2,
    term_path varchar2,
    term_description varchar2,
    glossary_key varchar2,
    lifecycle_state varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_folder_tag_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_folder_tag_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_folder_tag_summary_t) NOT PERSISTABLE;

Results of a folders tag listing. Folder tags allow association of folder objects to business terms.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_folder_tag_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_count number,
  items dbms_cloud_oci_datacatalog_folder_tag_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_folder_tag_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_folder_tag_collection_t (
    l_count number,
    items dbms_cloud_oci_datacatalog_folder_tag_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Full glossary details. A glossary of business terms, such as 'Customer', 'Account', 'Contact' , 'Address', or 'Product', with definitions, used to provide common meaning across disparate data assets. Business glossaries may be hierarchical where some terms may contain child terms to allow them to be used as 'taxonomies'. By linking data assets, data entities, and attributes to glossaries and glossary terms, the glossary can act as a way of organizing data catalog objects in a hierarchy to make a large number of objects more navigable and easier to consume. Objects in the data aatalog, such as data assets or data entities, may be linked to any level in the glossary, so that the glossary can be used to browse the available data according to the business model of the organization.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_glossary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  catalog_id varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  created_by_id varchar2(32767),
  updated_by_id varchar2(32767),
  owner varchar2(32767),
  workflow_status varchar2(32767),
  custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
  import_job_definition_key varchar2(32767),
  import_job_key varchar2(32767),
  latest_import_job_execution_key varchar2(32767),
  latest_import_job_execution_status varchar2(32767),
  uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_glossary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_glossary_t (
    key varchar2,
    display_name varchar2,
    description varchar2,
    catalog_id varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    created_by_id varchar2,
    updated_by_id varchar2,
    owner varchar2,
    workflow_status varchar2,
    custom_property_members dbms_cloud_oci_datacatalog_custom_property_get_usage_tbl,
    import_job_definition_key varchar2,
    import_job_key varchar2,
    latest_import_job_execution_key varchar2,
    latest_import_job_execution_status varchar2,
    uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a glossary. A glossary of business terms, such as 'Customer', 'Account', 'Contact', 'Address', or 'Product', with definitions, used to provide common meaning across disparate data assets. Business glossaries may be hierarchical where some terms may contain child terms to allow them to be used as 'taxonomies'. By linking data assets, data entities, and attributes to glossaries and glossary terms, the glossary can act as a way of organizing data catalog objects in a hierarchy to make a large number of objects more navigable and easier to consume. Objects in the data catalog, such as data assets or data entities, may be linked to any level in the glossary, so that the glossary can be used to browse the available data according to the business model of the organization.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_glossary_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  catalog_id varchar2(32767),
  time_created timestamp with time zone,
  description varchar2(32767),
  uri varchar2(32767),
  workflow_status varchar2(32767),
  lifecycle_state varchar2(32767),
  import_job_definition_key varchar2(32767),
  import_job_key varchar2(32767),
  latest_import_job_execution_key varchar2(32767),
  latest_import_job_execution_status varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_glossary_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_glossary_summary_t (
    key varchar2,
    display_name varchar2,
    catalog_id varchar2,
    time_created timestamp with time zone,
    description varchar2,
    uri varchar2,
    workflow_status varchar2,
    lifecycle_state varchar2,
    import_job_definition_key varchar2,
    import_job_key varchar2,
    latest_import_job_execution_key varchar2,
    latest_import_job_execution_status varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_glossary_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_glossary_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_glossary_summary_t) NOT PERSISTABLE;

Results of a glossaries listing. Glossary is an organizing concept for business terms to provide a unified semantic model across disparate data assets.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_glossary_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_count number,
  items dbms_cloud_oci_datacatalog_glossary_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_glossary_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_glossary_collection_t (
    l_count number,
    items dbms_cloud_oci_datacatalog_glossary_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Permissions object for glosssaries.

Syntax

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

Fields

Glossary tree element with child terms.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_glossary_tree_element_abs_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  glossary_key varchar2(32767),
  uri varchar2(32767),
  parent_term_key varchar2(32767),
  is_allowed_to_have_child_terms number,
  path varchar2(32767),
  time_created timestamp with time zone,
  workflow_status varchar2(32767),
  associated_object_count number,
  lifecycle_state varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_glossary_tree_element_abs_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_glossary_tree_element_abs_t (
    key varchar2,
    display_name varchar2,
    description varchar2,
    glossary_key varchar2,
    uri varchar2,
    parent_term_key varchar2,
    is_allowed_to_have_child_terms number,
    path varchar2,
    time_created timestamp with time zone,
    workflow_status varchar2,
    associated_object_count number,
    lifecycle_state varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Nested table type of dbms_cloud_oci_datacatalog_glossary_tree_element_abs_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_glossary_tree_element_abs_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_glossary_tree_element_abs_t) NOT PERSISTABLE;

Glossary tree element with child terms.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_glossary_tree_element_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_datacatalog_glossary_tree_element_abs_t (
  child_terms dbms_cloud_oci_datacatalog_glossary_tree_element_abs_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_glossary_tree_element_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_glossary_tree_element_t (
    key varchar2,
    display_name varchar2,
    description varchar2,
    glossary_key varchar2,
    uri varchar2,
    parent_term_key varchar2,
    is_allowed_to_have_child_terms number,
    path varchar2,
    time_created timestamp with time zone,
    workflow_status varchar2,
    associated_object_count number,
    lifecycle_state varchar2,
    child_terms dbms_cloud_oci_datacatalog_glossary_tree_element_abs_tbl
  ) RETURN SELF AS RESULT
);

Fields

Nested table type of dbms_cloud_oci_datacatalog_glossary_tree_element_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_glossary_tree_element_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_glossary_tree_element_t) NOT PERSISTABLE;

Import connection from the connection metadata and oracle wallet file.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_import_connection_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  connection_detail dbms_cloud_oci_datacatalog_create_connection_details_t,
  connection_payload clob,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_import_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_import_connection_details_t (
    connection_detail dbms_cloud_oci_datacatalog_create_connection_details_t,
    connection_payload clob
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Specifies the file contents to be imported.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_import_data_asset_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  import_file_contents clob,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_import_data_asset_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_import_data_asset_details_t (
    import_file_contents clob
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Information about a data asset import operation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_import_data_asset_job_result_t FORCE AUTHID CURRENT_USER IS OBJECT (
  data_asset_key varchar2(32767),
  import_job_definition_key varchar2(32767),
  import_job_key varchar2(32767),
  import_job_execution_key varchar2(32767),
  import_job_execution_status varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_import_data_asset_job_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_import_data_asset_job_result_t (
    data_asset_key varchar2,
    import_job_definition_key varchar2,
    import_job_key varchar2,
    import_job_execution_key varchar2,
    import_job_execution_status varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Import glossary from the contents of the glossary definition file.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_import_glossary_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  glossary_file_contents clob,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_import_glossary_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_import_glossary_details_t (
    glossary_file_contents clob
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of a job. Jobs are scheduled instances of a job definition.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_job_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  catalog_id varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  job_type varchar2(32767),
  schedule_cron_expression varchar2(32767),
  time_schedule_begin timestamp with time zone,
  time_schedule_end timestamp with time zone,
  schedule_type varchar2(32767),
  connection_key varchar2(32767),
  job_definition_key varchar2(32767),
  internal_version varchar2(32767),
  execution_count number,
  time_of_latest_execution timestamp with time zone,
  created_by_id varchar2(32767),
  updated_by_id varchar2(32767),
  job_definition_name varchar2(32767),
  data_asset_key varchar2(32767),
  glossary_key varchar2(32767),
  error_code varchar2(32767),
  error_message varchar2(32767),
  uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_job_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_job_t (
    key varchar2,
    display_name varchar2,
    description varchar2,
    catalog_id varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    job_type varchar2,
    schedule_cron_expression varchar2,
    time_schedule_begin timestamp with time zone,
    time_schedule_end timestamp with time zone,
    schedule_type varchar2,
    connection_key varchar2,
    job_definition_key varchar2,
    internal_version varchar2,
    execution_count number,
    time_of_latest_execution timestamp with time zone,
    created_by_id varchar2,
    updated_by_id varchar2,
    job_definition_name varchar2,
    data_asset_key varchar2,
    glossary_key varchar2,
    error_code varchar2,
    error_message varchar2,
    uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A list of job executions. A job execution is a unit of work being executed on behalf of a job.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_job_execution_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  job_key varchar2(32767),
  job_type varchar2(32767),
  parent_key varchar2(32767),
  schedule_instance_key varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  time_started timestamp with time zone,
  time_ended timestamp with time zone,
  uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_job_execution_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_job_execution_summary_t (
    key varchar2,
    job_key varchar2,
    job_type varchar2,
    parent_key varchar2,
    schedule_instance_key varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    time_started timestamp with time zone,
    time_ended timestamp with time zone,
    uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_job_execution_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_job_execution_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_job_execution_summary_t) NOT PERSISTABLE;

Details of a job. Jobs are scheduled instances of a job definition.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_job_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  uri varchar2(32767),
  display_name varchar2(32767),
  catalog_id varchar2(32767),
  job_definition_key varchar2(32767),
  lifecycle_state varchar2(32767),
  job_type varchar2(32767),
  schedule_type varchar2(32767),
  description varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  created_by_id varchar2(32767),
  updated_by_id varchar2(32767),
  schedule_cron_expression varchar2(32767),
  time_schedule_begin timestamp with time zone,
  execution_count number,
  time_of_latest_execution timestamp with time zone,
  job_definition_name varchar2(32767),
  data_asset_key varchar2(32767),
  glossary_key varchar2(32767),
  error_code varchar2(32767),
  error_message varchar2(32767),
  executions dbms_cloud_oci_datacatalog_job_execution_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_job_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_job_summary_t (
    key varchar2,
    uri varchar2,
    display_name varchar2,
    catalog_id varchar2,
    job_definition_key varchar2,
    lifecycle_state varchar2,
    job_type varchar2,
    schedule_type varchar2,
    description varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    created_by_id varchar2,
    updated_by_id varchar2,
    schedule_cron_expression varchar2,
    time_schedule_begin timestamp with time zone,
    execution_count number,
    time_of_latest_execution timestamp with time zone,
    job_definition_name varchar2,
    data_asset_key varchar2,
    glossary_key varchar2,
    error_code varchar2,
    error_message varchar2,
    executions dbms_cloud_oci_datacatalog_job_execution_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datacatalog_job_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_job_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datacatalog_job_summary_t) NOT PERSISTABLE;

Results of a jobs listing. Jobs are scheduled instances of a job definition.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_job_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_count number,
  items dbms_cloud_oci_datacatalog_job_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_job_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_job_collection_t (
    l_count number,
    items dbms_cloud_oci_datacatalog_job_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Representation of a job definition resource. Job definitions define the harvest scope and includes the list of objects to be harvested along with a schedule. The list of objects is usually specified through a combination of object type, regular expressions, or specific names of objects and a sample size for the data harvested.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_job_definition_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  catalog_id varchar2(32767),
  job_type varchar2(32767),
  is_incremental number,
  data_asset_key varchar2(32767),
  glossary_key varchar2(32767),
  description varchar2(32767),
  connection_key varchar2(32767),
  internal_version varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  created_by_id varchar2(32767),
  updated_by_id varchar2(32767),
  uri varchar2(32767),
  is_sample_data_extracted number,
  sample_data_size_in_m_bs number,
  time_latest_execution_started timestamp with time zone,
  time_latest_execution_ended timestamp with time zone,
  job_execution_state varchar2(32767),
  schedule_type varchar2(32767),
  properties json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_job_definition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_job_definition_t (
    key varchar2,
    display_name varchar2,
    catalog_id varchar2,
    job_type varchar2,
    is_incremental number,
    data_asset_key varchar2,
    glossary_key varchar2,
    description varchar2,
    connection_key varchar2,
    internal_version varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    created_by_id varchar2,
    updated_by_id varchar2,
    uri varchar2,
    is_sample_data_extracted number,
    sample_data_size_in_m_bs number,
    time_latest_execution_started timestamp with time zone,
    time_latest_execution_ended timestamp with time zone,
    job_execution_state varchar2,
    schedule_type varchar2,
    properties json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A list of job definition resources. Job definitions define the harvest scope and includes the list of objects to be harvested along with a schedule. The list of objects is usually specified through a combination of object type, regular expressions, or specific names of objects and a sample size for the data harvested.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datacatalog_job_definition_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  catalog_id varchar2(32767),
  uri varchar2(32767),
  job_type varchar2(32767),
  lifecycle_state varchar2(32767),
  is_sample_data_extracted number,
  time_created timestamp with time zone,
  connection_key varchar2(32767),
  time_latest_execution_started timestamp with time zone,
  time_latest_execution_ended timestamp with time zone,
  job_execution_state varchar2(32767),
  schedule_type varchar2(32767),
  data_asset_key varchar2(32767),
  glossary_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_job_definition_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datacatalog_job_definition_summary_t (
    key varchar2,
    display_name varchar2,
    description varchar2,
    catalog_id varchar2,
    uri varchar2,
    job_type varchar2,
    lifecycle_state varchar2,
    is_sample_data_extracted number,
    time_created timestamp with time zone,
    connection_key varchar2,
    time_latest_execution_started timestamp with time zone,
    time_latest_execution_ended timestamp with time zone,
    job_execution_state varchar2,
    schedule_type varchar2,
    data_asset_key varchar2,
    glossary_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields