I have one problem..and this is very urgent.
I have one DBF(not an Oracle Datafile) (can say Dbase file) file which is external from Oracle database and placed in some drive c:\files\emp.dbf and Dbase not in system
In my Oracle Database table called Emp which have same column as in emp.dbf file. some extra column also in Oracle table EMP.
I have to join this external physical file and Oracle table to retrive data.
i have to fetch two column from Dbf file and three column from oracle after joining. Empcode is same in both Oracle table and emp.dbf file
How can i join external dbf file to oracle table. we are not going to migrate dbf file into oracle file.