Comments for External Tables : Querying Data From Flat Files in Oracle
Jabs said... 11/13/2006Good 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? ;-) Regards, Hoek |
Tim... said... Hi.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. :) Cheers Tim... |
Andrew said... 1st nit:>>CREATE OR REPLACE DIRECTORY ext_tab_data AS '/data'; ...followed by >>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" ...followed by >>PREPROCESSOR exec_dir:'my_inzip.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. :) Cheers Tim... |
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. |
Tim... said... Hi.Done that. :) Cheers Tim... |
DJ said... LOCATION ('Countries1.txt','Countries2.txt')On the line above, can the values come from a column of an existing table? Like ... LOCATION (Select col_country from tbl_country) |
Tim... said... Hi.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'); Cheers Tim... |
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.