Re: Rollback segment question (need help)

ffeng_at_cs.tamu.edu (Fang Feng) writes:
>5. Create new tablespace 'mc_space' by
> create tablespace mc_space
> datafile 'path/filename' size 80M resue
> default storage (initial 50M next 50K
> minextent 1 maxextents 600
> pctincrease 0)
>6. Create new rollback segment by
> create rollback segment roll_mc
> tablespace mc_space
> storage (initial 50000 next 50000
> minextents 1 maxextents 100
> pctincrease 0)
> This SQL command caused error:
> ORA-01552: cannot use system rollback segment for non-system tablespace 'MC_SPACE'

Try the same thing without the 'default storage' section when creating your new tablespace. Like this:

        create tablespace mc_space
	     datafile 'path/filename' size 80M resue

erlend

--
Erlend Dyrnes , Computer Science Engineer, SNF
at The Norwegian Scool of Economics and business administration
Email : edb_erlend_at_debet.nhh.no, erlendd_at_barsoom.nhh.no
	"ROCK BOTTOM! I hope for your sake that you nuked that level."