Click here to Skip to main content
15,891,704 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am trying to upload a sql script file with 502944 insert statements. The file size is 145MB.

I am getting this error.
Quote:
The script exceeds the maximum size allowed.


What I have tried:

Some of the solutions on google pointed out a way to change the size of SQL scripts, but I couldn't log in as a service manager.

This was the solution:
Quote:
Login as the Service Administrator (...pls/apex/apex_admin) and navigate to Home>Manage Service>Feature Configuration where you'll see a setting for "SQL Scripts Maximum Script Size in bytes".


[EDIT from CHill60 - I'm deleting my solution because it is not working for the OP. Here is a summary of the conversation we had via the comments on that solution]
It was suggested that I split the script into files that would fit, but by default the sql script size is 500000 Bytes which is 0.5 MB. This will hold approximately 1735 statements. If I was to split the script up it would mean I must split this to 290 such files!!

I am working alone and I have to do it alone only. I coudn't get the Manager service option in oracle 10g in admin account too. But I dont see this. Home>Manage Service>Feature Configuration
I only have these options:
1. https://postimg.org/image/ysolqfckv/
2. https://postimg.org/image/s3i2aer8v/
Posted
Updated 30-Oct-17 12:32pm
v3
Comments
kuharan 2-Apr-17 12:35pm    
Thanks for the improvement Sir.

1 solution

try to add commit; after every 100 inserts in your script.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900