Re: strange temporary segment names
- From: "Yaping Chen" <hangzhoumaster@xxxxxxxxx>
- To: exriscer@xxxxxxxxx
- Date: Fri, 5 Dec 2008 22:23:35 +0800
Hi,
If I remember correctly I once saw the similar information during I
rebuild table/build index.
Did you submit commands like alter table move, alter/create index when you
saw the data?
2008/12/5, LS Cheng <exriscer@xxxxxxxxx>:
>
> 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
>
>
--
Regards,
Yaping Chen
http://yaping123.wordpress.com
Other related posts:
