ORACLE archivne logy (2)

Kluvanek Martin kluvanek na
Pátek Říjen 17 16:08:22 CEST 2003

Honza Pazdziora wrote:

> On Fri, Oct 17, 2003 at 03:14:32PM +0200, Kluvanek Martin wrote:
>>Cele je to nanic ,pretoze zas v direct insertoch o.i. nefunguju veci ako 
>>triggery, restrictions, referencna integrita atdatd.
> A neni to nahodou tak, ze mluvite o loaderu, nikoli o append
> insertech?
O insertech.
Conventional and Direct-Path INSERT
Direct-path INSERT is subject to a number of restrictions. If any of these 
restrictions is violated, then Oracle executes conventional INSERT serially 
without returning any message (unless otherwise noted):

     * You can have multiple direct-path INSERT statements in a single 
transaction, with or without other DML statements. However, after one DML 
statement alters a particular table, partition, or index, no other DML statement 
in the transaction can access that table, partition, or index.
     * Queries that access the same table, partition, or index are allowed 
before the direct-path INSERT statement, but not after it.
     * If any serial or parallel statement attempts to access a table that has 
already been modified by a direct-path INSERT in the same transaction, then 
Oracle returns an error and rejects the statement.
     * The ROW_LOCKING initialization parameter cannot be set to INTENT.
     * The target table cannot be index organized or clustered.
     * The target table cannot contain object type or LOB columns.

     * The target table cannot have any triggers or referential integrity 
constraints defined on it.

     * The target table cannot be replicated.
     * A transaction containing a direct-path INSERT statement cannot be or 
become distributed.

Martin Kluvanek
ved.odd. vyvoje (head of development department)
TES s.r.o
Testovani Energetickych Systemu (Testing of Energetical Systems)

Prazska 597
674 01 Trebic
Czech republic
tel:568 8384 28  (+420 5688384 28)
fax:568 8384 27  (+420 5688384 27)

Další informace o konferenci Test