OraFAQ Forum: Server Administration » Update table and avoid redo logs

Home » RDBMS Server » Server Administration » Update table and avoid redo logs

Tue, 16 July 2002 13:16

sateesh
Messages: 8
Registered: April 2000

Junior Member

Can I append update table nologgin to sql statement to avoid generating redo logs.. thans

Tue, 16 July 2002 15:10

ctg
Messages: 146
Registered: July 2002

Senior Member

you can not avoid generating redo logs on an Update stmt.

Wed, 17 July 2002 14:46

oracle
Messages: 9
Registered: May 2002

Junior Member

am not sure abt this..just giving a shot!

Alter table tablename nologging;

Update tablename set blah blah
commit;

alter table tablename logging;

Previous Topic:	need help
Next Topic:	Oracle 9i License

Goto Forum:

]

Current Time: Wed Sep 18 21:36:11 CDT 2024