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

An Autonomous JSON Database is the same as an Autonomous Transaction Processing database, except that an Autonomous 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 , 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 database to an Autonomous Transaction Processing database:

1. Open the Oracle Cloud Infrastructure Console by clicking the next to Oracle Cloud.

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

3. Choose your JSON Database from those listed in the compartment, by clicking its name in column Display name.

4. Do one of the following:

   • From the More actions drop-down list, select Change workload type.

   • In tab Autonomous Database information, under heading General information, item Workload type, click Edit.

5. Click Convert to confirm that you want to convert this database to Autonomous Transaction Processing.

6. 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.

See Autonomous Database Billing Summary for more information.