I need toh load data from flat files in to oracle tables. I am using external tables (one external table/flatfile and merging them with the actual tables in my database. I need to write code which will create a table that contains data like,
name of the table
what flat file was used to perform the load
start time of load
end time of load
# of rows loaded
Could you please help me out with any ideas?
I need to load on a daily basis and this table is to verify that all the tables have been loaded successfully without any errors.
thank you very much