Αποτελέσματα Αναζήτησης
21 Αυγ 2014 · The error message is pretty clear, the maximum file size is 4194303 blocks. If you multiply that out. 4194303 blocks * 8192 bytes/ block / 1024^3 = 32 GB. So you're limited to individual data/ temp files of up to 32 GB. You can, however, have thousands of data files in a tablespace.
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.
There isn't a lot you can do to avoid using it: it's automated by Oracle. Most often, your options are "process less data at once" or "make TEMP bigger". You can either manually enlarge one or more datafiles in your TEMP tablespace, set the datafiles to autoextend up to a limit, or add more datafiles. You can monitor usage by session with this:
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;
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.
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.
2 Ιουλ 2013 · CREATE INDEX TimestampInd ON AcctEvent(Timestamp); And I get the following error: ORA-1652: unable to extend temp segment by 1024 in tablespace ACCT. This index should be stored in tablespace ACCT.
