Skip to content

/AWS1/IF_ODB=>CREATEAUTONOMOUSDATABASE()

About CreateAutonomousDatabase

Creates a new Autonomous Database.

Method Signature

METHODS /AWS1/IF_ODB~CREATEAUTONOMOUSDATABASE
  IMPORTING
    !IV_ODBNETWORKID TYPE /AWS1/ODBRESOURCEIDORARN OPTIONAL
    !IV_DISPLAYNAME TYPE /AWS1/ODBRESOURCEDISPLAYNAME OPTIONAL
    !IV_DBNAME TYPE /AWS1/ODBSTRING OPTIONAL
    !IV_ADMINPASSWORD TYPE /AWS1/ODBSENSITIVESTRING OPTIONAL
    !IV_COMPUTECOUNT TYPE /AWS1/RT_DOUBLE_AS_STRING OPTIONAL
    !IV_DATASTORAGESIZEINTBS TYPE /AWS1/ODBINTEGER OPTIONAL
    !IV_DATASTORAGESIZEINGBS TYPE /AWS1/ODBINTEGER OPTIONAL
    !IV_DBWORKLOAD TYPE /AWS1/ODBDBWORKLOAD OPTIONAL
    !IV_ISAUTOSCALINGENABLED TYPE /AWS1/ODBBOOLEAN OPTIONAL
    !IV_ISAUTOSCFORSTORAGEENABLED TYPE /AWS1/ODBBOOLEAN OPTIONAL
    !IV_LICENSEMODEL TYPE /AWS1/ODBLICENSEMODEL OPTIONAL
    !IV_CHARACTERSET TYPE /AWS1/ODBSTRING OPTIONAL
    !IV_NCHARACTERSET TYPE /AWS1/ODBSTRING OPTIONAL
    !IV_DBVERSION TYPE /AWS1/ODBSTRING OPTIONAL
    !IV_DATABASEEDITION TYPE /AWS1/ODBDATABASEEDITION OPTIONAL
    !IV_STANDBYALWLSTIPSSOURCE TYPE /AWS1/ODBSTANDBYALWLSTIPSSRC OPTIONAL
    !IV_ATNMSMAINTSCHEDULETYPE TYPE /AWS1/ODBATNMSMAINTSCHDTYPE OPTIONAL
    !IV_BACKUPRETPERIODINDAYS TYPE /AWS1/ODBINTEGER OPTIONAL
    !IV_BYOLCOMPUTECOUNTLIMIT TYPE /AWS1/RT_DOUBLE_AS_STRING OPTIONAL
    !IV_CPUCORECOUNT TYPE /AWS1/ODBINTEGER OPTIONAL
    !IT_CUSCONTACTSTOSENDTOOCI TYPE /AWS1/CL_ODBCUSTOMERCONTACT=>TT_CUSTOMERCONTACTS OPTIONAL
    !IV_PRIVATEENDPOINTIP TYPE /AWS1/ODBSTRING OPTIONAL
    !IV_PRIVATEENDPOINTLABEL TYPE /AWS1/ODBSTRING OPTIONAL
    !IV_RESOURCEPOOLLEADERID TYPE /AWS1/ODBRESOURCEIDORARN OPTIONAL
    !IO_RESOURCEPOOLSUMMARY TYPE REF TO /AWS1/CL_ODBRESPOOLSUMMARY OPTIONAL
    !IT_SCHEDULEDOPERATIONS TYPE /AWS1/CL_ODBSCHEDULEDOPDETAILS=>TT_SCHEDULEDOPDETAILSLIST OPTIONAL
    !IT_STANDBYALLOWLISTEDIPS TYPE /AWS1/CL_ODBSTRINGLIST_W=>TT_STRINGLIST OPTIONAL
    !IT_ALLOWLISTEDIPS TYPE /AWS1/CL_ODBSTRINGLIST_W=>TT_STRINGLIST OPTIONAL
    !IO_TRANSPORTABLETABLESPACE TYPE REF TO /AWS1/CL_ODBTRANSPORTBLTBLPACE OPTIONAL
    !IV_ISBACKUPRETENTIONLOCKED TYPE /AWS1/ODBBOOLEAN OPTIONAL
    !IV_ISLOCALDATAGUARDENABLED TYPE /AWS1/ODBBOOLEAN OPTIONAL
    !IV_ISMTLSCONNECTIONREQUIRED TYPE /AWS1/ODBBOOLEAN OPTIONAL
    !IT_DBTOOLSDETAILS TYPE /AWS1/CL_ODBDATABASETOOL=>TT_DATABASETOOLLIST OPTIONAL
    !IV_SOURCE TYPE /AWS1/ODBSOURCETYPE OPTIONAL
    !IO_SOURCECONFIGURATION TYPE REF TO /AWS1/CL_ODBSOURCECONF OPTIONAL
    !IV_ENCRYPTIONKEYPROVIDER TYPE /AWS1/ODBENCKEYPROVIDERINPUT OPTIONAL
    !IO_ENCRYPTIONKEYCONF TYPE REF TO /AWS1/CL_ODBENCKEYCONFINPUT OPTIONAL
    !IV_CLIENTTOKEN TYPE /AWS1/ODBGENERALINPUTSTRING OPTIONAL
    !IT_TAGS TYPE /AWS1/CL_ODBREQUESTTAGMAP_W=>TT_REQUESTTAGMAP OPTIONAL
  RETURNING
    VALUE(OO_OUTPUT) TYPE REF TO /aws1/cl_odbcreatnmsdbaseout
  RAISING
    /AWS1/CX_ODBACCESSDENIEDEX
    /AWS1/CX_ODBCONFLICTEXCEPTION
    /AWS1/CX_ODBINTERNALSERVEREX
    /AWS1/CX_ODBRESOURCENOTFOUNDEX
    /AWS1/CX_ODBSERVICEQUOTAEXCDEX
    /AWS1/CX_ODBTHROTTLINGEX
    /AWS1/CX_ODBVALIDATIONEX
    /AWS1/CX_ODBCLIENTEXC
    /AWS1/CX_ODBSERVEREXC
    /AWS1/CX_RT_TECHNICAL_GENERIC
    /AWS1/CX_RT_SERVICE_GENERIC.

IMPORTING

Optional arguments:

iv_odbnetworkid TYPE /AWS1/ODBRESOURCEIDORARN /AWS1/ODBRESOURCEIDORARN

The unique identifier of the ODB network to be used for the Autonomous Database.

iv_displayname TYPE /AWS1/ODBRESOURCEDISPLAYNAME /AWS1/ODBRESOURCEDISPLAYNAME

The user-friendly name for the Autonomous Database. The name does not have to be unique.

iv_dbname TYPE /AWS1/ODBSTRING /AWS1/ODBSTRING

The name of the Autonomous Database. The name must begin with an alphabetic character and can contain a maximum of 30 alphanumeric characters. Special characters are not permitted. The name must be unique in the Amazon Web Services account.

iv_adminpassword TYPE /AWS1/ODBSENSITIVESTRING /AWS1/ODBSENSITIVESTRING

The password for the ADMIN user of the Autonomous Database.

iv_computecount TYPE /AWS1/RT_DOUBLE_AS_STRING /AWS1/RT_DOUBLE_AS_STRING

The compute capacity, in number of Elastic CPUs (ECPUs) or Oracle CPUs (OCPUs), to assign to the Autonomous Database.

iv_datastoragesizeintbs TYPE /AWS1/ODBINTEGER /AWS1/ODBINTEGER

The size, in terabytes (TB), of the data volume to allocate for the Autonomous Database.

iv_datastoragesizeingbs TYPE /AWS1/ODBINTEGER /AWS1/ODBINTEGER

The size, in gigabytes (GB), of the data volume to allocate for the Autonomous Database.

iv_dbworkload TYPE /AWS1/ODBDBWORKLOAD /AWS1/ODBDBWORKLOAD

The intended use of the Autonomous Database, such as transaction processing, data warehouse, JSON database, or APEX.

iv_isautoscalingenabled TYPE /AWS1/ODBBOOLEAN /AWS1/ODBBOOLEAN

Specifies whether to enable automatic scaling of the compute resources for the Autonomous Database.

iv_isautoscforstorageenabled TYPE /AWS1/ODBBOOLEAN /AWS1/ODBBOOLEAN

Specifies whether to enable automatic scaling of the storage for the Autonomous Database.

iv_licensemodel TYPE /AWS1/ODBLICENSEMODEL /AWS1/ODBLICENSEMODEL

The Oracle license model to apply to the Autonomous Database.

iv_characterset TYPE /AWS1/ODBSTRING /AWS1/ODBSTRING

The character set to use for the Autonomous Database.

iv_ncharacterset TYPE /AWS1/ODBSTRING /AWS1/ODBSTRING

The national character set to use for the Autonomous Database.

iv_dbversion TYPE /AWS1/ODBSTRING /AWS1/ODBSTRING

The Oracle Database software version to use for the Autonomous Database.

iv_databaseedition TYPE /AWS1/ODBDATABASEEDITION /AWS1/ODBDATABASEEDITION

The Oracle Database edition to apply to the Autonomous Database.

iv_standbyalwlstipssource TYPE /AWS1/ODBSTANDBYALWLSTIPSSRC /AWS1/ODBSTANDBYALWLSTIPSSRC

The source of the allowlisted IP addresses for the standby Autonomous Database.

iv_atnmsmaintscheduletype TYPE /AWS1/ODBATNMSMAINTSCHDTYPE /AWS1/ODBATNMSMAINTSCHDTYPE

The maintenance schedule type for the Autonomous Database.

iv_backupretperiodindays TYPE /AWS1/ODBINTEGER /AWS1/ODBINTEGER

The retention period, in days, for automatic backups of the Autonomous Database.

iv_byolcomputecountlimit TYPE /AWS1/RT_DOUBLE_AS_STRING /AWS1/RT_DOUBLE_AS_STRING

The maximum number of compute resources that you can allocate to the Autonomous Database under the bring-your-own-license (BYOL) model.

iv_cpucorecount TYPE /AWS1/ODBINTEGER /AWS1/ODBINTEGER

The number of CPU cores to allocate to the Autonomous Database.

it_cuscontactstosendtooci TYPE /AWS1/CL_ODBCUSTOMERCONTACT=>TT_CUSTOMERCONTACTS TT_CUSTOMERCONTACTS

The list of customer contacts to receive operational notifications from Oracle Cloud Infrastructure (OCI) for the Autonomous Database.

iv_privateendpointip TYPE /AWS1/ODBSTRING /AWS1/ODBSTRING

The private endpoint IP address for the Autonomous Database.

iv_privateendpointlabel TYPE /AWS1/ODBSTRING /AWS1/ODBSTRING

The private endpoint label for the Autonomous Database.

iv_resourcepoolleaderid TYPE /AWS1/ODBRESOURCEIDORARN /AWS1/ODBRESOURCEIDORARN

The unique identifier of the resource pool leader Autonomous Database.

io_resourcepoolsummary TYPE REF TO /AWS1/CL_ODBRESPOOLSUMMARY /AWS1/CL_ODBRESPOOLSUMMARY

The configuration of the resource pool for the Autonomous Database.

it_scheduledoperations TYPE /AWS1/CL_ODBSCHEDULEDOPDETAILS=>TT_SCHEDULEDOPDETAILSLIST TT_SCHEDULEDOPDETAILSLIST

The list of scheduled start and stop times for the Autonomous Database.

it_standbyallowlistedips TYPE /AWS1/CL_ODBSTRINGLIST_W=>TT_STRINGLIST TT_STRINGLIST

The list of IP addresses that are allowed to access the standby Autonomous Database.

it_allowlistedips TYPE /AWS1/CL_ODBSTRINGLIST_W=>TT_STRINGLIST TT_STRINGLIST

The list of IP addresses that are allowed to access the Autonomous Database.

io_transportabletablespace TYPE REF TO /AWS1/CL_ODBTRANSPORTBLTBLPACE /AWS1/CL_ODBTRANSPORTBLTBLPACE

The transportable tablespace configuration to use when creating the Autonomous Database.

iv_isbackupretentionlocked TYPE /AWS1/ODBBOOLEAN /AWS1/ODBBOOLEAN

Specifies whether to lock the backup retention period of the Autonomous Database to prevent it from being shortened.

iv_islocaldataguardenabled TYPE /AWS1/ODBBOOLEAN /AWS1/ODBBOOLEAN

Specifies whether to enable local Oracle Data Guard for the Autonomous Database.

iv_ismtlsconnectionrequired TYPE /AWS1/ODBBOOLEAN /AWS1/ODBBOOLEAN

Specifies whether mutual TLS (mTLS) authentication is required to connect to the Autonomous Database.

it_dbtoolsdetails TYPE /AWS1/CL_ODBDATABASETOOL=>TT_DATABASETOOLLIST TT_DATABASETOOLLIST

The list of database management tools to enable for the Autonomous Database.

iv_source TYPE /AWS1/ODBSOURCETYPE /AWS1/ODBSOURCETYPE

The source from which to create the Autonomous Database, such as a clone, backup, or cross-Region copy.

io_sourceconfiguration TYPE REF TO /AWS1/CL_ODBSOURCECONF /AWS1/CL_ODBSOURCECONF

The configuration details for the source used to create the Autonomous Database.

iv_encryptionkeyprovider TYPE /AWS1/ODBENCKEYPROVIDERINPUT /AWS1/ODBENCKEYPROVIDERINPUT

The provider of the encryption key to use for the Autonomous Database.

io_encryptionkeyconf TYPE REF TO /AWS1/CL_ODBENCKEYCONFINPUT /AWS1/CL_ODBENCKEYCONFINPUT

The configuration of the encryption key to use for the Autonomous Database.

iv_clienttoken TYPE /AWS1/ODBGENERALINPUTSTRING /AWS1/ODBGENERALINPUTSTRING

A client-provided token to ensure the idempotency of the request.

it_tags TYPE /AWS1/CL_ODBREQUESTTAGMAP_W=>TT_REQUESTTAGMAP TT_REQUESTTAGMAP

The list of resource tags to apply to the Autonomous Database. Each tag is a key-value pair with no predefined name, type, or namespace.

RETURNING

oo_output TYPE REF TO /aws1/cl_odbcreatnmsdbaseout /AWS1/CL_ODBCREATNMSDBASEOUT

Examples

Syntax Example

This is an example of the syntax for calling the method. It includes every possible argument and initializes every possible value. The data provided is not necessarily semantically accurate (for example the value "string" may be provided for something that is intended to be an instance ID, or in some cases two arguments may be mutually exclusive). The syntax shows the ABAP syntax for creating the various data structures.

DATA(lo_result) = lo_client->createautonomousdatabase(
  io_encryptionkeyconf = new /aws1/cl_odbenckeyconfinput(
    io_awsencryptionkey = new /aws1/cl_odbawsenckeyconfinput(
      iv_externalidtype = |string|
      iv_iamrolearn = |string|
      iv_kmskeyid = |string|
    )
  )
  io_resourcepoolsummary = new /aws1/cl_odbrespoolsummary(
    iv_availablecomputecapacity = 123
    iv_availstoragecapacityintbs = '0.1'
    iv_isdisabled = ABAP_TRUE
    iv_poolsize = 123
    iv_poolstoragesizeintbs = 123
    iv_totalcomputecapacity = 123
  )
  io_sourceconfiguration = new /aws1/cl_odbsourceconf(
    io_clonetorefreshable = new /aws1/cl_odbclonetorefableconf(
      iv_autorefreshfreqinseconds = 123
      iv_autorefrpointlaginseconds = 123
      iv_clonetype = |string|
      iv_openmode = |string|
      iv_refreshablemode = |string|
      iv_sourceatnmsdatabaseid = |string|
      iv_timeofautorefreshstart = '20150101000000.0000000'
    )
    io_crossregiondataguard = new /aws1/cl_odbcrossrgndatguard00( |string| )
    io_crossregiondisastrrec = new /aws1/cl_odbcrossrgndrrecconf(
      iv_isrplteautomaticbackups = ABAP_TRUE
      iv_remotedisastrrecoverytype = |string|
      iv_sourceatnmsdatabasearn = |string|
    )
    io_databaseclone = new /aws1/cl_odbdatabasecloneconf(
      iv_clonetype = |string|
      iv_sourceatnmsdatabaseid = |string|
    )
    io_pointintimerestore = new /aws1/cl_odbptintimerestconf(
      it_clonetablespacelist = VALUE /aws1/cl_odbintegerlist_w=>tt_integerlist(
        ( new /aws1/cl_odbintegerlist_w( 123 ) )
      )
      iv_clonetype = |string|
      iv_sourceatnmsdatabaseid = |string|
      iv_timestamp = '20150101000000.0000000'
      iv_uselatestavailbackuptsmp = ABAP_TRUE
    )
    io_restorefrombackup = new /aws1/cl_odbrestfrombackupconf(
      it_clonetablespacelist = VALUE /aws1/cl_odbintegerlist_w=>tt_integerlist(
        ( new /aws1/cl_odbintegerlist_w( 123 ) )
      )
      iv_atnmsdatabasebackupid = |string|
      iv_clonetype = |string|
    )
  )
  io_transportabletablespace = new /aws1/cl_odbtransportbltblpace( |string| )
  it_allowlistedips = VALUE /aws1/cl_odbstringlist_w=>tt_stringlist(
    ( new /aws1/cl_odbstringlist_w( |string| ) )
  )
  it_cuscontactstosendtooci = VALUE /aws1/cl_odbcustomercontact=>tt_customercontacts(
    ( new /aws1/cl_odbcustomercontact( |string| ) )
  )
  it_dbtoolsdetails = VALUE /aws1/cl_odbdatabasetool=>tt_databasetoollist(
    (
      new /aws1/cl_odbdatabasetool(
        iv_computecount = '0.1'
        iv_isenabled = ABAP_TRUE
        iv_maxidletimeinminutes = 123
        iv_name = |string|
      )
    )
  )
  it_scheduledoperations = VALUE /aws1/cl_odbscheduledopdetails=>tt_scheduledopdetailslist(
    (
      new /aws1/cl_odbscheduledopdetails(
        io_dayofweek = new /aws1/cl_odbdayofweek( |string| )
        iv_scheduledstarttime = |string|
        iv_scheduledstoptime = |string|
      )
    )
  )
  it_standbyallowlistedips = VALUE /aws1/cl_odbstringlist_w=>tt_stringlist(
    ( new /aws1/cl_odbstringlist_w( |string| ) )
  )
  it_tags = VALUE /aws1/cl_odbrequesttagmap_w=>tt_requesttagmap(
    (
      VALUE /aws1/cl_odbrequesttagmap_w=>ts_requesttagmap_maprow(
        key = |string|
        value = new /aws1/cl_odbrequesttagmap_w( |string| )
      )
    )
  )
  iv_adminpassword = |string|
  iv_atnmsmaintscheduletype = |string|
  iv_backupretperiodindays = 123
  iv_byolcomputecountlimit = |0.1|
  iv_characterset = |string|
  iv_clienttoken = |string|
  iv_computecount = |0.1|
  iv_cpucorecount = 123
  iv_databaseedition = |string|
  iv_datastoragesizeingbs = 123
  iv_datastoragesizeintbs = 123
  iv_dbname = |string|
  iv_dbversion = |string|
  iv_dbworkload = |string|
  iv_displayname = |string|
  iv_encryptionkeyprovider = |string|
  iv_isautoscalingenabled = ABAP_TRUE
  iv_isautoscforstorageenabled = ABAP_TRUE
  iv_isbackupretentionlocked = ABAP_TRUE
  iv_islocaldataguardenabled = ABAP_TRUE
  iv_ismtlsconnectionrequired = ABAP_TRUE
  iv_licensemodel = |string|
  iv_ncharacterset = |string|
  iv_odbnetworkid = |string|
  iv_privateendpointip = |string|
  iv_privateendpointlabel = |string|
  iv_resourcepoolleaderid = |string|
  iv_source = |string|
  iv_standbyalwlstipssource = |string|
).

This is an example of reading all possible response values

lo_result = lo_result.
IF lo_result IS NOT INITIAL.
  lv_string = lo_result->get_autonomousdatabaseid( ).
  lv_string = lo_result->get_displayname( ).
  lv_autonomousdatabaseresou = lo_result->get_status( ).
  lv_string = lo_result->get_statusreason( ).
ENDIF.