Example of solution to Oracle temporary table space problem

Today, one of my buddies said that some of the modules in OA were invalid, check the system log, the original Oracle database temporary table space is full, noon meal time to the database restart (this way the easiest and not easy to make mistakes), did not think of temporary table space or there is a problem, followed by the following processing to be restored:

1, view the temporary table space size:

Select Name,to_char (bytes/1024/1024) | | M ' from V$tempfile;

The result shows a temporary table size of 0M, as shown below:

NAME to_char (bytes/1024/1024) | | M

/APP/ORACLE/ORADATA/METENOA/TEMP01.DBF 0M

2, and then looked at the database file mount status:

Select file#,name,status,enabled from V$tempfile;

Show status as Offline

Use the following statement for processing:

ALTER DATABASE Tempfile '/APP/ORACLE/ORADATA/METENOA/TEMP01.DBF ' online;

Then look at the temporary table status, shown below (online normal):

file# NAME STATUS ENABLED

1/APP/ORACLE/ORADATA/METENOA/TEMP01.DBF ONLINE READ WRITE

Then look at the size of the space, a numerical display, as follows:

NAME to_char (bytes/1024/1024) | | M

/APP/ORACLE/ORADATA/METENOA/TEMP01.DBF 351M

This article comes from "Life is not, fighting is endless!" "Blog, please be sure to keep this source http://soulful.blog.51cto.com/468033/1019660

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/