rollback seg materialized view

[shelley2342]

is it possible to assign a materialized view to use a specified rollback segment?

 

[SantaMufasa]

Yes, Shelley, you can assign a specific rollback segment for any transaction (regardless of what you plan on doing in the transaction) with the following code:

commit;
Set transaction use rollback segment <rbs-name>;

the "commit" prior to the set is just to ensure that your "set transaction" statement is the first statement in the transaction.

Let us know if this produces the effect that you wanted.


Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[stefanhei]

Specify the rollback segment in the refresh clause of your create statement, like:

CREATE MATERIALIZED VIEW mv_demo
 REFRESH COMPLETE USING ROLLBACK SEGMENT yourRBS
 AS 
 SELECT * 
   FROM yourTable;

(unverified, as I don't have any DB still using rbs)

Stefan