How to Workaround the SQL Script Size Limitation in Database Schema Service: "The script exceeds the maximum size allowed"
(Doc ID 2220142.1)
Last updated on JANUARY 04, 2017
Applies to:Oracle Application Express (formerly HTML DB) - Version 4.2 and later
Oracle Database Cloud Service - S5 - Version N/A and later
Oracle Database Cloud Service - S20 - Version N/A and later
Oracle Database Cloud Service - S50 - Version N/A and later
Oracle SQL Developer - Version 4.0 and later
Information in this document applies to any platform.
There is a size limitation that impacts scripts in an APEX installation. When a script hits that limit, the following message is presented:
"The script exceeds the maximum size allowed"
What is the script size limit for the Schema Service? Is there a workaround for large scripts?
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
|Use SQL Developer|
|Modify the Script|
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|