Hi,
got to load large files using external tables . is there any way we can right generic script to validate whether files exists in that location and load the files if exists and
also can we make this generic by taking the columns from user_columns if we pass the table name etc as a parameter to the procedure . did any one try this . please let me know.
will always truncate the external table and reload for every load no update mechanism