Re: How to set rollback segment for tablespace
Date: 10 Feb 1994 08:41:33 GMT
Message-ID: <2jcrvt$akn_at_netserver.univ-lille1.fr>
In article <TIM.94Feb9150031_at_sun1.claremont.com>, tim_at_sun1.claremont.com (Tim Maggio) writes:
|>As the subject implies-
|>
|>How do I set the rollback segment for a tablespace (or user)?
|>
|>I am updating a table, and oracle responds that it failed to
|>create an extent in tablespace RBS. What I would like to do
|>is set the rollback segment to another table space in some
|>way.
|>
|>My work around was to add space to the rollback segment RBS
|>and increase it's size.
|>
|>Thanks for any input
|>--
|>Tim Maggio
|>tim_at_claremont.com
|>
Tim, first you can made adjustments to the default storage of the tablespace by
issuing the command : alter tablespace <name> storage (initial xxx next xxx...);
Second, you can also opt to alter the user so that he uses a tablespace you
know has more free space : alter user <username> temporary tablespace '<new_
tablespace_name>';
Hope this help!
-- ______________________________________________________________________________ Yves NOEL - Database Administrator C.I.T.I. (batiment M4) Mail : noel_at_univ-lille1.fr Universite des Sciences & Technologies de Lille Phone : (33) 20.43.42.70 59655 Villeneuve d'Ascq Cedex - FRANCE Fax : (33) 20.43.66.25 ______________________________________________________________________________ _/_/_/_/ _/_/_/_/ _/_/_/_/ _/_/_/_/ I use ORACLE v6.0.36 _/_/ _/_/ _/_/ _/_/ on _/_/ _/_/ _/_/ _/_/ DEC RISC ULTRIX v4.3 _/_/_/_/ . _/_/_/_/ . _/_/ . _/_/_/_/ . ** ______________________________________________________________________________Received on Thu Feb 10 1994 - 09:41:33 CET