Wednesday, May 16, 2007

[Timesten] Error group cache(Oracle native error code = 1652), when insert or delete more data

Example ERror on "tterrors.log"

13:48:22.40 Err : ORA: 1092: ora-1092-1088731504-refresh07915: Error executing Oracle statement: SELECT L."CUSID", X."LOGIN", ... FROM "XX"."CHARTTT") X WHERE L."CUSID" = X."CUSID" (+)
13:48:27.96 Err : ORA: 1092: ora-1092-1088731504-refresh07891: Failed calling OCI function: OCIStmtExecute()
13:48:27.96 Err : ORA: 1092: ora-1092-1088731504-raUtils00373: Oracle native error code = 1652, msg = ORA-01652: unable to extend t
emp segment by 128 in tablespace TEMP



So: resolve by
1. connect databse rdbms and extend temp tablespace.
or add tempfile for explain

SQL>alter tablespace temp add tempfile '+DATA' size 1G;

After add extend temp tablespace
on TT DB

COMMAND> alter cache group alter cache group XX.READONLY_CHARTTT set AUTOREFRESH state PAUSED; set AUTOREFRESH state PAUSED;

Command> refresh cache group XX.READONLY_CHARTTT commit every 256 rows;

COMMAND> alter cache group alter cache group XX.READONLY_CHARTTT set AUTOREFRESH state PAUSED; set AUTOREFRESH state ON;


For refresh...

No comments: