Cannot Extract File Larger Than 2.5 MB Via DBMS_CLOUD.EXPORT_DATA
(Doc ID 3014849.1)
Last updated on APRIL 04, 2024
Applies to:
Oracle Retail Data Storage Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
On MFCS:
Problem Description:
Cannot extract file larger than 2.5 MB via DBMS_CLOUD.EXPORT_DATA when all data is in one cell. Data is formatted as json and stored in CLOB data type before extraction.
Steps to Reproduce:
1. Set json data > 2.5MB to extract in a CLOB data type.
2. Use DBMS_CLOUD.EXPORT_DATA.
3. Only 2.5MB is extracted. Data is incomplete and malformed.
Expected Result
The extracted file is complete and formatted correctly.
Actual Result
Only 2.5MB is extracted. Data is incomplete and malformed.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |