Re: UNDO Tablespace, and how NOT to use

Guy Taylor wrote:
> I bought the book this AM.
>
> I know the UNDO tablespace filling up is a problem because the Oracle
> DBA insists it is. If there is no downside to this tablespace filling
> up, then I have been mislead. Perhaps my terminology is wrong
> regarding the "temporary" table. I create a table in the schema's
> tablespace, run queries against it, and then drop it when I am done.
> Thus, perhaps it is not a "temporary table" as defined in the
> literature.
>
> Regardless, I hope the chapter about the UNDO tablespace in the book
> can illustrate how to construct queries, or form transactions, that do
> not leverage the UNDO tablespace. This should keep my DBA from adding
> gigs and gigs of space to the tablespace.
>
> Also, thanks for all the responses. They were very helpful.
>

Maybe that both you and your dba have to read carefully Tom's book. Why do you say that UNDO tablespace filling up is a problem ?????? it is there for this Oracle manages UNDO space automatically (i you use a version on this century) and that space is needed. Does it costs more a GigaByte of disk occupied by UNDO or days of your time spent to try not to use to much UNDO? It makes no sense, Thomas Kyte explains all very well in his book, so please read carefully his book and make your DBA read it and only after that came here to say us that UNDO tablespace filling up is a problem

regards

-- 
Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com