connect as oracle
1. $lsnrctl stop
2.TAKE FULL
EXPORT OF DATABASE
sqlplus "/as sysdba"
3.SQL>ALTER
SYSTEM ENABLE RESTRICTED SESSION;
4.SQL>SELECT
* FROM DBA_TABLESPACES WHERE TABLESPACE_NAME LIKE 'TEMP%';
5.SQL>CREATE
TEMPORARY TABLESPACE TEMPNEW tempfile '/bsckup/tempnew.dbf' size 800m autoextend
on extent management local;
6.select * from
dba_tablespaces where tablespace_name like 'TEMP%';
7.SQL>alter
database default temporary tablespace tempnew;
8.SQL>ALTER
TABLESPACE temp TEMPFILE OFFLINE;
9.SQL>DROP
TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;
10.SQL>CREATE
TEMPORARY TABLESPACE temp TEMPFILE '/TEMP/TEMP.DBF' SIZE 9200M
AUTOEXTEND ON
EXTENT MANAGEMENT LOCAL;
11.SQL>SELECT
* FROM DBA_TABLESPACES WHERE TABLESPACE_NAME LIKE 'TEMP%';
12.SQL>ALTER
DATABASE DEFAULT TEMPORARY TABLESPACE temp;
13.SQL>DROP
TABLESPACE TEMPNEW INCLUDING CONTENTS AND DATAFILES;
14.SQL>ALTER
SYSTEM DISABLE RESTRICTED SESSION;
exit from session
15.$lsnrctl start