How to create a file more than 2GB

UNIX for Advanced & Expert Users
1

Hi,
I am executing a SQL query and the output is more than 2GB. Hence the process is failing. How can I have a file created more than 2GB ?

Thanks,
Risshanth

2

You have to have large files enabled. What OS and DB are you using?