What is the different between conventional and Direct Method loading?
Answer Hi, Following are some differences Conventional 1) When SQL*Loader performs a conventional path load, it competes equally with all other processes for buffer resources. This can slow the load significantly. Extra overhead is added as SQL commands are generated, passed to Oracle, and executed. 2) Used when accessing an indexed table, when loading data in clustered table, load small data into large indexesed tables or using SQL functions in the data fields. Direct path Load 1) Instead of filling a bind array buffer and passing it to Oracle with a SQL INSERT command, a direct path load parses the input data according to the description given in the loader control file, converts the data for each input field to its corresponding Oracle column datatype, and builds a column array structure (an array of
