Loading external information into Oracle - similar to BCP in Sybase and SQL Server
Posted on 2008-10-22
I have a question regarding loading external information (i.e. from a file for instance) into a table in an Oracle database.
I'm familiar with Sybase and SQL Server with doing a BCP IN. Oracle doe not have a BCP utility. It does have several other mannerisms. From some information I have gathered: SQLLDR in Oracle is commensurate with BCP IN in Sybase and SQL Server. The control file is commensurate with the format file, I believe. Yet, I have also heard and do not know much about them on datapump and datadump. In addition, it is also my understanding that since Oracle 9i there is also the ability of external tables. (Although, the external tables are a bit of a concern to me as they can have issues.)
I'm looking for something that is consistently applied and will meet about 80% or more of routine loading of information. (Again, like BCP IN in SQL Server and Sybase).
Any information on that would be greatly appreciated.