Re: recovery without restoring backup

joel garry wrote:
> niy38_at_hotmail.com wrote:
> > version is: 10.2.0.1.0
> >
> > database is running normal until developer complain this error:
> >
> > ORA-01552: cannot use system rollback segment for non-system tablespace
> > 'USERS'
>
> I can't imagine getting ORA-01552 without doing some DBA type of task -
> what are your developers doing? DDL on the fly? Truncate table with
> too small undo?
>
> >

not sure what they're doing, is that related ? Received on Tue Dec 05 2006 - 10:48:06 CST