strange temporary segment names

From: LS Cheng <exriscer_at_gmail.com>
Date: Fri, 5 Dec 2008 11:22:40 +0000
Message-ID: <6e9345580812050322l701cd92fvdaa12fba864fd9a3@mail.gmail.com>


Hello

I have a database with some strange temporary segments under SYS schema seen from dba_segments as follows:

OWNER                          SEGMENT_TYPE
SEGMENT_NAME                   TABLESPACE_NAME

------------------------------ ------------------
------------------------------ ------------------------------
SYS TEMPORARY 84.41971 TBS_DON_DATA SYS TEMPORARY 84.13427 TBS_DON_DATA SYS TEMPORARY 84.12659 TBS_DON_DATA

I remember see these sort of names when a index is being rebuilt but this is not the case. They are constantly there.

This happened after transporting 3TB Tablespaces from a 10g database running on Solaris to a 2 Nodes Linux x86-64 RAC running in 11g.

any clues?

Thanks

--

LSC
--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 05 2008 - 05:22:40 CST

Original text of this message