Managing Tables and Indexes Using Console

Learn how to manage Oracle NoSQL Database Cloud Service tables and indexes from the Console.

This article has the following topics:

Viewing Table Details

Learn how to view Oracle NoSQL Database Cloud Service table details from the NoSQL console.

To view table details:

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. To view table details, do either of the following:
   • Click the table name, or
   • Click the action menu corresponding to the table name and select View Details.
   The Table Details page opens up.
3. From the Table Details page, you can view all table columns, indexes, rows, and metrics.
4. A column in the list (Child tables) shows how many child tables are owned by the specified table.
   
   
   Description of the illustration view-tbls-det.png
   
   
5. The list of child tables for a given parent table can be viewed by clicking the "Child tables" link under Resources on the parent table's details page.
   
   
   Description of the illustration view-chld-tbl.png
   
   

Viewing Table DDL

You can view the DDL statement used to create a table for the Table Details page.

To view table DDL:

1. In the Table Details page, click View Table DDL.
   The View Table DDL window displays the table DDL statement.
2. Now, you can select and copy the table DDL statement from the window. Click OK to close the window.

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. To view table details, do either of the following:
   • Click the table name, or
   • Click the action menu corresponding to the table name and select View Details.
   The Table Details page opens up.
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.
     
     
     Description of the illustration edittable_ttl.png
     
     
   • 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.
     
     
     Description of the illustration edittable_defaultttl.png
     
     
   • 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.
     
     
     Description of the illustration edit-childtbl.png
     
     

     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.
     
     
     Description of the illustration edittable_capacity.png
     
     
   • 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.
     
     
     Description of the illustration edittable_defaultttl.png
     
     

     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.
     
     
     Description of the illustration edit_res_capacity.png
     
     

     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.

Altering Tables

Learn how to alter Oracle NoSQL Database Cloud Service tables by adding in simple or advanced mode, or deleting columns using the NoSQL console.

The NoSQL console lets you alter the Oracle NoSQL Database Cloud Service tables in two modes:

1. Simple Input Mode: You can use this mode to alter the NoSQL Database Cloud Service table declaratively, that is, without writing a DDL statement.
2. Advanced DDL Input Mode: You can use this mode to alter the NoSQL Database Cloud Service table using a DDL statement.

Adding Table Columns: Simple Input Mode

Learn how to add table columns to an Oracle NoSQL Database Cloud Service table by using the Simple Input table column update mode.

To add table columns:

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. To view table details, do either of the following:
   • Click the table name, or
   • Click the action menu corresponding to the table name and select View Details.
   The Table Details page opens up.
3. In the Table Details page, select the Columns tab under Resources.
   You will see a list of all the columns added to the table.
4. Click Add Columns.
5. In the Add Columns window, select Simple Input for Table Column Update Mode.
6. In the Columns section, enter non-primary column details:
   
   
   Description of the illustration createtable_col.png
   
   
   • Column Name: Enter the column name. Ensure that you conform to column naming requirements described in Oracle NoSQL Database Cloud Service Limits.
   • Type: Select the data type for your column.
   • Precision:This is applicable for TIMESTAMP typed columns only. Timestamp values have precision in fractional seconds that range from 0 to 9. For example, a precision of 0 means that no fractional seconds are stored, 3 means that the timestamp stores milliseconds and 9 means a precision of nanoseconds. 0 is the minimum precision, and 9 is the maximum.
   • Size: This is applicable for BINARY typed columns only. Specify the size in bytes to make the binary a fixed binary.
   • Default Value: (optional) Supply a default value for the column.

     Note:

     Default values can not be specified for binary and JSON data type columns.
   • Value is Not Null: Click this option to specify that a column must always have a value.
   • + Another Column: Click this button to add more columns.
   • Click the delete icon to delete a column.
7. Click Add Columns.
   The new columns are added to the table.

To view help for the current page, click the help link at the top of the page.

Adding Table Columns: Advanced DDL Input Mode

Learn how to add table columns to an Oracle NoSQL Database Cloud Service table by using the Advanced DDL table column update mode.

To add table columns:

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. To view table details, do either of the following:
   • Click the table name, or
   • Click the action menu corresponding to the table name and select View Details.
   The Table Details page opens up.
3. In the Table Details page, select the Columns tab under Resources.
   You will see a list of all the columns added to the table.
4. Click Add Columns.
5. In the Add Columns window, select Advanced DDL Input for Table Column Update Mode.
6. Enter the update table DDL statement. For an example, See Alter Table in Developers Guide.
7. Click Add Columns.
   The new columns are added to the table.

Moving Tables

Learn how to move Oracle NoSQL Database Cloud Service table to a different compartment from the NoSQL console.

To move a table:

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. To view table details, do either of the following:
   • Click the table name, or
   • Click the action menu corresponding to the table name and select View Details.
   The Table Details page opens up.
3. In the Table Details page, click Move Table.
4. Alternatively, Click the action menu corresponding to the table name and select Move table.
5. In the Move Resource to a Different Compartment window, modify the following values for the table:
   • Choose New Compartment: Select the new compartment from the select list.
6. Click Move table.
7. (Optional) To dismiss the changes, click the Cancel link on the top right corner.

To view help for the current page, click the help link at the top of the page.

Note:

You cannot move a child table to another compartment. If the parent table is moved to a new compartment, all the descendant tables within the hierarchy will be automatically moved to the target compartment in a single operation.

Viewing Table Metrics

Learn how to view Oracle NoSQL Database Cloud Service table metrics from the NoSQL console.

To view table metrics:

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. To view table details, do either of the following:
   • Click the table name, or
   • Click the action menu corresponding to the table name and select View Details.
   The Table Details page opens up.
3. In the Table Details page, select the Metrics tab under Resources.
   Table metrics such as Read Units, Write Units, Storage GB, Read Throttle Count, Write Throttle Count, and Storage Throttle Count show up. You can filter the metrics by date, change interval, and statistic value.
4. For each of the metrics displayed on this page, you can perform the following actions:
   • View Query in Metrics Explorer: This page lets you write and edit queries in Monitoring Query Language (MQL), using metrics from either your application or an Oracle Cloud Infrastructure service. If you're not familiar with MQL, see Monitoring Query Language (MQL) Reference. To learn more about this page, see Metrics Explorer.
   • Copy Chart URL: Click this option to copy the default metrics chart URL for any future reference.
   • Copy Query (MQL): Click this option to copy the MQL query used to create the default metrics chart. If you're not familiar with MQL, see Monitoring Query Language (MQL) Reference.
   • Create an Alarm on this Query: Click this option to create alarms to monitor your cloud resources. To learn about alarms, see Managing Alarms.

Deleting Tables

Learn how to delete Oracle NoSQL Database Cloud Service tables from the NoSQL console.

To delete 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. To delete the table, do either of the following:
   • Click the table name. In the Table Details page, click the Delete button, or
   • Click the action menu corresponding to the table name you wish to delete and select Delete.
   • If a table has child tables, then the child table should be deleted first before deleting the parent table.
   The Delete Table confirmation dialog opens.
3. Click Delete.
   The table is deleted.

Deleting Indexes

Learn how to delete Oracle NoSQL Database Cloud Service indexes from the NoSQL console.

To delete indexes:

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. To view table details, do either of the following:
   • Click the table name, or
   • Click the action menu corresponding to the table name and select View Details.
   The Table Details page opens up.
3. In the Table Details page, select the Indexes tab under Resources.
   You will see a list of all the indexes added to the table.
4. Click the action menu corresponding to the index you wish to delete, and select Delete.
   The Delete Index confirmation dialog opens.
5. Click Delete.
   The index is deleted.