RE: 11gr2 v$access oddity?

From: Powell, Mark <mark.powell2_at_hp.com>
Date: Fri, 18 May 2012 14:05:18 +0100
Message-ID: <7C4BF3B32B80CC44AE37D31B172415937DDE889E28_at_GVW1337EXC.americas.hpqcorp.net>

Wouldn't that indicate that Oracle Workspace Manager (9i+) is in use?

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dbvision_at_iinet.net.au Sent: Thursday, May 17, 2012 6:55 PM
To: oracle-l_at_freelists.org
Subject: 11gr2 v$access oddity?

        This from a query on v$access in our DW in 11.2.0.3.2:

                   SID OWNER           OBJECT
-------------- --------------------

---

TYPE

---

            95 DWDEVTEAM     F_GL_MONTHLY_BALANCE TABLE             95 DWDEVTEAM     F_GL_MONTHLY_BALANCE MULTI-VERSI ONED OBJECT         F_GL_MONTHLY_BALANCE is a partitioned table.

        "Multi-versioned object"?????

        Looked it up everywhere, doesn't seem to register in google.

        Anyone seen this before?  What exactly is a "multi-versioned object"?

         

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri May 18 2012 - 08:05:18 CDT