Post reply

Ora-01652: unable to extend temp segment by

  • June 24, 2003 at 5:49 am

    #106580

    Hi all,

    When processing a cube a recieve the following

    error: Ora-01652 (unable to extend temp segment by ...).

    I use Oracle tables and views as fact and dimension tables.

    Has anybody seen this before ?

    Thanks in advance.

    Regards,

    Bart

  • June 24, 2003 at 7:36 am

    #462817

    expand the Temporary tablespace....

    ie

    create temporary tablespace temp

    tempfile '/whatever/temp03.dbf' size 300M

    extent management local;

  • June 24, 2003 at 7:40 am

    #462820

    HenryTr,

    I've contacted my DBA the temp. tablespace

    is 5,5 GB. I used all... reason the query that AS uses when processing the cube is not good or to sloppy...

    Thanks for the response.

    Regards,

    Bart

  • June 24, 2003 at 9:03 am

    #462841

    No problem. 5.5 GB of temp spaced used? How big is the Oracle DB just out of curiosity.

  • June 24, 2003 at 7:37 pm

    #462905

    Have you optimised your model? This could help with the query that's being fired towards your oracle DB.

    Also, have you copied the query being run and looked at it? If you had a problem with the joins between dimension and fact tables, you could potentially be generating a bigger resultset than what you are expecting.

    Steve

    Steve.

  • June 25, 2003 at 12:05 am

    #462913

    Steve and Henry,

    Thanks for the replies.

    Indeed the model is not ye optimized

    because it was just for some (quick) testing

    to find out what are the limits.

    Perhaps we should take this in notice.

    I don't know how big the DB in Oracle is. I can ask the DBA.

    Regards,

    Bart

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply