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.

Goal

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?
 

Solution

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