Re: Help!!! Rollback tablespace

From: Amit Aggarwal <amaggarwal_at_kendle.com>
Date: 1997/09/19
Message-ID: <3422B083.377@kendle.com>#1/1

Yong Zou wrote:
>
> Our company just bought Oracle 7.3, and I created 4 tablespaces (Data,
> rollback, temp, user) for our new database. when I run from this
> database, I found it use system rollback tablespace instead of the
> rollback tablespace which I created. Is there anyone know what's the
> problem is, and how to fix it? Any inputs are welcome, and please send
> me a response via email. Thanks

I think you are a little confused about rollback tablespace and rollback segments. After you create rollback tablespace, you have to create rollback segments in that tablespace. Seems like you only have system rollback segment which resides in the System tablespace. Check dba_rollback_segs view.

amit
Oracle DBA/Unix SA Received on Fri Sep 19 1997 - 00:00:00 CDT