Re: strange temporary segment names

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_at_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
>
>

-- 
Regards,
Yaping Chen

http://yaping123.wordpress.com

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