Oracle 9i Database -- DBA Fundamentals II (12)

Loading Data into a Database

• The conventional path of data loading involves the generation of redo logs, makes use of the COMMIT command to make changes permanent in the table, allows data loading into clustered tables, and allows other users to make changes to the tables while the data loading is in progress.
• The Direct-path method of transporting data, unlike the conventional load method, bypasses the buffer cache, requires that the character sets on both client and server be the same, and can be set by specifying DIRECT=y.