Re: ERROR:ORA-01552: cannot use system rollback segment for non-system tablespace 'O910IA'

You probably have rollback segments in the system tablespace only, or more likely you do have a second rollback segment in the system tablespace, however it's not online now. Otherwise you wouldn;t have been able to create a second tablespace (of course unless you used a preconfigured Oracle database during installation)
Anyway, only DDL transactions (create table etc) can use the system rollback segment. All other transactions can only run on rollback segments with a name other than system and preferabbly they should be located in their own tablespace.
Here's how to look at the current status select * from dba_rollback_segs

If you create a rollback segment which is non-public (and you should use public rollback segments only in Parallel server installations), you need to change the line rollback_segments in your init<sid>.ora. Otherwise the newly created rollback segment will go offline if you bounce the database.

Hth

Sybrand Bakker
(postbus_at_sybrandb.demon.nl)
Roger Sprague wrote in message <6shlnr$blk4_at_biko.telecom.ups.com>...
>I created the tablespace O910IA as the default tablespace for user O910IA
>and TEMP as the temporary tablespace.
>Auto Extents is enabled at 1024 on the datafile. All other settings are set
>to default.
>
>When I try to run the copy command in SQL*PLUS in an attempt to copy to the
>O910IA schema I receive the error.
>ERROR:ORA-01552: cannot use system rollback segment for non-system
>tablespace 'O910IA'
>
>
Received on Fri Sep 04 1998 - 08:49:48 CEST