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