ORACLE archivne logy (2)

[Kluvanek Martin]

Jan Serak wrote:
> Kluvanek Martin wrote:
> 
>> Lenze niektore dokumenty tvrdia, ze capture proces zachytava prikazy 
>> INSERT,DELETE..... a ked mu cez NOlogging poviem, tak nezachytava...
> 
> 
> To by me zajimalo, ve ktere dokumentaci...
> 
> Oracle9i SQL Reference:
> 
> The logging_clause lets you specify whether creation of a database 
> object will be logged in the redo log file (LOGGING) or not (NOLOGGING). 
> This clause also specifies whether subsequent Direct Loader (SQL*Loader) 
> and direct-path INSERT operations against the object are logged 
> (LOGGING) or not logged (NOLOGGING).
atd... viem, to sa pise napriklad v
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/clauses6a.htm#1000954

ale v
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96571/capture.htm#55773
sa pise :
Each row LCR contains the following information:

The name of the source database where the row change occurred
The type of DML statement that produced the change, either INSERT, UPDATE, 
DELETE, LOB ERASE, LOB WRITE, or LOB TRIM
.....

Tym som predpokladal, ze LCR bezprostredne suvisi s logmi (log obsahuje LCR...) 
ale to je zas v rozpore s predch. dokumentom ohladom nologging option.

> 
> 
> Jinak [NO]LOGGING neni vlastnost tablespacu, nybrz segmentu v nem 
> ulozenych. Tablespace ma vetsinu vlastnosti jen jako DEFAULT pro v nem 
> nove vytvarene objekty (MIN_EXTENTS, MAX_EXTENTS, INITIAL_EXTENT, 
> NEXT_EXTENT, PCT_INCREASE - priklady dalsich takovych vlastnosti).
Chapem, ale ja som
1)vytvoril novy tablespace s NOLOGGING
2)DROPol tabulku ktoru som nechcel logovat
3)vytvoril tabulku a index s odkazom na pouzitie noveho tablespace s NOLOGGING
(v browseri vidim, ze v tablespace MSENOLOGGING su objekty moja tabulka a index..)

> 
> 
>> A co CONTENS=TEMPORARY (ci aky je opak PERMANENT?)
>> Podla ma tie data potom drzi stale LEN  v pamati a po restarte session 
>> to bude prazdne???
> 
> 
> V Oracle9i je rozdil mezi:
> 
> create tablespace xx datafile ... temporary;
> 
> a
> 
> create temporary tablespace yy datafile ...;
> 
> Permanentni segmenty v tablespacu yy vytvorite a jejich existence bude 
> automaticky ukoncena spolu se session. Zatimco v tablespace xx Vam 
> Oracle vubec nedovoli vytvorit permenantni segment (muzete tam vytvaret 
> pouze temporary segmenty, ktere Oracle implicitne vytvari kdyz potrebuje 
> tridit (ORDER BY, GROUP BY, vyroba indexu) a tridena data se nevejdou do 
> SORT AREA).
Cize z toho mi nic nieje platne, ja potrebujem nieco co bude prermanent ale 
absolutne vsetko NOLOGGING
Na manipulaciu s datami v tabulke sa kazdych 10s otvara nova session a navyse k 
nim potrebuju pristupovat ine sesions...

> 
:-(

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