i using oracle db 12c enterprise edition.
i have set file directory flat file (.csv) saved on desktop. external table created , data being loaded directly external table set in oracle.
it appears data import .csv --> external table transparent process. how determine how long took load data in .csv flat file external table?
my .csv flat file has 150,000 records. badfile , logfile produced not provide specific time on how long took load files.
please help..
my goal determine if loading data via external table faster sql*ldr or data import utility in sql developer.
the data loaded external table every time query it. 1 option
select count(*) your_external_table and measuring amount of time requires. if intention load data external table same staging table you'd load sql*loader, measure time required insert.
