[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 583
  • Last Modified:

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.

 
0
rupvis
Asked:
rupvis
  • 2
  • 2
2 Solutions
 
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now