Re: ORA-01552 System Rollback Question

>I'm moving from Oracle 7.1.6 on AIX to 7.3 on windows NT. I have run
>identical scripts on both versions to create the database and schema and
>these all run OK. However, when I attempt a user txn on the 7.3 database I
>get an "ORA-01552 cannot use system rollback segment for non-system
>tablespace".
>

It sounds like you did not create any rollback segments in your database. The system rollback segment is created automatically, but you need more than just that one.

Ah, look, I just checked:

01552, 00000, "cannot use system rollback segment for non-system tablespace '%s'"

// *Cause: Tried to use the system rollback segment for operations involving
//        non-system tablespace
// *Action: Create one or more private/public segment(s), shutdown and then
//         startup again. May need to modify the init.ora parameter
//         rollback_segments to acquire private rollback segment

-- 
                     ------------------------------------
If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at
                     http://www.panix.com/~gsa/index.html