external table file missing scenario
692864Apr 22 2009 — edited Jun 16 2009hi what happens........
when we access the external table and the file is not present ... does it throw an error? it simply returns zero rows?
if I know that i will get 5 files a.txt , b.txt, c.txt, d.txt, e.txt then i can put them in the location
LOCATION ('a.txt','b.txt','c.txt','d.txt','e.txt') during the creation of External table
If for example b.txt and c.txt are not present during the access then will it throw an error or does it just show me the records of a, d and e?
regards
raj