Re: mystery object
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: howard.latham@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Feb 2009 22:44:17 +0800
It is the result of either of a
a. CREATE TABLE AS SELECT
b. CREATE INDEX
c. ALTER TABLE .. MOVE
d. ALTER INDEX ... REBUILD
in progress. Each of these operations create a "Temporary"
segment. On successful completion, the "Temporary" segment becomes a
"Permanent" Table or Index segment (as the case may be).
See
http://hemantoracledba.blogspot.com/2008/05/temporary-segments-in-dataindex.html
for examples.
Hemant K Chitale
http://hemantoracledba.blogspot.com
At 10:26 PM Wednesday, you wrote:
Oracle 10g Redhat linux 32bit
I have a mystery object in a data tablespace anyone know what it might be?
Its big 149 Gigs!
Name 68.9
Type TEMPORARY
Bytes 1.4011E+11
--
Howard A. Latham
--
//www.freelists.org/webpage/oracle-l
Other related posts:
