Operating System - HP-UX
1748151 Members
3813 Online
108758 Solutions
New Discussion юеВ

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 2
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