Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Max file size redirected standard in for Oracle sqlplus

SOLVED
Go to solution
Stephen Badgett
Regular Advisor

Max file size redirected standard in for Oracle sqlplus

What is the max size of the file trimspaceCUSTOMER.sql can be if used this way?

sqlplus "user/pw" < trimspaceCUSTOMER.sql
Not as is, is now
2 REPLIES
A. Clay Stephenson
Acclaimed Contributor
Solution

Re: Max file size redirected standard in for Oracle sqlplus

Since this is nothing more than a shell redirection of stdin, there really shouldn't be a maximum size although there might be a 2GB limit imposed by the application or filesystem. However, what could get you into trouble is the maximum length of a given line of input and that is application dependent.
If it ain't broke, I can fix that.
Stephen Badgett
Regular Advisor

Re: Max file size redirected standard in for Oracle sqlplus

thank you
Not as is, is now