Increase quota of a sql script

The default script size in oracle 10g express is about 500kb. I need to find a way to get this increased to about 20 mb. Any help will be greatly appreciated.

 
LVL 2
rupvisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rupvisAuthor Commented:
@Abaraj

The link tells you how to import/export scripts but my problem is the script i need to import is 20mb in size and oracle can import a file that is max 500kb in size. My question is if there is a way to increase the size of the file that can be imported.
0
slightwv (䄆 Netminder) Commented:
Can you explain a little more about what you are trying to do?

Do you have a 20M file full of SQL commands like: insert into... that you need to process?
A 20M file you need to load into something like a CLOB column?
???
0
rupvisAuthor Commented:
@slightwv

Yes you are right .. I have a 20mb file with a lot of inserts into the database. The problem however is oracle cannot load the file as it is capped at 500kb.

0
slightwv (䄆 Netminder) Commented:
I just read the link Abaraj posted.  Are you trying to import it through the GUI?

Try from a SQL*Plus prompt.

SQL>  conn username/password
SQL> @mylargescriptfile.sql
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.