strange temporary segment names
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 5 Dec 2008 11:22:40 +0000
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
Other related posts:
