How to Workaround the SQL Script Size Limitation in Database Schema Service: "The script exceeds the maximum size allowed"
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms