Good Article. Helped to start with external Tables.
Jyoti said...Nice Explanation
robindulal2004@yahoo said...not bad at all
Khan said...Nice explanation for the beginners
Anandh said...Yeah good explantion,better to be berifed for beginners
Jignesh said...Excellent work for beginners...keet it up.
Anil Kumar said...Excellent article. Given example is very clear and understanding...
Thanks for sharing.
Hoek said...Hi Tim,
I've been 'spamming' many great articles from your great site like h*ll on OTN, and just now I noticed:
CREATE OR REPLACE DIRECTORY EXT_TABLES AS 'C:temp';
I hope I'm not too late ;-), and I don't want to be a nit-picker but shouldn't that be:
CREATE OR REPLACE DIRECTORY EXT_TABLES AS 'C:\temp';
if your example is based on windoze? ;-)
Thanks for the heads-up. I had a problem with my CMS a while ago where it started to remove "\" characters. I fixed the CMS, but I guess some of the damage still remains.
I've corrected the article. Thanks very much and I don't think you're a nit-picker. :)
Andrew said...1st nit:
>>CREATE OR REPLACE DIRECTORY ext_tab_data AS '/data';
>>DEFAULT DIRECTORY ext_tables
The "DEFAULT DIRECTORY" should reference "ext_tab_data" or vice-versa. This is done later on the page as well.
Andrew said...2nd Nit:
>>assuming we had an executable file in the executable directory called "my_unzip.sh"
The "PREPROCESSOR" should reference "my_unzip.sh" instead of "my_inzip.sh" as per the above comment.
Tim... said...Hi Andrew.
Thanks for pointing out the typo and dodgy copy/paste. Those are corrected now. :)
jared said...it may be prudent to run dos2unix on the Countries.txt files... I just spent a half hour figuring out why my where clause wasn't working.
Done that. :)
DJ said...LOCATION ('Countries1.txt','Countries2.txt')
On the line above, can the values come from a column of an existing table?
LOCATION (Select col_country from tbl_country)
No, but you can use query to build a string with an ALTER TABLE command in it, that will give you the correct values before you run it.
ALTER TABLE admin_ext_employees LOCATION ('empxt3.txt', 'empxt4.txt');
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!
If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.