OraFAQ Forum: Server Administration » Renaming a tempfile - urgent please

Home » RDBMS Server » Server Administration » Renaming a tempfile - urgent please

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Renaming a tempfile - urgent please [message #179289]

Mon, 26 June 2006 14:15

orcl dba
Messages: 68
Registered: August 2005

Member

Hi all,

I am in the process of moving my database from one mount point to another. I have moved the datafiles, control files and redo log files to the new location. The problem starts when I try to rename a tempfile. The tempfile cannot be offlined or renamed as per the Oracle mannual.
Can someone help me how to rename the temp data file. It's very urgent.

Thanks in advance.

Report message to a moderator

Re: Renaming a tempfile - urgent please [message #179291 is a reply to message #179289]

Mon, 26 June 2006 14:21

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Create a new temp tablespace.
Make it default.
Drop the old.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/tspaces.htm#9566

Report message to a moderator

Re: Renaming a tempfile - urgent please [message #179294 is a reply to message #179289]

Mon, 26 June 2006 15:14

ebrian
Messages: 2794
Registered: April 2006

Senior Member

How did you move the SYSTEM datafiles without shutting down the database?

Report message to a moderator

Re: Renaming a tempfile - urgent please [message #179300 is a reply to message #179294]

Mon, 26 June 2006 15:51

orcl dba
Messages: 68
Registered: August 2005

Member

I did shutdown the database while moving the system and undo datafiles.

Report message to a moderator

Re: Renaming a tempfile - urgent please [message #179401 is a reply to message #179291]

Tue, 27 June 2006 05:33

orcl dba
Messages: 68
Registered: August 2005

Member

Thanks for the response Mahesh. I created a new ts, made it the default and dropped the old one.

Thanks

Report message to a moderator

Previous Topic:	Finding raw file size
Next Topic:	LRM-00109: could not open parameter file: ORA-01078

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:22:21 CDT 2024