You can migrate data to the JSON type following these steps:
- (Optional) If converting from XML to JSON, the XML data must be stored in CLOB or VARCHAR columns.
- Verify that the intended JSON data is well-formed and conforms to the rules of JSON formatting.
- Create new versions of the tables using the JSON type for columns that will hold the JSON data.
-
Insert the JSON text (for example, the JSON constructor or string) into the JSON columns.
See also, Loading JSON Data Using Load Utilities.