only if you can figure out some way to do it with ddl instead of dml, eg, create table as select instead of a large delete.

-----Original Message-----
From: Yves
[mailto:oracledba-ezmlmshield-x76827274.[Email address protected]
Sent: Thursday, July 07, 2005 8:27 AM
To: LazyDBA Discussion
Subject: Undo tablespace....


Can you tell ORACLE not to use the rollback(so you won't run out of it on big transactions)?

Just curious to find out if there is a way.


Merci / Thanks
Yves Leonard,
Chef de Projet / Project Leader,
DDS / SDD,
RH Coats, 13-I
Téléphone / phone : 613-951-3233,
couriel / email : yves.[Email address protected]




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page