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_at_gmail.com> 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 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
Received on Thu Sep 08 2005 - 11:45:22 CDT
