When I compiled the table, I got the following error.
Quite hilarious... but what did I do wrong? The Oracle error message did not help me at all (and who could ever help?). I checked the directory. It was there and its name was typed correctly. File names were ok. So what was the issue?
It was as easy as removing the NOT NULL clause on the field specification.
Silly error, but it took me a while to find out what was wrong. Hope this helps.