Temporary space 2005-09-08 - By Jared Still
What was the full text of the error message?
In particular, which tablespace did it indicate in the message text?
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
11+ years of trying to appear to know what I'm doing.
On 9/8/05, Enrique Fernandez-Pampillon <oracle.pampillon@(protected)> wrote:
> Does anyone know where to find information related to how increase the
> necessary temporary space when I increase the parallel degree?
>
> We have a large data warehouse (20Tb). and lately some ORA-01652 (See ORA-01652.ora-code.com) have
> raised when we execute some insert /*+ append */ select.
>
> I have decrease the parallel_query, parallel_dml and parallel_ddl
> parameters and the insert /*+ append */ takes a long time but it
> works.
>
> Thank you very much
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
> Enrique
> --
> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l
|
|
