That sort of thing - more specifically the cases where
the index create fails because of insufficient space,
leaving the temporary segment in place - or a user
process gets killed in the middle of' 'create table
as select'.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Yong Huang wrote in message ...
>
>BTW, what's the meaning of your word "accidents" in the first
>paragraph? You probably meant the "ephemeral" temporary segments that
>exist in permanent tablespace while the index is being created?
Received on Thu Jun 07 2001 - 16:33:24 CDT
