Re: how do I set the default rollback seg for a user?

Todd Marshall <toddm_at_semaphore.com> wrote:

>I bumped into this error today, after the fifth or sixth insert into a
>table.
>
>ORA-1552: cannot use system rollback segment for non-system tablespace
>'COLLECTOR'
>
>I have the default tablespace set to COLLECTOR for this user. Why would
>it try to use the system rollback space???? How do I correct this?

Did you create any other rollback segments? If SYSTEM is the only one, it'll use that one. Otherwise it'll use the others (generally speaking).

See ch. 17 of the System Administrators Guide for more info.

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!