This content has been marked as final. Show 6 replies
These are not solutions, but techniques you can use to import files.
The logic to extract only new records has to be implemented by you yourself. E.g. you could store the last imported date in a table and skip all records before this date. Also, i would guess that this time-taking machine can be configured to write one file per day or something similar.
If this is csv-like file (not binary Excel file) then consider to create external table based on it. Then you'll be able to do whatever you want with data (consider to make such external table as a source and copy data to another table (using merge or whatever you want). Then you can mark already processed/displayed records on your new table or simply lists external table minus your table to see newly created records.
Hope this helps you .
Here you have link to the documentation:
Cause I don't know your file structure I can only prepare a generic example for you (see my comments for more details):
Hope this helps.
create table ext_table_csv ( --here you should define table columns e.g. /* EMPNO NUMBER(4), ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7,2), COMM NUMBER(7,2), DEPTNO NUMBER(2) */ ) organization external ( type oracle_loader default directory ext_dir -- ORACLE directory name access parameters ( records delimited by newline fields terminated by ';' -- depends on your delimiter missing field values are null -- optional clause ) location ('file.csv') -- file name ) reject limit unlimited; -- self explanatory