Re: Problems with creating new database

When You create a database Oracle creates a System Rollback segment within the system tablespace by default. however before you use the database you have to create a rollback segment for use by users other than SYS. If you do not do this you get the message:

ORA-01552: cannot use system rollback segment for non-system tablespace 'USR' This Rollback Segment should also preferable be in it's own tablespace.

I Hope this was useful

Cheers
akader_at_health.sanlam.co.za

Matthew Arrocha <marrocha_at_belllsouth.net> wrote in article <01bcd0c8$947ba8e0$670c35cf_at_marrocha>...
> In the Enterprise Manager, have the OEM rediscover the services on the
 node
> you are on so it will be in the OEM list or the repository cannot run
> agaist it.
>
> Matt Arrocha
> marrocha_at_bellsouth.net
>
> Haresh Assumal <assumal_at_sprynet.com> wrote in article
> <01bcc9ce$42ee7120$fab1aacc_at_mycomp.intermediainc.com>...
> > I am new to oracle and I have been working to create a new database
 using
> > oracle 8 under NT4.0.
> > I used the tool - Database Assistant and created a new database called
 TST.
> > I then had to manually modify the listener.ora and manually create a
> > Service to the new SID (also called TST).
> >
> > Now I tried to go into the enterprise manager as "system" using the new
> > service and I get an error in the Oracle Repository Manager:
> >
> > XP-07016: A database error has occurred:
> > insert into smp_rep_version (c_component, c_current_version, c_unused)
> > values (:1,:2,'')
> > ORA-01552: cannot use system rollback segment for non-system tablespace
> > 'USR'
> >
> > What do I need to do? Shouldn't the utiltiy that created the database
 take
> > care of this? What is the best way to manage/create a database. Oracel
 8
> > tools do not seem to be integrated/work properly. If thats the case
 then
> > whats the best way to manage the database, although I may be using the
> > tools wrong.
> >
> > Thanks,
> > Haresh Assumal
> >
> > Email: assumal_at_sprynet.com
> >
> >
> >
> >
> >
>
  Received on Mon Oct 06 1997 - 00:00:00 CDT