DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to join Oracle table to dbf file (dbase file)

  1. #1
    Join Date
    Aug 2001
    Posts
    56
    Hello
    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.

    Pls send me the solution as soon as possible.
    Anuj
    India

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi anuj.

    It really depends on the format of the file. One method I've used against CSVs is the DIY$View approach. See:

    http://www.oracle.com/oramag/webcolu...y_dynamic.html

    If you do not know the internal format the only thing I can suggest is to use ODBC as a gateway to this data.

    Good luck.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  3. #3
    Join Date
    Aug 2001
    Posts
    56
    Hi Tim
    I know the format of DBF file and i can open it in MS excel and can see the attribute.
    Anuj
    India

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width