No, is not an Oracle database file (.DBF). Probably it's from some external program. /Dragan -Original Message- From: omrisela via oracle-db-l mailto:[email protected] Sent: Monday, June 21, 2004 11:56 AM To: Dragan Kociski Subject: oracle-db-l RE: load DBase file (.dbf) into Oracle database # Back to Basics: Constraints (1) # Read Paper: # View Group Archive: Is it a.DBF file from another Oracle DB or is it from an external program?
SQL Server integration Service (SSIS) can be used to import data from heterogeneous data sources ranging from SQL Server, Oracle to CSV, XML files.
Hi, I have the files as they are (dbf files) and I'm not able to make export of the data again. /Dragan -Original Message- From: omrisela via oracle-db-l mailto:[email protected] Sent: Monday, June 21, 2004 2:26 PM To: Dragan Kociski Subject: oracle-db-l RE: load DBase file (.dbf) into Oracle database # PeopleSoft Papers Raise Microsoft Fears # Read News: # View Group Archive: Use the external program to export the data in the DBF file to a flat (.txt) file, create the desired tables, and use sqlldr to load the data in the DB. There is a utility that can read the.dbf header and determine the schema.
I used it about 7-8 years ago in my foxpro days, but can't remember what it was called or where it came from. Using such a utility, you could recreate your DB, load the data and dump it in another format, or use ODBC to transfer your data. 'Dragan Kociski via oracle-db-l' 10:05 AM Please respond to oracle-db-l To: JHAYS.
Cc: Subject: oracle-db-l RE: load DBase file (.dbf) into Oracle database # delete duplicate record from table # View Code: # View Group Archive: Hi, I have the files as they are (dbf files) and I'm not able to make export of the data again. /Dragan -Original Message- From: omrisela via oracle-db-l mailto:[email protected] Sent: Monday, June 21, 2004 2:26 PM To: Dragan Kociski Subject: oracle-db-l RE: load DBase file (.dbf) into Oracle database # PeopleSoft Papers Raise Microsoft Fears # Read News: # View Group Archive: Use the external program to export the data in the DBF file to a flat (.txt) file, create the desired tables, and use sqlldr to load the data in the DB.
Open file with Access and export it into CSV format, than its easy to import from Oracle. Regards Rahul - Original Message - From: 'Dragan Kociski via oracle-db-l' To: 'RAHUL TAMRAKAR' Sent: Monday, June 21, 2004 11:05 PM Subject: oracle-db-l RE: load DBase file (.dbf) into Oracle database # delete duplicate record from table # View Code: # View Group Archive: HiI have the files as they are (dbf files) and I'm not able to make export of the data again. /Dragan -Original Message- From: omrisela via oracle-db-l mailto:[email protected] Sent: Monday, June 21, 2004 2:26 PM To: Dragan Kociski Subject: oracle-db-l RE: load DBase file (.dbf) into Oracle database # PeopleSoft Papers Raise Microsoft Fears # Read News: # View Group Archive: Use the external program to export the data in the DBF file to a flat (.txt) file, create the desired tables, and use sqlldr to load the data in the DB. Hi USE TOAD SACHIN - 'JHAYS.
Via oracle-db-l' wrote: # PeopleSoft Papers Raise Microsoft Fears # Read News: # View Group Archive: There is a utility that can read the.dbf header and determine the schema. I used it about 7-8 years ago in my foxpro daysbut can't remember what it was called or where it came from.
Using such a utility, you could recreate your DB, load the data and dump it in another format, or use ODBC to transfer your data. 'Dragan Kociski via oracle-db-l' 10:05 AM Please respond to oracle-db-l To: JHAYS. cc: Subject: oracle-db-l RE: load DBase file (.dbf) into Oracle database # delete duplicate record from table # View Code: # View Group Archive: HiI have the files as they are (dbf files) and I'm not able to make export of the data again. /Dragan -Original Message- From: omrisela via oracle-db-l mailto:[email protected] Sent: Monday, June 21, 2004 2:26 PM To: Dragan Kociski Subject: oracle-db-l RE: load DBase file (.dbf) into Oracle database # PeopleSoft Papers Raise Microsoft Fears # Read News: # View Group Archive: Use the external program to export the data in the DBF file to a flat (.txt) file, create the desired tables, and use sqlldr to load the data in the DB.
We need to move data from flat file to Oracle table frequently. For example sales department sends daily sale data in excel sheet to IT department, how this data feed into Oracle database (to tables)? We will examine different methods. SQLLOADER sqlloader is an Oracle utility to load data from external files to table. This is one of the most used utility in Oracle database. Search for: Enter your email address to follow this blog and receive notifications of new posts by email. Join 831 other followers Categories.
Blog Stats. 1,533,886 hits. How to design a database table. Daily backup script in Python. Analog Clock in Python. How to call stored procedure with argument(OUT parameter) from Unix shell script. How to call stored procedure with argument(IN parameter) from Unix shell script Follow Blog via Email Enter your email address to follow this blog and receive notifications of new posts by email.
Join 831 other followers Recent Posts.