This content has been marked as final. Show 3 replies
I think it is possible. You can try general syntax:
ALTER TABLE [schema.]external_table_name location (new_directory_name:'new_filename.csv');
I have not tried though. Let me know if it was successfull.
P.S Link for syntax: http://www.ss64.com/ora/table_a_external.html
It is possible and I was looking at doing the same thing, as I need to load multiple files with different file names using an external table. At first it seemed like a good idea, but I came across this lengthy, but interesting and informative discussion on the ask tom forums, where they advised against it.
Have a look, but depending on the situation and the application in which you are using the alter command to change the external table to accommodate different files it might end up creating complications.
Thanks it works :
stmnt:= 'alter table '||ext_table_name||' location('||ff_module||':'||''''||filename||'.csv'||''')' ;
execute immediate stmnt;