［精品］Oracle数据库管理.ppt

* Temporary Tablespaces (continued) Using Oracle Enterprise Manager to Create a Temporary Tablespace From OEM Console: 1. Navigate to Storage Tablespaces. 2. Select Create from the right-mouse menu. 3. Enter details in the General tabbed page. 4. Select the Temporary option in the Type region on the General tabbed page. 4. Click the Storage tabbed page, and enter the storage information. 6. Click Create. * * * Restrictions on Default Temporary Tablespace Dropping a Default Temporary Tablespace You cannot drop the default temporary tablespace until after a new default is made available. The ALTER DATABASE command must be used to change the default temporary tablespace to a new default. The old default temporary tablespace is then dropped only after a new default temporary tablespace is made available. Users assigned to the old default temporary tablespace are automatically reassigned to the new default temporary tablespace. Changing the Type of a Default Temporary Tablespace Because a default temporary tablespace must be either the SYSTEM tablespace or a temporary tablespace, you cannot change the default temporary tablespace to a permanent type. Taking Default Temporary Tablespace Offline Tablespaces are taken offline to make that part of the database unavailable to other users (for example, an offline backup, maintenance, or making a change to an application that uses the tablespace). Because none of these situations applies to a temporary tablespace, you cannot take a default temporary tablespace offline. * Read-Only Tablespaces The ALTER TABLESPACE [tablespace]READ ONLY command places the tablespace in a transitional read-only mode. In this transitional state, no further write operations can occur in the tablespace except for the rollback of existing transactions that previously modified blocks in the tablespace. After all of the existing transactions have been either committed or rolled back, the read-only command completes, and the tablespace is placed in rea