external tables in oracle 9i
Posted on 2004-08-06
I want to test how can i read flat file by using external tables, I read some articles about this feature , but when i tried to test the tables, it's always give me an error " can not locate log file" , actually , I created flat file on my machnine and try to run the script from the server, I dont know if I should put the fiels on db server?
one more thing , is this external tables read only flat files , can I use them to read dbase files , excel sheet files ?????
and what is the best practice of using this feature?