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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • valexena
    #1

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


    1. Do you know in which tablespace the tables that store
    information about the Oracle online rollback segments is
    located?


    --
    Posted via http://dbforums.com
    Tags: None
    • Mark D Powell
      #2
      Re: 1. Do you know in which tablespace the tables that store information about the Oracle

      valexena <member43815@db forums.comwrote in message news:<3551988.1 067847165@dbfor ums.com>...
      1. Do you know in which tablespace the tables that store
      information about the Oracle online rollback segments is
      located?

      The answer to your question would be the SYSTEM tablespace and memory
      (SGA). See the Oracle version# Reference manual.

      The following articles may help
      How do I find information about a database object: table, index,
      constraint, view, etc… in Oracle ?
      http://www.jlcomp.demon.co.uk/faq/object_info.html


      HTH -- Mark D Powell --

        Comment

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

          valexena <member43815@db forums.comwrote in message news:<3551988.1 067847165@dbfor ums.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_SE GS etc.

            Comment

            Previous template Next
            Working...