DTS Common Types

DBMS_CLOUD_OCI_DTS_VARCHAR2_TBL Type

Nested table type of varchar2(32767).

Syntax

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

DBMS_CLOUD_OCI_DTS_SHIPPING_ADDRESS_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_shipping_address_t FORCE AUTHID CURRENT_USER IS OBJECT (
  addressee varchar2(32767),
  care_of varchar2(32767),
  address1 varchar2(32767),
  address2 varchar2(32767),
  address3 varchar2(32767),
  address4 varchar2(32767),
  city_or_locality varchar2(32767),
  state_or_region varchar2(32767),
  zipcode varchar2(32767),
  country varchar2(32767),
  phone_number varchar2(32767),
  email varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_shipping_address_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_shipping_address_t (
    addressee varchar2,
    care_of varchar2,
    address1 varchar2,
    address2 varchar2,
    address3 varchar2,
    address4 varchar2,
    city_or_locality varchar2,
    state_or_region varchar2,
    zipcode varchar2,
    country varchar2,
    phone_number varchar2,
    email varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

addressee

(required)

care_of

(optional)

address1

(required)

address2

(optional)

address3

(optional)

address4

(optional)

city_or_locality

(required)

state_or_region

(required)

zipcode

(required)

country

(required)

phone_number

(optional)

email

(optional)

DBMS_CLOUD_OCI_DTS_APPLIANCE_EXPORT_JOB_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_appliance_export_job_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  bucket_name varchar2(32767),
  display_name varchar2(32767),
  creation_time timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_state_details varchar2(32767),
  appliance_serial_number varchar2(32767),
  appliance_decryption_passphrase varchar2(32767),
  appliance_delivery_vendor varchar2(32767),
  appliance_delivery_tracking_number varchar2(32767),
  appliance_return_delivery_tracking_number varchar2(32767),
  sending_security_tie varchar2(32767),
  receiving_security_tie varchar2(32767),
  prefix varchar2(32767),
  range_start varchar2(32767),
  range_end varchar2(32767),
  number_of_objects varchar2(32767),
  total_size_in_bytes varchar2(32767),
  first_object varchar2(32767),
  last_object varchar2(32767),
  next_object varchar2(32767),
  manifest_file varchar2(32767),
  manifest_md5 varchar2(32767),
  bucket_access_policies dbms_cloud_oci_dts_varchar2_tbl,
  return_shipping_label_uri varchar2(32767),
  expected_return_date timestamp with time zone,
  pickup_window_start_time timestamp with time zone,
  pickup_window_end_time timestamp with time zone,
  customer_shipping_address dbms_cloud_oci_dts_shipping_address_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_appliance_export_job_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_appliance_export_job_t (
    id varchar2,
    compartment_id varchar2,
    bucket_name varchar2,
    display_name varchar2,
    creation_time timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_state_details varchar2,
    appliance_serial_number varchar2,
    appliance_decryption_passphrase varchar2,
    appliance_delivery_vendor varchar2,
    appliance_delivery_tracking_number varchar2,
    appliance_return_delivery_tracking_number varchar2,
    sending_security_tie varchar2,
    receiving_security_tie varchar2,
    prefix varchar2,
    range_start varchar2,
    range_end varchar2,
    number_of_objects varchar2,
    total_size_in_bytes varchar2,
    first_object varchar2,
    last_object varchar2,
    next_object varchar2,
    manifest_file varchar2,
    manifest_md5 varchar2,
    bucket_access_policies dbms_cloud_oci_dts_varchar2_tbl,
    return_shipping_label_uri varchar2,
    expected_return_date timestamp with time zone,
    pickup_window_start_time timestamp with time zone,
    pickup_window_end_time timestamp with time zone,
    customer_shipping_address dbms_cloud_oci_dts_shipping_address_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

id

(required)

compartment_id

(optional)

bucket_name

(optional)

display_name

(optional)

creation_time

(optional)

lifecycle_state

(optional)

Allowed values are: 'CREATING', 'ACTIVE', 'INPROGRESS', 'SUCCEEDED', 'FAILED', 'CANCELLED', 'DELETED'

lifecycle_state_details

(optional) A property that can contain details on the lifecycle.

appliance_serial_number

(optional) Serial Number of the Appliance associated with this Export Job.

appliance_decryption_passphrase

(optional) Passphrase associated with the Appliance.

appliance_delivery_vendor

(optional) Shipping Vendor selected to ship the Appliance associated with this job.

appliance_delivery_tracking_number

(optional) Tracking number associated with the shipment while shipping the Appliance to Customer.

appliance_return_delivery_tracking_number

(optional) Tracking number associated with the shipment while shipping the Appliance back to Oracle.

sending_security_tie

(optional) Unique number associated with the security tie used to seal the Appliance case.

receiving_security_tie

(optional) Unique number associated with the return security tie used to seal the Appliance case.

prefix

(optional) List of objects with names matching this prefix would be part of this export job.

range_start

(optional) The name of the first object in the range of objects that are expected to be part of this export job.

range_end

(optional) The name of the last object in the range of objects that are expected to be part of this export job.

number_of_objects

(optional) Total number of objects that are exported in this job.

total_size_in_bytes

(optional) Total size of objects in Bytes that are exported in this job.

first_object

(optional) First object in the list of objects that are exported in this job.

last_object

(optional) Last object in the list of objects that are exported in this job.

next_object

(optional) First object from which the next potential export job could start.

manifest_file

(optional) Url of the Manifest File associated with this export job.

manifest_md5

(optional) md5 digest of the manifest file.

bucket_access_policies

(optional) Polices to grant Data Transfer Service to access objects in the Bucket

return_shipping_label_uri

(optional)

expected_return_date

(optional) Expected return date from customer for the device, time portion should be zero.

pickup_window_start_time

(optional) Start time for the window to pickup the device from customer.

pickup_window_end_time

(optional) End time for the window to pickup the device from customer.

customer_shipping_address

(optional)

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

DBMS_CLOUD_OCI_DTS_APPLIANCE_EXPORT_JOB_SUMMARY_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_appliance_export_job_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  bucket_name varchar2(32767),
  display_name varchar2(32767),
  creation_time timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_state_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_appliance_export_job_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_appliance_export_job_summary_t (
    id varchar2,
    bucket_name varchar2,
    display_name varchar2,
    creation_time timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_state_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

id

(optional)

bucket_name

(optional)

display_name

(optional)

creation_time

(optional)

lifecycle_state

(optional)

Allowed values are: 'CREATING', 'ACTIVE', 'INPROGRESS', 'SUCCEEDED', 'FAILED', 'CANCELLED', 'DELETED'

lifecycle_state_details

(optional) A property that can contain details on the lifecycle.

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

DBMS_CLOUD_OCI_DTS_ATTACH_DEVICES_DETAILS_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_attach_devices_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  device_labels dbms_cloud_oci_dts_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_attach_devices_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_attach_devices_details_t (
    device_labels dbms_cloud_oci_dts_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

device_labels

(optional) List of TransferDeviceLabel's

DBMS_CLOUD_OCI_DTS_CHANGE_APPLIANCE_EXPORT_JOB_COMPARTMENT_DETAILS_T Type

Syntax

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

Fields

Field Description

compartment_id

(required) The OCID] of the compartment into which the resources should be moved.

DBMS_CLOUD_OCI_DTS_CHANGE_TRANSFER_JOB_COMPARTMENT_DETAILS_T Type

Syntax

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

Fields

Field Description

compartment_id

(required) The OCID] of the compartment into which the resources should be moved.

DBMS_CLOUD_OCI_DTS_CREATE_APPLIANCE_EXPORT_JOB_DETAILS_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_create_appliance_export_job_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  bucket_name varchar2(32767),
  display_name varchar2(32767),
  prefix varchar2(32767),
  range_start varchar2(32767),
  range_end varchar2(32767),
  customer_shipping_address dbms_cloud_oci_dts_shipping_address_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_create_appliance_export_job_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_create_appliance_export_job_details_t (
    compartment_id varchar2,
    bucket_name varchar2,
    display_name varchar2,
    prefix varchar2,
    range_start varchar2,
    range_end varchar2,
    customer_shipping_address dbms_cloud_oci_dts_shipping_address_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

compartment_id

(required)

bucket_name

(required)

display_name

(required)

prefix

(optional) List of objects with names matching this prefix would be part of this export job.

range_start

(optional) Object names returned by a list query must be greater or equal to this parameter.

range_end

(optional) Object names returned by a list query must be strictly less than this parameter.

customer_shipping_address

(required)

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

DBMS_CLOUD_OCI_DTS_CREATE_TRANSFER_APPLIANCE_DETAILS_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_create_transfer_appliance_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  customer_shipping_address dbms_cloud_oci_dts_shipping_address_t,
  minimum_storage_capacity_in_terabytes number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_create_transfer_appliance_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_create_transfer_appliance_details_t (
    customer_shipping_address dbms_cloud_oci_dts_shipping_address_t,
    minimum_storage_capacity_in_terabytes number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

customer_shipping_address

(optional)

minimum_storage_capacity_in_terabytes

(optional) Minimum storage capacity of the device, in terabytes. Valid options are 50, 95 and 150.

DBMS_CLOUD_OCI_DTS_CREATE_TRANSFER_APPLIANCE_ENTITLEMENT_DETAILS_T Type

Syntax

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

Fields

Field Description

compartment_id

(optional)

display_name

(optional)

requestor_name

(optional)

requestor_email

(optional)

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

DBMS_CLOUD_OCI_DTS_CREATE_TRANSFER_DEVICE_DETAILS_T Type

Syntax

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

Fields

Field Description

serial_number

(optional)

iscsi_iqn

(optional)

DBMS_CLOUD_OCI_DTS_CREATE_TRANSFER_JOB_DETAILS_T Type

Syntax

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

Fields

Field Description

compartment_id

(optional)

upload_bucket_name

(optional)

display_name

(optional)

device_type

(optional)

Allowed values are: 'DISK', 'APPLIANCE'

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

DBMS_CLOUD_OCI_DTS_CREATE_TRANSFER_PACKAGE_DETAILS_T Type

Syntax

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

Fields

Field Description

original_package_delivery_tracking_number

(optional)

return_package_delivery_tracking_number

(optional)

package_delivery_vendor

(optional)

DBMS_CLOUD_OCI_DTS_DETACH_DEVICES_DETAILS_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_detach_devices_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  device_labels dbms_cloud_oci_dts_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_detach_devices_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_detach_devices_details_t (
    device_labels dbms_cloud_oci_dts_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

device_labels

(optional) List of TransferDeviceLabel's

DBMS_CLOUD_OCI_DTS_ERROR_T Type

Syntax

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

Fields

Field Description

code

(required) A short error code that defines the error, meant for programmatic parsing. See API Errors.

message

(required) A human-readable error string.

DBMS_CLOUD_OCI_DTS_TRANSFER_APPLIANCE_SUMMARY_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_transfer_appliance_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  label varchar2(32767),
  lifecycle_state varchar2(32767),
  serial_number varchar2(32767),
  creation_time timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_appliance_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_appliance_summary_t (
    label varchar2,
    lifecycle_state varchar2,
    serial_number varchar2,
    creation_time timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

label

(optional)

lifecycle_state

(optional)

Allowed values are: 'REQUESTED', 'ORACLE_PREPARING', 'SHIPPING', 'DELIVERED', 'PREPARING', 'FINALIZED', 'RETURN_LABEL_REQUESTED', 'RETURN_LABEL_GENERATING', 'RETURN_LABEL_AVAILABLE', 'RETURN_DELAYED', 'RETURN_SHIPPED', 'RETURN_SHIPPED_CANCELLED', 'ORACLE_RECEIVED', 'ORACLE_RECEIVED_CANCELLED', 'PROCESSING', 'COMPLETE', 'CUSTOMER_NEVER_RECEIVED', 'ORACLE_NEVER_RECEIVED', 'CUSTOMER_LOST', 'CANCELLED', 'DELETED', 'REJECTED', 'ERROR'

serial_number

(optional)

creation_time

(optional)

DBMS_CLOUD_OCI_DTS_TRANSFER_APPLIANCE_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_dts_transfer_appliance_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_transfer_appliance_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_dts_transfer_appliance_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_DTS_MULTIPLE_TRANSFER_APPLIANCES_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_multiple_transfer_appliances_t FORCE AUTHID CURRENT_USER IS OBJECT (
  transfer_appliance_objects dbms_cloud_oci_dts_transfer_appliance_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_multiple_transfer_appliances_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_multiple_transfer_appliances_t (
    transfer_appliance_objects dbms_cloud_oci_dts_transfer_appliance_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

transfer_appliance_objects

(optional) List of TransferAppliance summary's

DBMS_CLOUD_OCI_DTS_TRANSFER_DEVICE_SUMMARY_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_transfer_device_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  serial_number varchar2(32767),
  iscsi_iqn varchar2(32767),
  label varchar2(32767),
  lifecycle_state varchar2(32767),
  attached_transfer_package_label varchar2(32767),
  creation_time timestamp with time zone,
  upload_status_log_uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_device_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_device_summary_t (
    serial_number varchar2,
    iscsi_iqn varchar2,
    label varchar2,
    lifecycle_state varchar2,
    attached_transfer_package_label varchar2,
    creation_time timestamp with time zone,
    upload_status_log_uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

serial_number

(optional)

iscsi_iqn

(optional)

label

(optional)

lifecycle_state

(optional)

Allowed values are: 'PREPARING', 'READY', 'PACKAGED', 'ACTIVE', 'PROCESSING', 'COMPLETE', 'MISSING', 'ERROR', 'DELETED', 'CANCELLED'

attached_transfer_package_label

(optional)

creation_time

(optional)

upload_status_log_uri

(optional)

DBMS_CLOUD_OCI_DTS_TRANSFER_DEVICE_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_dts_transfer_device_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_transfer_device_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_dts_transfer_device_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_DTS_MULTIPLE_TRANSFER_DEVICES_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_multiple_transfer_devices_t FORCE AUTHID CURRENT_USER IS OBJECT (
  transfer_device_objects dbms_cloud_oci_dts_transfer_device_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_multiple_transfer_devices_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_multiple_transfer_devices_t (
    transfer_device_objects dbms_cloud_oci_dts_transfer_device_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

transfer_device_objects

(optional) List of TransferDeviceObject's

DBMS_CLOUD_OCI_DTS_TRANSFER_PACKAGE_SUMMARY_T Type

Syntax

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

Fields

Field Description

label

(optional)

lifecycle_state

(optional)

Allowed values are: 'PREPARING', 'SHIPPING', 'RECEIVED', 'PROCESSING', 'PROCESSED', 'RETURNED', 'DELETED', 'CANCELLED', 'CANCELLED_RETURNED'

creation_time

(optional)

DBMS_CLOUD_OCI_DTS_TRANSFER_PACKAGE_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_dts_transfer_package_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_transfer_package_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_dts_transfer_package_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_DTS_MULTIPLE_TRANSFER_PACKAGES_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_multiple_transfer_packages_t FORCE AUTHID CURRENT_USER IS OBJECT (
  transfer_package_objects dbms_cloud_oci_dts_transfer_package_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_multiple_transfer_packages_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_multiple_transfer_packages_t (
    transfer_package_objects dbms_cloud_oci_dts_transfer_package_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

transfer_package_objects

(optional) List of TransferPackage summary's

DBMS_CLOUD_OCI_DTS_NEW_TRANSFER_DEVICE_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_new_transfer_device_t FORCE AUTHID CURRENT_USER IS OBJECT (
  label varchar2(32767),
  serial_number varchar2(32767),
  iscsi_iqn varchar2(32767),
  lifecycle_state varchar2(32767),
  encryption_passphrase varchar2(32767),
  transfer_job_id varchar2(32767),
  creation_time timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_new_transfer_device_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_new_transfer_device_t (
    label varchar2,
    serial_number varchar2,
    iscsi_iqn varchar2,
    lifecycle_state varchar2,
    encryption_passphrase varchar2,
    transfer_job_id varchar2,
    creation_time timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

label

(required)

serial_number

(optional)

iscsi_iqn

(optional)

lifecycle_state

(optional)

Allowed values are: 'PREPARING'

encryption_passphrase

(optional)

transfer_job_id

(optional)

creation_time

(optional)

DBMS_CLOUD_OCI_DTS_SHIPPING_VENDORS_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_shipping_vendors_t FORCE AUTHID CURRENT_USER IS OBJECT (
  vendors dbms_cloud_oci_dts_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_shipping_vendors_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_shipping_vendors_t (
    vendors dbms_cloud_oci_dts_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

vendors

(optional) List of available shipping vendors for package delivery

DBMS_CLOUD_OCI_DTS_TRANSFER_APPLIANCE_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_transfer_appliance_t FORCE AUTHID CURRENT_USER IS OBJECT (
  label varchar2(32767),
  lifecycle_state varchar2(32767),
  transfer_job_id varchar2(32767),
  serial_number varchar2(32767),
  creation_time timestamp with time zone,
  customer_received_time timestamp with time zone,
  customer_returned_time timestamp with time zone,
  next_billing_time timestamp with time zone,
  delivery_security_tie_id varchar2(32767),
  return_security_tie_id varchar2(32767),
  appliance_delivery_tracking_number varchar2(32767),
  appliance_return_delivery_tracking_number varchar2(32767),
  appliance_delivery_vendor varchar2(32767),
  customer_shipping_address dbms_cloud_oci_dts_shipping_address_t,
  upload_status_log_uri varchar2(32767),
  return_shipping_label_uri varchar2(32767),
  expected_return_date timestamp with time zone,
  pickup_window_start_time timestamp with time zone,
  pickup_window_end_time timestamp with time zone,
  minimum_storage_capacity_in_terabytes number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_appliance_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_appliance_t (
    label varchar2,
    lifecycle_state varchar2,
    transfer_job_id varchar2,
    serial_number varchar2,
    creation_time timestamp with time zone,
    customer_received_time timestamp with time zone,
    customer_returned_time timestamp with time zone,
    next_billing_time timestamp with time zone,
    delivery_security_tie_id varchar2,
    return_security_tie_id varchar2,
    appliance_delivery_tracking_number varchar2,
    appliance_return_delivery_tracking_number varchar2,
    appliance_delivery_vendor varchar2,
    customer_shipping_address dbms_cloud_oci_dts_shipping_address_t,
    upload_status_log_uri varchar2,
    return_shipping_label_uri varchar2,
    expected_return_date timestamp with time zone,
    pickup_window_start_time timestamp with time zone,
    pickup_window_end_time timestamp with time zone,
    minimum_storage_capacity_in_terabytes number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

label

(required) Unique alpha-numeric identifier for a transfer appliance auto generated during create.

lifecycle_state

(optional)

Allowed values are: 'REQUESTED', 'ORACLE_PREPARING', 'SHIPPING', 'DELIVERED', 'PREPARING', 'FINALIZED', 'RETURN_LABEL_REQUESTED', 'RETURN_LABEL_GENERATING', 'RETURN_LABEL_AVAILABLE', 'RETURN_DELAYED', 'RETURN_SHIPPED', 'RETURN_SHIPPED_CANCELLED', 'ORACLE_RECEIVED', 'ORACLE_RECEIVED_CANCELLED', 'PROCESSING', 'COMPLETE', 'CUSTOMER_NEVER_RECEIVED', 'ORACLE_NEVER_RECEIVED', 'CUSTOMER_LOST', 'CANCELLED', 'DELETED', 'REJECTED', 'ERROR'

transfer_job_id

(optional)

serial_number

(optional)

creation_time

(optional)

customer_received_time

(optional)

customer_returned_time

(optional)

next_billing_time

(optional)

delivery_security_tie_id

(optional)

return_security_tie_id

(optional)

appliance_delivery_tracking_number

(optional)

appliance_return_delivery_tracking_number

(optional)

appliance_delivery_vendor

(optional)

customer_shipping_address

(optional)

upload_status_log_uri

(optional)

return_shipping_label_uri

(optional)

expected_return_date

(optional) Expected return date from customer for the device, time portion should be zero.

pickup_window_start_time

(optional) Start time for the window to pickup the device from customer.

pickup_window_end_time

(optional) End time for the window to pickup the device from customer.

minimum_storage_capacity_in_terabytes

(optional) Minimum storage capacity of the device, in terabytes. Valid options are 50, 95 and 150.

DBMS_CLOUD_OCI_DTS_TRANSFER_APPLIANCE_CERTIFICATE_T Type

Syntax

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

Fields

Field Description

certificate

(optional)

DBMS_CLOUD_OCI_DTS_TRANSFER_APPLIANCE_ENCRYPTION_PASSPHRASE_T Type

Syntax

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

Fields

Field Description

encryption_passphrase

(optional)

DBMS_CLOUD_OCI_DTS_TRANSFER_APPLIANCE_ENTITLEMENT_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_transfer_appliance_entitlement_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  requestor_name varchar2(32767),
  requestor_email varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_state_details varchar2(32767),
  creation_time timestamp with time zone,
  update_time timestamp with time zone,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_appliance_entitlement_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_appliance_entitlement_t (
    id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    requestor_name varchar2,
    requestor_email varchar2,
    lifecycle_state varchar2,
    lifecycle_state_details varchar2,
    creation_time timestamp with time zone,
    update_time timestamp with time zone,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

id

(optional)

compartment_id

(required)

display_name

(optional)

requestor_name

(optional)

requestor_email

(optional)

lifecycle_state

(required)

Allowed values are: 'CREATING', 'ACTIVE', 'INACTIVE', 'DELETED'

lifecycle_state_details

(optional) A property that can contain details on the lifecycle.

creation_time

(optional)

update_time

(optional)

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

DBMS_CLOUD_OCI_DTS_TRANSFER_APPLIANCE_ENTITLEMENT_SUMMARY_T Type

Syntax

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

Fields

Field Description

id

(optional)

compartment_id

(required)

display_name

(optional)

requestor_name

(optional)

requestor_email

(optional)

lifecycle_state

(required)

lifecycle_state_details

(optional) A property that can contain details on the lifecycle.

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

DBMS_CLOUD_OCI_DTS_TRANSFER_APPLIANCE_PUBLIC_KEY_T Type

Syntax

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

Fields

Field Description

public_key

(optional)

DBMS_CLOUD_OCI_DTS_TRANSFER_DEVICE_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_transfer_device_t FORCE AUTHID CURRENT_USER IS OBJECT (
  serial_number varchar2(32767),
  iscsi_iqn varchar2(32767),
  label varchar2(32767),
  lifecycle_state varchar2(32767),
  transfer_job_id varchar2(32767),
  attached_transfer_package_label varchar2(32767),
  creation_time timestamp with time zone,
  upload_status_log_uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_device_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_device_t (
    serial_number varchar2,
    iscsi_iqn varchar2,
    label varchar2,
    lifecycle_state varchar2,
    transfer_job_id varchar2,
    attached_transfer_package_label varchar2,
    creation_time timestamp with time zone,
    upload_status_log_uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

serial_number

(optional)

iscsi_iqn

(optional)

label

(required)

lifecycle_state

(optional)

Allowed values are: 'PREPARING', 'READY', 'PACKAGED', 'ACTIVE', 'PROCESSING', 'COMPLETE', 'MISSING', 'ERROR', 'DELETED', 'CANCELLED'

transfer_job_id

(optional)

attached_transfer_package_label

(optional)

creation_time

(optional)

upload_status_log_uri

(optional)

DBMS_CLOUD_OCI_DTS_TRANSFER_JOB_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_transfer_job_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  upload_bucket_name varchar2(32767),
  display_name varchar2(32767),
  label varchar2(32767),
  creation_time timestamp with time zone,
  device_type varchar2(32767),
  lifecycle_state varchar2(32767),
  attached_transfer_appliance_labels dbms_cloud_oci_dts_varchar2_tbl,
  attached_transfer_package_labels dbms_cloud_oci_dts_varchar2_tbl,
  attached_transfer_device_labels dbms_cloud_oci_dts_varchar2_tbl,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_job_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_job_t (
    id varchar2,
    compartment_id varchar2,
    upload_bucket_name varchar2,
    display_name varchar2,
    label varchar2,
    creation_time timestamp with time zone,
    device_type varchar2,
    lifecycle_state varchar2,
    attached_transfer_appliance_labels dbms_cloud_oci_dts_varchar2_tbl,
    attached_transfer_package_labels dbms_cloud_oci_dts_varchar2_tbl,
    attached_transfer_device_labels dbms_cloud_oci_dts_varchar2_tbl,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

id

(required)

compartment_id

(optional)

upload_bucket_name

(optional)

display_name

(optional)

label

(optional)

creation_time

(optional)

device_type

(optional)

Allowed values are: 'DISK', 'APPLIANCE'

lifecycle_state

(optional)

Allowed values are: 'INITIATED', 'PREPARING', 'ACTIVE', 'DELETED', 'CLOSED'

attached_transfer_appliance_labels

(optional) Transfer Appliance labels associated with this transfer Job

attached_transfer_package_labels

(optional) Transfer Package labels associated with this transfer Job

attached_transfer_device_labels

(optional) Transfer Device labels associated with this transfer Job

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

DBMS_CLOUD_OCI_DTS_TRANSFER_JOB_SUMMARY_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_transfer_job_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  upload_bucket_name varchar2(32767),
  display_name varchar2(32767),
  label varchar2(32767),
  device_type varchar2(32767),
  creation_time timestamp with time zone,
  lifecycle_state varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_job_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_job_summary_t (
    id varchar2,
    upload_bucket_name varchar2,
    display_name varchar2,
    label varchar2,
    device_type varchar2,
    creation_time timestamp with time zone,
    lifecycle_state varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

id

(optional)

upload_bucket_name

(optional)

display_name

(optional)

label

(optional)

device_type

(optional)

Allowed values are: 'DISK', 'APPLIANCE'

creation_time

(optional)

lifecycle_state

(optional)

Allowed values are: 'INITIATED', 'PREPARING', 'ACTIVE', 'DELETED', 'CLOSED'

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

DBMS_CLOUD_OCI_DTS_TRANSFER_PACKAGE_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_transfer_package_t FORCE AUTHID CURRENT_USER IS OBJECT (
  label varchar2(32767),
  lifecycle_state varchar2(32767),
  transfer_job_id varchar2(32767),
  creation_time timestamp with time zone,
  original_package_delivery_tracking_number varchar2(32767),
  return_package_delivery_tracking_number varchar2(32767),
  package_delivery_vendor varchar2(32767),
  transfer_site_shipping_address varchar2(32767),
  attached_transfer_device_labels dbms_cloud_oci_dts_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_package_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_transfer_package_t (
    label varchar2,
    lifecycle_state varchar2,
    transfer_job_id varchar2,
    creation_time timestamp with time zone,
    original_package_delivery_tracking_number varchar2,
    return_package_delivery_tracking_number varchar2,
    package_delivery_vendor varchar2,
    transfer_site_shipping_address varchar2,
    attached_transfer_device_labels dbms_cloud_oci_dts_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

label

(required)

lifecycle_state

(optional)

Allowed values are: 'PREPARING', 'SHIPPING', 'RECEIVED', 'PROCESSING', 'PROCESSED', 'RETURNED', 'DELETED', 'CANCELLED', 'CANCELLED_RETURNED'

transfer_job_id

(optional)

creation_time

(optional)

original_package_delivery_tracking_number

(optional)

return_package_delivery_tracking_number

(optional)

package_delivery_vendor

(optional)

transfer_site_shipping_address

(optional)

attached_transfer_device_labels

(optional) Transfer Devices attached to this Transfer Package

DBMS_CLOUD_OCI_DTS_UPDATE_APPLIANCE_EXPORT_JOB_DETAILS_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_update_appliance_export_job_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  bucket_name varchar2(32767),
  prefix varchar2(32767),
  range_start varchar2(32767),
  range_end varchar2(32767),
  display_name varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_state_details varchar2(32767),
  manifest_file varchar2(32767),
  manifest_md5 varchar2(32767),
  number_of_objects varchar2(32767),
  total_size_in_bytes varchar2(32767),
  first_object varchar2(32767),
  last_object varchar2(32767),
  next_object varchar2(32767),
  expected_return_date timestamp with time zone,
  pickup_window_start_time timestamp with time zone,
  pickup_window_end_time timestamp with time zone,
  customer_shipping_address dbms_cloud_oci_dts_shipping_address_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_update_appliance_export_job_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_update_appliance_export_job_details_t (
    bucket_name varchar2,
    prefix varchar2,
    range_start varchar2,
    range_end varchar2,
    display_name varchar2,
    lifecycle_state varchar2,
    lifecycle_state_details varchar2,
    manifest_file varchar2,
    manifest_md5 varchar2,
    number_of_objects varchar2,
    total_size_in_bytes varchar2,
    first_object varchar2,
    last_object varchar2,
    next_object varchar2,
    expected_return_date timestamp with time zone,
    pickup_window_start_time timestamp with time zone,
    pickup_window_end_time timestamp with time zone,
    customer_shipping_address dbms_cloud_oci_dts_shipping_address_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

bucket_name

(optional)

prefix

(optional) List of objects with names matching this prefix would be part of this export job.

range_start

(optional) Object names returned by a list query must be greater or equal to this parameter.

range_end

(optional) Object names returned by a list query must be strictly less than this parameter.

display_name

(optional)

lifecycle_state

(optional)

Allowed values are: 'CREATING', 'ACTIVE', 'INPROGRESS', 'SUCCEEDED', 'FAILED', 'CANCELLED', 'DELETED'

lifecycle_state_details

(optional) A property that can contain details on the lifecycle.

manifest_file

(optional) Manifest File associated with this export job.

manifest_md5

(optional) md5 digest of the manifest file.

number_of_objects

(optional) Total number of objects that are exported in this job.

total_size_in_bytes

(optional) Total size of objects in Bytes that are exported in this job.

first_object

(optional) First object in the list of objects that are exported in this job.

last_object

(optional) Last object in the list of objects that are exported in this job.

next_object

(optional) First object from which the next potential export job could start.

expected_return_date

(optional) Expected return date from customer for the device, time portion should be zero.

pickup_window_start_time

(optional) Start time for the window to pickup the device from customer.

pickup_window_end_time

(optional) End time for the window to pickup the device from customer.

customer_shipping_address

(optional)

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

DBMS_CLOUD_OCI_DTS_UPDATE_TRANSFER_APPLIANCE_DETAILS_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_update_transfer_appliance_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  lifecycle_state varchar2(32767),
  customer_shipping_address dbms_cloud_oci_dts_shipping_address_t,
  expected_return_date timestamp with time zone,
  pickup_window_start_time timestamp with time zone,
  pickup_window_end_time timestamp with time zone,
  minimum_storage_capacity_in_terabytes number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_update_transfer_appliance_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_update_transfer_appliance_details_t (
    lifecycle_state varchar2,
    customer_shipping_address dbms_cloud_oci_dts_shipping_address_t,
    expected_return_date timestamp with time zone,
    pickup_window_start_time timestamp with time zone,
    pickup_window_end_time timestamp with time zone,
    minimum_storage_capacity_in_terabytes number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

lifecycle_state

(optional)

Allowed values are: 'PREPARING', 'FINALIZED', 'RETURN_LABEL_REQUESTED', 'RETURN_LABEL_GENERATING', 'RETURN_LABEL_AVAILABLE', 'DELETED', 'CUSTOMER_NEVER_RECEIVED', 'CANCELLED'

customer_shipping_address

(optional)

expected_return_date

(optional) Expected return date from customer for the device, time portion should be zero.

pickup_window_start_time

(optional) Start time for the window to pickup the device from customer.

pickup_window_end_time

(optional) End time for the window to pickup the device from customer.

minimum_storage_capacity_in_terabytes

(optional) Minimum storage capacity of the device, in terabytes. Valid options are 50, 95 and 150.

DBMS_CLOUD_OCI_DTS_UPDATE_TRANSFER_DEVICE_DETAILS_T Type

Syntax

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

Fields

Field Description

lifecycle_state

(optional)

Allowed values are: 'PREPARING', 'READY', 'CANCELLED'

DBMS_CLOUD_OCI_DTS_UPDATE_TRANSFER_JOB_DETAILS_T Type

Syntax

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

Fields

Field Description

lifecycle_state

(optional)

Allowed values are: 'CLOSED'

display_name

(optional)

device_type

(optional)

Allowed values are: 'DISK', 'APPLIANCE'

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

DBMS_CLOUD_OCI_DTS_UPDATE_TRANSFER_PACKAGE_DETAILS_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dts_update_transfer_package_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  original_package_delivery_tracking_number varchar2(32767),
  return_package_delivery_tracking_number varchar2(32767),
  package_delivery_vendor varchar2(32767),
  lifecycle_state varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_update_transfer_package_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dts_update_transfer_package_details_t (
    original_package_delivery_tracking_number varchar2,
    return_package_delivery_tracking_number varchar2,
    package_delivery_vendor varchar2,
    lifecycle_state varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

original_package_delivery_tracking_number

(optional)

return_package_delivery_tracking_number

(optional)

package_delivery_vendor

(optional)

lifecycle_state

(optional)

Allowed values are: 'SHIPPING', 'CANCELLED'

Was this article helpful?