› Fóruns › SQL e PL/SQL › Como fazer update sem usar undo ? › Como fazer update sem usar undo ?
David SiqueiraEverson, dê uma lida nisto :
[i]Disabling Logging (NOLOGGING)
Logging can be disabled at the table level or the tablespace level. If it is done at the tablespace level then every newly created index or table in this tablespace will be in NOLOGGING mode you can have logging tables inside a NOLOGGING tablespace). A table or an index can be created with NOLOGGING mode or it can be altered using ALTER TABLE/INDEX NOLOGGING. It is important to note that just because an index or a table was created with NOLOGGING does not mean that redo generation has been stopped for this table or index. NOLOGGING is active in the following situations and while running one of the following commands but not after that. This is not a full list:[/i]
Retirei isso de um dos links que tenho aqui :
http://vnull.pcnet.com.pl/blog/?page_id=107
Pode ser que lhe traga alguma luz, veja se lhe ajuda e post aqui para nós.
Abraço