Αποτελέσματα Αναζήτησης
17 Αυγ 2014 · SQL Error: ORA-01652: unable to extend temp segment by 128 in tablespace SYSTEM 01652. 00000 - "unable to extend temp segment by %s in tablespace %s" *Cause: Failed to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated.
My temp tablespace is definitely temp-allocated, checked contents field of dba_tablespaces. (it's the default one created by dbca). I tried all of the following: ALTER DATABASE TEMPFILE 'C:\ORACLE\ORADATA\DEV\TEMP02.DBF' RESIZE 2000M; -- initially 40M ALTER TABLESPACE "TEMP" ADD TEMPFILE 'C:\ORACLE\ORADATA\DEV\temp02.dbf' SIZE 2000M;
Oracle uses temporary tablespaces to improve the concurrency of multiple sort operations that do not fit in memory. On top of this, Oracle stores temporary tables, temporary indexes, temporary B-trees, and temporary LOBs in temporary tablespaces.
A temporary tablespace can be shared by multiple users and can be assigned to users with the CREATE USER statement when you create users in the database. Within a temporary tablespace, all sort operations for a given instance and tablespace share a single sort segment.
2 Ιουλ 2013 · HI looking from ur query on dba_tablespaces, temp tablespace's status is showing OFFLINE. try bringing the tablespace back online. alter tablespace tablespacename online;
Here's the error I get: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP. 01652. 00000 - "unable to extend temp segment by %s in tablespace %s". *Cause: Failed to allocate an extent of the required number of blocks for. a temporary segment in the tablespace indicated.
You can assign a temporary tablespace to each database user with the CREATE USER or ALTER USER statement. A single temporary tablespace can be shared by multiple users. You cannot explicitly create objects in a temporary tablespace.
