Re: Oracle9iAS - Make sure there is at least one online non-system rollback segment?

On 29 Sep 2004 05:41:39 -0700, nomorezpam3_at_hotmail.com (Alan) wrote:

>I'm running through the installation instructions "Oracle Internet
>File System" for Oracle9iAS on Solaris8 and I've hit a statement in
>the guide that reads
>"d. Make sure there is at least one online non-system rollback
>segment. ".
>
>It tells me what to look for (check if any segments come back with a
>tablespace name of "USERS") but it doesn't say how I get one if I
>haven't already got it.
>
>Not being a DBA I'm not familiar with this. Can anyone tell me how to
>add a non-system rollback segment in Oracle9i?
>
>Thanks
>Alan

create rollback segment <segment_name>
is the statement for this
optionally followed by
tablespace <tablespace_name> storage ...... if you already have multiple tablespaces (select tablespace_name from dba_tablespaces to verify)

followed by
alter rollback segment <segment name> online

--
Sybrand Bakker, Senior Oracle DBA