Re: ORA-01552

"Timothy S. Mori" wrote:
>
> The text of this error is: cannot use system rollback segment for
> non-system tablespace. I received this when I finally got sql loader
> running. Of course it doesn't process any of my data because of the
> error. Can anyone direct me to a decent tutorial on Oracle
> administration of table spaces and segments. We only have Oracle running
> at bare minimums for testing, i.e. there is only one tablespace. So, let
> me guess, until there are private segments set up, this will always be a
> problem?
>
> Tim

It is absolutely imperative that you define a rollback segment other than the system rollback segment - even if that means defining it in the SYSTEM tablespace. It is highly prefereable, however, that you defind the rollback segment in some other tablespace. With only a few exceptions, all of the systems that I have ever worked on have a tablespace that is solely dedicated to rollback segments, but I realize that there are many systems which are set up to have data segments and rollback segments in the same tablespace. Received on Mon Jan 03 2000 - 20:15:21 CET