Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to import dbf files into oracle database

DrakeTalorDec 5 2013 — edited Dec 10 2013

I have installed oracle 11g and I am trying to import files that were exported since 2010.

Been searching for days on how to do this properly. I found a utility outside of oracle that tries to import dbf files into the database using SQL Loader. I previously tried to get into SQL loader but I had issues with login information.

The DBF files were found in a zip files named ora_data1.zip, ora_data2.zip, ora_data3.zip, and ora_data4.zip.

For now, I would like a detailed way on how to either have the zip files with the dbf files imported into the database or have the dbf files imported.

Keep in mind I am new to Oracle and SQL.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 7 2014

Added on Dec 5 2013

#general-database-discussions, #import, #oracle, #sql

24 comments

28,273 views