Clean up the temporary table space

2010-12-14  来源:本站原创  分类:Database  人气:75 

Method one.

Restart the library.

Method Two.

Modify the TEMP tablespace storage parameters, so Smon process concept note about temporary segment, to achieve the clean-up and TEMP table space purposes.

SQL> alter tablespace temp increase 1;

SQL> alter tablespace temp increase 0;

Method three.

Reconstruction of the temporary table space.

1 Create a temporary table space transit

create temporary tablespace TEMP1

TEMPFILE '/ xxx/xxx/temp02.DBF'

SIZE 512M

REUSE AUTOEXTEND ON

NEXT 1M

MAXSIZE UNLIMITED;

(2) change the default temporary tablespace for the just created a new temporary tablespace TEMP1.

alter database default temporary tablespace TEMP1;

3 Delete the original temporary table space.

drop tablespace temp including contents and datafiles;

4. Re-create the temporary table space.

create temporary tablespace TEMP

TEMPFILE '/ xxx/xxx/temp01.DBF'

SIZE 512M

REUSE AUTOEXTEND ON

NEXT 1M

MAXSIZE UNLIMITED;

5 Reset the default temporary tablespace for the new temp table space.

alter database default temporary tablespace TEMP;

6 Delete the temporary table space to use transit.

drop tablespace temp1 including contents and datafiles;

相关文章
  • Clean up the temporary table space 2010-12-14

    Method one. Restart the library. Method Two. Modify the TEMP tablespace storage parameters, so Smon process concept note about temporary segment, to achieve the clean-up and TEMP table space purposes. SQL> alter tablespace temp increase 1; SQL> alte

  • Compression skyrocketing ora10g temporary table space the size of the database 2010-08-09

    Recently discovered in the maintenance of ora10g database temporary tablespace data file from the original 512m temp.dbf soared to 5G, seriously taking up disk space. After repeated efforts, the total in solving problems, now check to the temporary t

  • Oracle Temp temporary table space handling 2011-05-01

    Temporary tablespace is the oracle in the temporary table space, temporary table space in the main use is to sort the database operations, management, indexing, access to views and other operating room to provide temporary operation, when operation i

  • OracleTemp processing temporary table space 2011-06-30

    Temporary tablespace is the oracle in the temporary table space, the main purpose is the temporary table space in database Sorting operation, management, indexing, access to views and other operating room to provide temporary operation, when operatio

  • Detailed OracleTemp temporary table space approach 2011-08-17

    Oracle table space with the introduction of collection, no introduction, the following problems for use in the solution set: Main purpose of the temporary table space is to sort the database operations, management of indexes, views and other operatio

  • oracle 9i temporary table space 2010-03-04

    Taken from: http://hi.baidu.com/zzztou/blog/item/f8733707008383c87b8947b3.html Normally, the complete Select statement, create index using the TEMP table space and some sort is done, Oracle will automatically release the temporary section of a swap o

  • Fill temporary table space is too large or total disk space problem solving 2010-03-15

    1. Create a new temporary table space CREATE TEMPORARY TABLESPACE temptest TEMPFILE 'C: \ temptest.dbf' SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4M; 2. To change the database default temporary tablespace Alter database default temporary tablesp

  • Create temporary table space 2010-05-10

    1.startup - Startup Database 2.create temporary tablespace TEMP2 TEMPFILE''/ home2/oracle/oradata/sysmon/temp02.dbf''SIZE 512M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED; - create a temporary table space transit 3.alter database default temporar

  • Temporary table space is too large to handle 2010-06-30

    Oracle temporary table space is mainly used for storage of a number of queries and data cache, the disk consumes a major cause is the need to sort the query results, if not mistaken, then the disk space (memory) allocation, Oracle uses the greedy alg

  • oralce temporary table space boom shows 2010-07-01

    Frequently asked temp table space skyrocketing, and how to recover temporary table space, because the different versions, apparently diverse methods, but these methods to show that palliative approach, only when deep understanding of temp Causes a ra

  • How to view the database's default tablespace, and temporary table space. (Turn) 2010-07-16

    How to view the database's default tablespace, and temporary table space. How to view the database's default tablespace, and temporary table space. Oracle system tables query Oracle data dictionary dict always belong to the user sys's. 1, the user: s

  • oracle create table space. create the user. to change the user default tablespace. delete the temporary table space 2010-08-28

    Create temporary table space create temporary tablespace stbss_tmp tempfile 'E:\oracle\product\10.2.0\oradata\orcl\stbss_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; Create a data table space create tablespace st

  • The role of the temporary table space 2010-10-22

    Oracle temporary table space is mainly used for query and storage of some of the buffer data. Temporary table space consumption is mainly due to the need for intermediate query results are sorted. Restart the database to free temporary tablespace, if

  • [Zhuantie] Oracle9i how to switch the temporary table space reconstruction and 2010-12-15

    Oracle9i introduces a global default temporary tablespace, the default if you do not specify a user temporary table space, Oracle will be for the user to specify the default temporary table space. First check the user's default temporary table space:

  • oracle temporary table space and table space 2011-01-11

    Oracle temporary table space is mainly used for query and storage of some of the buffer data. Temporary table space consumption is mainly due to the need for intermediate query results are sorted. Restart the database to free temporary tablespace, if

  • On the order. Sort_area_size. Temporary table space 2011-01-13

    Simple statement about: For each session, ranking first use sort_area_size, temporary table is used if insufficient space. But this is how the inside and in the end a process? Elaborate below, may be useful to everyone (if there is anything unclear o

  • oracle 10g create table space to create the user. to change the users default tablespace. delete the temporary table space 2010-08-28

    Create temporary table space create temporary tablespace stbss_tmp tempfile 'E:\oracle\product\10.2.0\oradata\orcl\stbss_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; Create table space create tablespace stbss log

  • The role of temporary table space 2010-10-22

    Oracle temporary table space is mainly used for query and store some data in the buffer. Temporary table space consumption is mainly due to the need for intermediate query results are sorted. Restart the database can release the temporary table space

  • [Zhuantie] Oracle9i how to rebuild the temporary table space with the switch 2010-12-15

    Oracle9i introduces a global default temporary tablespace, the default if you do not specify a user temporary table space, Oracle will provide the user to specify the default temporary table space. First check the user's default temporary table space

  • On sorting. Sort_area_size. Temporary table space 2011-01-13

    Simple to state: For each session, sort first used sort_area_size, temporary table is used if insufficient space. But there in the end is how a process? Described below, and maybe useful to everyone (if there is any clear or not the right place Welco