Oracle Cloud Infrastructure Documentation

Editing Tables

You can update reserved capacity (if the table is not an Always Free NoSQL table) and Time to Live (TTL) values for your Oracle NoSQL Database Cloud Service tables from the NoSQL console.

To edit tables:
  1. Access the NoSQL console from the Infrastructure Console. See Accessing the Service from the Infrastructure Console .
  2. The NoSQL console lists all the tables in the tenancy.
  3. The value of Time to Live (TTL) can be updated.
    • To update the value of Time to Live (TTL), click the Edit link next to the Time to live (Days) field.
    • You can also update the value of Time to Live (TTL) by clicking the action menu corresponding to the table name you wish to change and select Edit default time to live.
    • If the table is a child table, only the Time to live (TTL) value can be updated. To update the value of Time to Live (TTL), click the Edit link next to the Time to live (Days) field.
      Note

      You cannot edit the reserved capacity of a child table directly. Only the corresponding values of the parent table can be edited.
    • Table Time to Live (Days): (optional) Specify the default expiration time for the rows in the table. After this time, the rows expire automatically, and are no longer available. The default value is zero, indicating no expiration time.
      Note

      Updating Table Time to Live (TTL) will not change the TTL value of any existing data in the table. The new TTL value will only apply to those rows that are added to the table after this value is modified and to the rows for which no overriding row-specific value has been supplied.
  4. If your table is not an Always Free NoSQL table, then the reserved capacity and the usage model can be modified.
    • Under More Actions, click Edit reserved capacity.
    • You can also update the Reserved Capacity by clicking the action menu corresponding to the table name you wish to change and select Edit reserved capacity.

      Modify the following values for the table:

    • Read Capacity (ReadUnits): Enter the number of read units. See Estimating Capacity to learn about read units.
    • Write Capacity (WriteUnits): Enter the number of write units. See Estimating Capacity to learn about write units.
    • Disk Storage (GB): Specify the disk space in gigabytes (GB) to be used by the table. See Estimating Capacity to learn about storage capacity.

      You can also modify the Capacity mode from Provisioned Capacity to on Demand Capacity or vice-versa. If you provision units greater than what the on Demand capacity can offer, and then If you switch from Provisioned capacity to On Demand capacity, the capacity of the table will be reduced. You should take into consideration the reduction in the capacity due to the switch in this scenario.

  5. (Optional) To dismiss the changes, click Cancel.
To view help for the current page, click the help link at the top of the page.
If the table that is edited is a Global Active table:
  • Change in storage capacity or the value of table TTL have global scope (change in one regional table replica is automatically propagated to all regional table replicas).
  • Change in read units, write units or change in capacity mode from On-Demand to provisioned or vice-versa have a local scope (change only in the regional table replica where it is initiated).