ORACLE archivne logy (2)

[Honza Pazdziora]

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.

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
 .project: Perl, mod_perl, DBI, Oracle, auth. WWW servers, XML/XSL, ...
		Only self-confident people can be simple.