When i tried running Zip<-sqldf("select a.*,b.s_lv from Zip a inner join lin b on a.S=B.S") Error: cannot allocate vector of size 15.6 Mb and with following warning Warning messages: 1: In as.list.data.frame(X) : Reached total allocation of 1024Mb: see help(memory.size) 2: In as.list.data.frame(X) : Reached total allocation of 1024Mb: see help(memory.size) 3: In sqliteFetch(rs, n = -1, ...) : Reached total allocation of 1024Mb: see help(memory.size) 4: In sqliteFetch(rs, n = -1, ...) : Reached total allocation of 1024Mb: see help(memory.size) 5: In sqliteFetch(rs, n = -1, ...) : Reached total allocation of 1024Mb: see help(memory.size) 6: In sqliteFetch(rs, n = -1, ...) : Reached total allocation of 1024Mb: see help(memory.size) 7: In sqliteFetch(rs, n = -1, ...) : Reached total allocation of 1024Mb: see help(memory.size) 8: In sqliteFetch(rs, n = -1, ...) : Reached total allocation of 1024Mb: see help(memory.size) 9: In sqliteFetch(rs, n = -1, ...) : Reached total allocation of 1024Mb: see help(memory.size) 10: In sqliteFetch(rs, n = -1, ...) : Reached total allocation of 1024Mb: see help(memory.size) 11: In sqliteFetch(rs, n = -1, ...) : Reached total allocation of 1024Mb: see help(memory.size) 12: In sqliteFetch(rs, n = -1, ...) : Reached total allocation of 1024Mb: see help(memory.size)> memory.size()[1] 966.67 If i'm right the memory size shows 1Gb but it was not able to allocate 15mb.Help me to resolve this -- View this message in context: http://www.nabble.com/Vector-Allocation--problem-tp25853258p25853258.html Sent from the R help mailing list archive at Nabble.com.