1. Set the Database environment variables.
2. Connect to the target database:
$ sqlplus / as sysdba
3. Resize the temp datafile:
alter database tempfile '/u02/oradata/ORCL/temp2_01.dbf' resize 2G;
4. Example:
31 июл. 2014 г.
Decrease the size of TEMP Datafile in Oracle 10g
You can resize the temp datafiles using the following steps:
1. Set the Database environment variables.
2. Connect to the target database:
$ sqlplus / as sysdba
3. Resize the temp datafile:
alter database tempfile '/u02/oradata/ORCL/temp2_01.dbf' resize 2G;
4. Example:
1. Set the Database environment variables.
2. Connect to the target database:
$ sqlplus / as sysdba
3. Resize the temp datafile:
alter database tempfile '/u02/oradata/ORCL/temp2_01.dbf' resize 2G;
4. Example:
0 коммент.:
Отправить комментарий