rupvis
asked on
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
???
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?
???
ASKER
@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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.