Αποτελέσματα Αναζήτησης
If you want to change the default temporary tablespace, you can use the following command: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE tablespace_name; Code language: SQL (Structured Query Language) ( sql )
Our Database (Oracle 8.1.7) has 2 temporary tablespaces - TEMP (DMT) and TEMP_TRUE (true temporary LMT). All application users have still default temporary tablespace TEMP. I found in v$sort_usage that if the user perform some expansive SELECT operation with sorting - the TEMP tablespace is used.
Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory, space will be allocated in a temporary tablespace for doing the sort operation.
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.
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.
5 Ιουν 2012 · After copying the sparse 2GB file to /tmp/temp_huge_not_sparse.dbf and creating the temporary tablespace using that temp file with the REUSE option, we are assured that temp file has allocated all of its file system space and our database actually has 2GB of temporary space to work with.
Change the database default temporary tablespace to the new encrypted TEMP tablespace. ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp_enc; Drop the original TEMP tablespace.
