This is a reactive mode versus proactive mode issue.
As you easily found, 4 GB files are unwieldy and already beyond the reach of some UNIX commands and system utilities. Considering a 40GB file will compound your difficulties in that area. You would be exercising professional level behavior to recommend file segmentation where possible to 1GB or less, of larger files and databases if humanly possible.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.