Promote to Autonomous Transaction Processing

You can promote an Oracle Autonomous JSON Database to an Oracle Autonomous Transaction Processing database at any time.

An Autonomous JSON Database is the same as an Autonomous Transaction Processing database, except that a JSON database is limited in these respects:

  • You can store only up to 20 GB of data other than JSON document collections.Foot 1

    (All Autonomous Databases, including Autonomous JSON Database, limit the storage of JSON data to 128 TB.)

  • Collections cannot be heterogeneous. That is, they can only contain JSON documents. For example, you cannot have a collection of image documents or a collection that contains both JSON documents and image documents.

These limitations are appropriate if your use is primarily development of applications that use JSON documents. If you have a greater need to use data other than JSON data then follow these steps to promote your JSON database to an Autonomous Transaction Processing database:

  1. Sign in to your Oracle Cloud Account at

  2. Open the Oracle Cloud Infrastructure Console by clicking the navigation icon next to Oracle Cloud.

  3. From the Oracle Cloud Infrastructure left navigation menu click Oracle Database, and then click Autonomous JSON Database.

  4. Choose your JSON database from those listed in the compartment, by clicking its name in column Display Name.

  5. Do one of the following:

    • From the More Actions drop-down list near the top of the console, select Change Workload Type.

    • In tab Autonomous Database Information, under heading General Information, item Workload Type, to the right of the current workload type (JSON Database), click Change Workload Type.

  6. Confirm that you want to convert this JSON database to Autonomous Transaction Processing, by clicking Change Workload Type to Transaction Processing.

  7. If you were using the refreshable clone feature with your Autonomous JSON Database then re-create the clone after promotion to Autonomous Transaction Processing. See Using Refreshable Clones with Autonomous Database in Using Oracle Autonomous Database on Shared Exadata Infrastructure.

Footnote Legend

Footnote 1: You can subscribe to information event AJDNonJsonStorageExceeded, to be informed when the 20 GB limit is exceeded. See About Information Events on Autonomous Database in Using Oracle Autonomous Database on Shared Exadata Infrastructure.