Databases
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