Manage Temporary Files for the database

 Command

ALTER DATABASE

(1) Required Privileges
You must have the ALTER DATABASE system privilege.
To specify the RECOVER clause, you must also have the SYSDBA system privilege.

Creating a New Datafile:

Example

The following statement creates a new datafile tbs_f04.dbf based on the file tbs_f03.dbf. Before creating the new datafile, you must take the existing datafile (or the tablespace in which it resides) offline.

ALTER DATABASE CREATE DATAFILE 'tbs_f03.dbf' AS 'tbs_f04.dbf';

Manipulating Tempfiles:

Example

The following takes offline the tempfile temp02.dbf created in Adding and Dropping Datafiles and Tempfiles:

Examples and then renames the tempfile:

ALTER DATABASE TEMPFILE 'temp02.dbf' OFFLINE;

Command

ALTER DATABASE
(1) Required Privileges
You must have the ALTER DATABASE system privilege.
To specify the RECOVER clause, you must also have the SYSDBA system privilege.

ALTER DATABASE RENAME FILE 'temp02.dbf' TO 'temp03.dbf';
The statement renaming the tempfile requires that you first create the file temp03.dbf on the operating system.