15 Managing Datafiles and Tempfiles

In this chapter:

• Guidelines for Managing Datafiles

• Creating Datafiles and Adding Datafiles to a Tablespace

• Changing Datafile Size

• Altering Datafile Availability

• Renaming and Relocating Datafiles

• Dropping Datafiles

• Verifying Data Blocks in Datafiles

• Copying Files Using the Database Server

• Mapping Files to Physical Devices

• Datafiles Data Dictionary Views

  Note:

  Tempfiles are a special class of datafiles that are associated only with temporary tablespaces. Information in this chapter applies to both datafiles and tempfiles except where differences are noted. Tempfiles are further described in "Creating a Locally Managed Temporary Tablespace"

  See Also:

  • Chapter 17, "Using Oracle Managed Files" for information about creating datafiles and tempfiles that are both created and managed by the Oracle Database server

  • Oracle Database Concepts