Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Parse JSON clob data from Oracle 12c DB to Oracle 11g DB

User_YQZHDJan 22 2019 — edited Jan 23 2019

Hi,

I have a scenario where I need to move data from Oracle 12c database into Oracle 11g database.

The data in 12c DB is in JSON format. Each table has only one column with JSON document in it and has around 100 keys. Now I would like to parse the json document and move them into 11g DB where I think we need to have around 100 columns to capture the data. Also, I have to make sure insert, updates are handled accordingly and also the scenario where json document having different nested structures are captured correctly.

Let me know what options we have.

Thanks

Added on Jan 22 2019

#general-database-discussions

5 comments

579 views