Geek asks and answers

What could cause Oracle to ignore the APPEND prompt asking for direct path loading?

I want to make a series that registers the insertion of massive data from one table into another. This is only once as part of the data migration, so replacing partitions, etc. Not an answer.

SQL will have the following structure:

INSERT /*+ APPEND */ ... SELECT FROM ....

What can force Oracle to run this conditional insert rather than insert a direct path?

For example, I believe that having a trigger in a table will cause Oracle to conduct a confidential insert. Is there a final list of restrictions?

+3
source share
1 answer

Quote from http://asktom.oracle.com/pls/asktom/f?p=100:11:59::::P11_QUESTION_ID:1211797200346279484 :

"insert/* + append */ , ..." - Tom Kyte

https://docs.oracle.com/cd/E18283_01/server.112/e17118/statements_9014.htm#sthref6486

INSERT . - , Oracle Database INSERT , , :

  • INSERT DML . DML , , DML , .

  • , , , INSERT , .

  • - , INSERT , .

  • .

  • .

  • INSERT (IOT), , , .

  • INSERT (IOT) IOT , IOT , APPEND APPEND_VALUES. , INSERT IOT , , IOT .

  • , .

  • .

  • , INSERT , .

. , INSERT , .

+6

More articles:


All Articles