ORACLE archivne logy (2)

Kluvanek Martin kluvanek na tesnet.cz
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.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_913a.htm#2063932
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)
homepage: http://www.tesnet.cz



Další informace o konferenci Test