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...
Wednesday, May 16, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment