Previous Next JavaScript must be enabled to correctly display this content

## New Features in Release 20.3

Universally Unique Identifier

Added SQL support for randomly generated UUIDs, including the random_uuid() function, the new "AS UUID" option for STRING data types, and the new "GENERATED BY DEFAULT" option for "STRING AS UUID" data types. These new facilities provide an easy way to create a field that contains a unique ID for each row. UUID fields can be used to create unique primary keys in multi-region tables, since multi-region tables do not support the IDENTITY fields that serve this purpose for local tables.

Deprecating Import/Export Utility

In the Oracle NoSQL Database 20.2 release, we released a new Data Migrator utility. We have moved the functionality of the import/export utility over to the data migrator. The Using Oracle NoSQL Data Migrator section in the Administrator's Guide contains details on using the data migrator as well as a comparison between the import/export utility and the data migrator. We are deprecating the import/export utility as of the 20.3 release and encourage customers to use the new data migrator utility.