>Is there any parameter that we can use during create external table that can overwrite the file?
Harvinder
Once the table is dropped, couldn't you just delete the file using UTL_FILE.FREMOVE (http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_file.htm#sthref14163)?
So:
- drop table: execute immediate 'drop table '||v_table_name;
- remove file: UTL_FILE.FREMOVE(p_path, fname);
- create table: execute immediate v_sql2;
and remember, if there's no table, there might be no file - so you should handle that exception (whichever one it is - probably DELETE_FAILED, which covers a multitude of sins).
HTH
Regards Nigel
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 07 2006 - 12:29:47 CST
