ORACLE_基础十五--Loading Data into a Database

Direct Load

Oracle Database inserts data into a table in one of two ways:

1.During cnventional INSERT operations the database reuses free space int he table, interleaving newly inserted, data with existing data, During such operations, the database also maintains referential integerity constrains.

2. During direct-path INSERT operations, the database appends the inserted data after existing data in the table. Data is written directly into datafiles, by passing the buffer cache, Free space in the existing data is not reused, and referential integerity constraints are ignored .Theses prcedures combined can enhance performance.

 Further , the data can ben inserted either in serial mode, where one process executes the statement, or parallel mode , where multiple processes work together simultaneously t run a single SQL statement, The latter is referred to as parallel execution.

Direct Load insert can be performed in the following ways:

1.Normal(serially ),or in parallel

2. Into partitioned tables, nonpartitioned tables , or single partitins of a table.

3. With or without logging of redo data.

/*+ APPEND */ ：不要使用高水位 以前的数据块

注意：  /*+APPEND*/方式插入的记录 要commit之后才能查询

Direct Load Logging Mode

验证 NOLOGGING 选项：

NOLOGGING 不起作用

SQL*LODER

case1.ctl:

Direct vs Conventinal Loads