Home > Administration > Temporary Tablesapce (TEMP) Full

Temporary Tablesapce (TEMP) Full

Fixing Procedure.

Turn it off and on. The temporary space are released.

1. Check current free space

SVRMGR>  select ‘FILE’,tablespace_name,sum(bytes) from dba_free_space
2> group by tablespace_name;
‘FIL TABLESPACE_NAME                SUM(BYTES)
—- —————————— ———-
FILE INDX                            167636992
FILE NETPG_DATA                     1012871168
FILE NETPG_INDEX                     497352704
FILE RBS                             801107968
FILE SYSTEM                           90705920
FILE TEMP                            117174272
FILE TOOLS                             8384512
FILE USERS                           514584576
FILE VIDEO                          5940887552
9 rows selected.

2. Turn it on/off

SVRMGR> alter tablespace temp offline;
Statement processed.
SVRMGR> alter tablespace temp online;
Statement processed.

3. Check free space now

SVRMGR> select ‘FILE’,tablespace_name,sum(bytes) from dba_free_space
2>  group by tablespace_name;
‘FIL TABLESPACE_NAME                SUM(BYTES)
—- —————————— ———-
FILE INDX                            167636992
FILE NETPG_DATA                     1012871168
FILE NETPG_INDEX                     497352704
FILE RBS                             801107968
FILE SYSTEM                           90705920
FILE TEMP                           1594617856 <–
FILE TOOLS                             8384512
FILE USERS                           514584576
FILE VIDEO                          5940887552
9 rows selected.
SVRMGR>

Advertisements
Categories: Administration
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: