Hi All
I have created following Table and faced an error
Create Table Reference(col1 varchar(20) , col2 integer ,col3 varchar(20) );
copy Reference from '/home/dbadmin/Reference.txt' delimiter '|';
Then I have faced the Following error
ERROR 2344: Cannot allocate sufficient memory for COPY statement (536870912 requested, 268435456 permitted)
HINT: This can happen if you have very wide rows, or if you have specified an incorrect record terminator. (Check your escaping -- for example, "' '" is not a tab; you must use "E' '".)
Note :My reference.txt file is 2gb large and it is delimited with '|'
Can anyone Help
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.