ORACLE archivne logy (2)

[Kluvanek Martin]

Honza Pazdziora wrote:

> On Fri, Oct 17, 2003 at 03:56:41PM +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?
>>
>>V
>>http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c21dlins.htm#CNCPT528
>>sa pise ze
>>During direct-path INSERT operations, Oracle appends the inserted data 
>>after existing data in the table. Data is written directly into datafiles, 
>>bypassing the buffer cache. Free space in the existing data is not reused, 
>>and referential integrity constraints are ignored. These procedures 
>>combined can enhance performance.
> 
> 
> To ano. Nicmene Oracle si samozrejme pri SQL INSERTu hlida, zda cilove
> tabulky splnuji omezeni na direct-path kladena, a pokud ne, tak
> prechazi na konvencni INSERT. Tedy nedochazi ke zmene semantiky.
To ne ale pochopil som, ze akonahle na cielovej tabulke pouzijem
any triggers or referential integrity constraints
tak z direct- insert sa stane normalny a mam to zas vsetko v redo a casom 
archive logu.

> 


-- 
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