Database Administration (MOSC)

MOSC Banner

Relocate temporary tablespace temp files from one file system to another file system

edited Aug 8, 2011 2:47AM in Database Administration (MOSC) 4 commentsAnswered

Hi,

Would you please let me know the procedure to relocate temfiles from one file system to another file system.  I know the following procedure to relocate the datafiles, but couldn't find it for tempfiles. It would be hepful if you can get back me at the earliest.

Regards

Suresh

Procedure for Renaming Datafiles in a Single Tablespace

To rename datafiles in a single tablespace, complete the following steps:

  1. Take the tablespace that contains the datafiles offline. The database must be open.

    For example:

    ALTER TABLESPACE users OFFLINE NORMAL;
    
    
  2. Rename the datafiles using the operating system.

  3. Use the ALTER TABLESPACE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center