Re: recovery without restoring backup

niy38_at_hotmail.com wrote:
> 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 ?

Well, you're the one who says the system was running normal until... I suppose it is possible that you only looked after the error was there a while. See your DBA.

jg

--
@home.com is bogus.
Britney, what happened to that stuff under there?