There are many ways to load data into Oracle -- Each of these processes varies in speed, simplicity, scalability, recoverability and data availability. There is no single best way to load data into Oracle and it varies with all the criterias mentioned above.
>>SQL*Loader
>>>>Data pump import and export
>>>>>>External tables
>>SQL*Loader >> Used when we have to load huge volumes of data into database from external sources, like a csv file.
It is used to load data from a single or multiple files in the same load session. We can also perform various data manipulations/ validations before loading. Selective load of data is also possible.
>>>>External tables >> They allow you to access tables outside the database, as they are actually present in the database. They are quite similar to how we use sql*loader. Its a convenient way to use sql*loader functionality. When an external table is queried, Oracle parses the flat file and provides data to the user in such a manner as if the data is stored in the database itself.
The user can define the structure of the flat file and then SQL query is used to generate iska kaam.
>>Data pump import and export >> This utility is used to transport oracle objects between different Oracle databases, regardless of the hardware and software.
>>SQL*Loader
>>>>Data pump import and export
>>>>>>External tables
>>SQL*Loader >> Used when we have to load huge volumes of data into database from external sources, like a csv file.
It is used to load data from a single or multiple files in the same load session. We can also perform various data manipulations/ validations before loading. Selective load of data is also possible.
>>>>External tables >> They allow you to access tables outside the database, as they are actually present in the database. They are quite similar to how we use sql*loader. Its a convenient way to use sql*loader functionality. When an external table is queried, Oracle parses the flat file and provides data to the user in such a manner as if the data is stored in the database itself.
The user can define the structure of the flat file and then SQL query is used to generate iska kaam.
>>Data pump import and export >> This utility is used to transport oracle objects between different Oracle databases, regardless of the hardware and software.
