11 Replies Latest reply on Dec 15, 2011 8:26 AM by 667657

    Error: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1

    Harshith
      Hi,
      we are having 4 dim table & 2 fact tables all tables are joined with PK:Org_ID colunm.When we choose columns from more then one Dim tables then getting following error.
      kindly help on this.

      Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 16001] ODBC error state: S1000 code: 1652 message: [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1. [nQSError: 16015] SQL statement execution failed. (HY000)