Re: 1. Do you know in which tablespace the tables that store information about the Oracle

From: Austin <hacketta_57_at_yahoo.com>
Date: 3 Nov 2003 09:36:15 -0800
Message-ID: <c59a59b7.0311030936.5c154ba0_at_posting.google.com>

valexena <member43815_at_dbforums.com> wrote in message news:<3551988.1067847165_at_dbforums.com>...

> 1.      Do you know in which tablespace the tables that store


>         information about the Oracle online rollback segments is


>         located?


If I understand you correctly the answer is the SYSTEM tablespace. All

the base tables used by the data dictionary views should be in the SYSTEM tablespace, and obviously this includes DBA_ROLLBACK_SEGS etc. Received on Mon Nov 03 2003 - 18:36:15 CET

This message: [ Message body ]
Next message: Austin: "Re: Which clause in a create user statement restricts the number of tables a user can add"
Previous message: sybrandb_at_yahoo.com: "Re: Transaction hangs"
In reply to valexena: "1. Do you know in which tablespace the tables that store information about the Oracle"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message